Error with ODBC Connection

I am getting error as below: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have installed the ODBC driver to connect to SQL server. and i am trying to access my database.

connectionString ="Driver ={ ODBC Driver 11 for SQL Server}; DSN = VUM; Server = servername;Trusted_Connection = Yes;Database = databasename;";

what is the solution for issue.

Regards, user.

0
edit delete
are you sure?
asked user

1 answer

The most common reason that this connection attempt failed is that this DSN or ODBC data source attempted to make a connection using the TCP/IP sockets Net-Library, which is Dbmssocn.dll. Because the SQL Server is not listening for incoming connections for TCP/IP sockets clients, the connection fails. From ISQL/w, the second error message stated above would be returned. The OS Error is 10061, and the function call that failed was ConnectionOpen(connect()).


Fredericksburg Towing Service

0
edit delete
are you sure?
answered lagat mutua

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions