Data source name not found and no default driver s

Question

I am getting this error when I try to insert record in db. Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

my connection is :

Application("Db_ConnectionString")= "DSN=dsnname;UID=xxx;PWD=xxx;"

please help me asap. thanks in advance.

Answer 1

I got this error on Windows Server 2012 when migrating a legacy ASP app - I had to enabled 32-bit applications in the AppPool's advanced setting

Answer 2

this problem can be solve using install jdk 7 to download go to below link

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Java SE Development Kit 7u79

Product / File Description : Windows x86
Size: 138.31 MB
Download: jdk-7u79-windows-i586.exe

Answer 3

thanks for your answers.

I myself fixed the error. Assigned wrong dsn name in my code. I changed it and now its working fine

Answer 4

Have you setup "dsnname" in ODBC? Should be in Adminitrative Tools > Data Sources (ODBC) under the System DSN tab.