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

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -