Problems with connecting with ODBC source
-
I have a problem with connecting to a sql server with ODBC source. I can create this source without any problems in administration tools -> ODBC sources. But when I try to connect to the SQL server I get an error saying that the ODBC source name doesnt exist. I have tried to connect directly to server via Excel import data and it works well, but with ODBC source I get this error. Someone with any idea of the problem
-
I have a problem with connecting to a sql server with ODBC source. I can create this source without any problems in administration tools -> ODBC sources. But when I try to connect to the SQL server I get an error saying that the ODBC source name doesnt exist. I have tried to connect directly to server via Excel import data and it works well, but with ODBC source I get this error. Someone with any idea of the problem
-
Few possibilities: - Verify that the DSN name is written correctly when using DSN. - When creating the source, use test functionality to verify, that configuration is valid. - Try to use System DSN if you have used User DSN.
-I have verified it, everything is correct -Its tested and it is successfully connected -I have tried that Its just weird, i can create this odbc connection without any problems. but connecting with it just dont work i have gotten it to work in other places, but its this place i cant get it to work
-
-I have verified it, everything is correct -Its tested and it is successfully connected -I have tried that Its just weird, i can create this odbc connection without any problems. but connecting with it just dont work i have gotten it to work in other places, but its this place i cant get it to work
That's odd... Check that you don't have another DSN (system or user) with the same name. If not helpful: - delete the DSN - check from the registry that it's gone (
HKEY_CURRENT_USER\Software\ODBC\ODBC.INIorHKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI) - create it again (use a different name just in case) - again verify from registry that it's configured as it should be.