crazdandconfusd
New Member
- Joined
- Feb 24, 2021
- Messages
- 2
- Office Version
- 365
- 2016
- Platform
- Windows
I had a working workbook with ODBC data connections to an SQL Server database. Each table updated their data from connections based on a parameter from a cell value selected from the list.
Example:
“SELECT * FROM Database.dbo.Employees Emp WHERE Emp.LastName=?”
I copied the workbook to try on another server with a different server name (which I updated) and everything else the same. The data connections were looking for a connection file(.odc). Updating the connection type to OLEDB seems to fix this. Now the connection parameter reference to the cell range is not seeing the value. The connection properties parameter for each list the sheet and cell and refresh when changed, but state there is no value when refreshed. Im not sure if I have to specify the cell value within each sql statement as the parameter or something else.
Example:
“SELECT * FROM Database.dbo.Employees Emp WHERE Emp.LastName=?”
I copied the workbook to try on another server with a different server name (which I updated) and everything else the same. The data connections were looking for a connection file(.odc). Updating the connection type to OLEDB seems to fix this. Now the connection parameter reference to the cell range is not seeing the value. The connection properties parameter for each list the sheet and cell and refresh when changed, but state there is no value when refreshed. Im not sure if I have to specify the cell value within each sql statement as the parameter or something else.