I have an application that connects to a SQL table but am having a problem. On my machine the link works fine - however, on another machine I get a message stating the ODBC defaults are not set.?
I set up a System DSN and the connection works fine (connection successful). However, if I try to link some tables using that DSN OR using SQL code (as follows - some statements, like DIM's, are omitted)...
... then I get the error. Not sure why the DSN connects fine but when I try to use to connect some tables it gives me the error?
Any suggestions are greatly appreciated...
I discovered the reason for the error. Seems when the DSN was created three items were not updated: ODBC.INI was missing the Driver32= setting (blank), and the registry was missing the DRIVER data value (Local_Machine/Software/ODBC/ODBC.INI/DriverName/DRIVER value (was blank) and /ODBCINST.INI/SQL Server/DRIVER value was also blank. I do not know why this was not updated when the DSN was created but filling in the blanks has resolved the issue.