CODEWITHSUNDEEP
asp-classicodbcconnection-string
sara
sara

Reputation: 305

Data source name not found and no default driver specified

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.

Upvotes: 1

Views: 23291

Answers (4)

Chetan Bhagat
Chetan Bhagat

Reputation: 572

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

Upvotes: 0

Ian Routledge
Ian Routledge

Reputation: 4042

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

Upvotes: 1

sara
sara

Reputation: 305

thanks for your answers.

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

Upvotes: 2

Daniel Morritt
Daniel Morritt

Reputation: 1817

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

Upvotes: 0

Related Questions