GwynforWeb
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\wt 13\webDB\P roject.acc db"
set conn =Server.CreateObject("adod b.connecti on")
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
%>
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\
set conn =Server.CreateObject("adod
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
%>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you need to show your code.
What I provided *should* work.
What I provided *should* work.
ASKER
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?