Data source name not found and no default driver specified

[ahartong]

I have a 3rd party app that I am trying to use that connects to an sql database. It runs as a service, and I have it running on one system, but cannot get it to run on other systems, that appear to have the exact some setup.

I have a dsn-less connection string that I am using to connect to the database.

I cannot start the service at all, each time I get the Data source name not found and no default driver specified error. I know I have a valid db and user setup, because the one machine that works(service starts, and interacts with the db) has a connection string that connects to the db on the bad pc.

So, it seems there is some other driver issue or permissions issue on the bad machine, because I know my db is ok.

I have tried updating my MDAC driver to 2.8(even though the working machine has 2.7 as did mine). Also reinstalled sql tools. Even tried using permissions on the service.

Any other ideas?

Thanks in advance.

 

[zemp]

With a dsn-less connection you may have some hardcoded values in your connection string that are not correct on other computers. I would double check the value and consider building and storing the connectin string for each installation. Or use a DSN connection.

BTW, this is more of a code problem. You might be better off in the forum for the language used.

zemp

 

[nshen]

How did the third party software connect to the database: ODBC, OLE, JDBC, XML or their own wired in protocol?
If you think they are using ODBC, you can turn on ODBC trace on the bad and on the good machine then compare the connection string of the two.
Regards, Nancy
(Never trust anything that has no connect info.)

 

[ahartong]

OK, I can try the ODBC trace to see what is happening. Never knew that existed.

I was just instructed to use a typical connection string. Here it is.

DRIVER={SQL Server};Server=ahartong-01\ahsql2;Database=ZOOTH;Uid=sa;Pwd=;