Avatar of GwynforWeb
GwynforWebFlag for Canada asked on

ASP DB code does not work for .accdb DB's, used to for .mdb. Do I need to install something?

The code below worked fine when I when I had .mdb Access databases , but when I try to run it with .accdb Access databases it no longer works, I get

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified

My guess is I have to install something on the server, any guesses?

<%  
dbstr = "Driver={Microsoft Access Driver (*.accdb)};DBQ=C:\InetPub\wwwroot\wt13\webDB\Project.accdb"
set conn =Server.CreateObject("adodb.connection")    
conn.Open dbstr
sql="select * from Users"
set rs= conn.execute(sql)
while not rs.eof
   Response.Write rs("UserName") & "</br>" & rs("Password") &"</P>"
   rs.movenext
wend
conn.close
%>
ASPMicrosoft AccessDatabases

Avatar of undefined
Last Comment
sammySeltzer

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
sammySeltzer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
GwynforWeb

Nope, now I get this

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

Found this though

"Enable 32-bit applications" needs to be enabled in the connection pool for the website, within IIS Manager 7."

on another site, any thoughts?
SOLUTION
cyberkiwi

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
sammySeltzer

you need to show your code.

What I provided *should* work.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck