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.

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

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