Microsoft OLE DB Provider for ODBC Drivers (0x80004005) ERROR

I am trying to use ASP to Access an Access 2003 database
I am using windows XP profesional with IIS installed the error is

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's
found and no default driver specified

I have tried different ODBC drivers but which one should i use to get it working?

Could someone explain to me step by step what to do thanks.
mtipsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sachin_raoraneCommented:
You can use the connection string to open the connection with access2003

<%
Dim oCN
Dim strCon

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Projects\VirtualDirs\DS_App\Db\DS.mdb;Persist Security Info=False"

Set oCN = Server.CreateObject("ADODB.Connection")

oCN.Open strCon
%>

Note :
"Data Source=D:\Projects\VirtualDirs\DS_App\Db\DS.mdb" This should be the physical path where the MDB file is stored. You need to check your file path
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GawaiCommented:
what is your connection string to connect Access DB ?
post it here so we can find the problem
0
GawaiCommented:
try this one :

      strDB = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=;"
      strDB = strDB & "DBQ=C:/path/db/Access.mdb"

save this file as con.asp

and now u call the file:
<!--#include file="con.asp" -->
Dim strDB, objRs, objCon, strSQL
Set objCon = Server.CreateObject ("ADODB.Connection")
objCon.Open strDB
strSQL= "SELECT * FROM AccessTbl"
Set objRs = Server.CreateObject ("ADODB.Recordset")
objRs.Open strSQL, objCon,1,3

and so on......


0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

beenish_anwarCommented:
Try this

Set conn = Server.CreateObject ("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/filename.mdb")
0
Leo EikelmanDirector, IT and Business DevelopmentCommented:
The following microsoft doc lists the most common solutions to this problem:

http://support.microsoft.com/kb/306345/EN-US/


It could stem from not having permissions to use the dirvers.

Using an ODBC DSN

Insufficient Permissions to Read the DSN Registry Key
Grant the Windows NT 4.0 or Windows 2000 user account Read access to the specified ODBC System DSN registry key as follows:

1. Determine which account is used to process the request for the ASP page.
2. From the Start menu, click Run, type regedt32.exe, and then click OK to start Registry Editor.
3. In the HKEY_LOCAL_MACHINE window, browse to the HKLM\SOFTWARE\ODBC\ODBC.INI key. The ODBC.INI key contains a subkey for each ODBC SYSTEM DSN that is registered on the server.
4. Click the DSN registry key for the DSN that is specified in the ADO connection string.
5. From the Security menu, click Permissions.
6. Add the user account that you identified in step 1 to the list of users who can access this key, and select the Read check box for this user.
7. Click Apply, and then close Registry Editor.

Cheers,

Leo



0
timkerCommented:
I can recommend this site:
http://www.connectionstrings.com/

It has both OLEDB and ODBC connection strings for Access.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.