When I use the following connection strings, the first one is working and the second is not working on my system. May I know the difference between these two connections strings?
DSN=ABCD;DATABASE=db1;UID=userid;PWD=passwd
and the second one
Data Source=ABCD;DATABASE=db1;UID=userid;PWD=passwd
Error thrown by second string
[unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)
I am new to using SQL Server, so confused the difference between DSN and Data Source
There can be many reasons as to why your second connection string is not working. You need to check Why do I get error "Data source name not found and no default driver specified"?
The ODBC Driver Manager relies on the Driver attribute to know which ODBC driver to load.
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句