ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified from Window Service

odbc sybase sap-iq
user1061732 picture user1061732 · Oct 23, 2013 · Viewed 14.8k times · Source

i have created a windows service which needs to connect to Sybase database using ODBC connection in regular intervals and process data. I am getting below error when i am trying to open ODBC connection in windows service class (say "StarterClass") method (Say "StartMethod").

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am sure that the connection string is fine. I gave my windows service reference to another test web application. And try to call same windows service class method.

The connection is opening successfully in debug mode. but when i deploy the service, its giving problem.

Kindly help me,

Regards

Venkat

Answer

bohica picture bohica · Oct 24, 2013

You probably defined a USER datasource instead of a SYSTEM datasource. When the service runs, it runs as a different user usually.

Related questions

The specified DSN contains an architecture mismatch between the Driver and Application. JAVA

I'm trying to connect to a database made by MS Access using Java, but I cannot seem to manage. I am using ODBC and I'm getting this exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an …

Read More
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I'm getting an error message that says : A problem was encountered while trying to log into or create the production database. Details: […

Read More
what is the difference between OLE DB and ODBC data sources?

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources ...You should use the CommandText property instead of the SQL property, which now exists primarily for compatibility with earlier …

Read More