What is the difference between these two SQL Server connection strings -
when use following connection strings, first 1 working , second not working on system. may know difference between these 2 connections strings?
dsn=abcd;database=db1;uid=userid;pwd=passwd
and second one
data source=abcd;database=db1;uid=userid;pwd=passwd
error thrown second string
[unixodbc][driver manager]data source name not found, , no default driver specified (0) (sqldriverconnect)
i new using sql server, confused difference between dsn , data source
there can many reasons why second connection string not working. need check why error "data source name not found , no default driver specified"?
the odbc driver manager relies on driver attribute know odbc driver load.
Comments
Post a Comment