The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
I am new to ASP . im doing a tutorial on ASP and when i get to the point where i call my file i receive this error from the browser. i have no idea what to do HELP!!
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/asptestsite/mytestsite/database.asp, line 39
this is the script im running :
<%
strDBVirtualPath = "/iishelp/iis/htm/tutorial/EECustmr.mdb"
strDBLocation = Server.Mappath(strDBVirtualPath)
strSource = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strDBLocation
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strSource
SQLQuery = "SELECT * FROM Customers"
Set rsCustomersList = objConnection.Execute(SQLQuery)
%>
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/asptestsite/mytestsite/database.asp, line 39
this is the script im running :
<%
strDBVirtualPath = "/iishelp/iis/htm/tutorial/EECustmr.mdb"
strDBLocation = Server.Mappath(strDBVirtualPath)
strSource = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strDBLocation
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strSource
SQLQuery = "SELECT * FROM Customers"
Set rsCustomersList = objConnection.Execute(SQLQuery)
%>
Have you tried using a file dsn as opposed to a system dsn?
No idea what OS you are running, but for a start, visit
http://www.microsoft.com/data/download.htm , scroll down to Data Access Utilities and download/install Jet 4.0 Service Pack 3 Update. The error message you are getting is basically saying it cant find the driver or its corrupt.
Of course if you're running win2k or XP, should already have this version.
http://www.microsoft.com/data/download.htm , scroll down to Data Access Utilities and download/install Jet 4.0 Service Pack 3 Update. The error message you are getting is basically saying it cant find the driver or its corrupt.
Of course if you're running win2k or XP, should already have this version.
While I've never touched ASP code in my life, I would guess that your database isn't set up in ODBC correctly, or you're not referring to the right name. I'm afraid others will have to help you :O/
I am new to ASP . im doing a tutorial on ASP and when i get to the point where i call my file i receive this error from the browser. i have no idea what to do HELP!!
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/asptestsite/mytestsite/database.asp, line 39
this is the script im running :
<%
strDBVirtualPath = "/iishelp/iis/htm/tutorial/EECustmr.mdb"
strDBLocation = Server.Mappath(strDBVirtualPath)
strSource = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strDBLocation
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strSource
SQLQuery = "SELECT * FROM Customers"
Set rsCustomersList = objConnection.Execute(SQLQuery)
%>
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/asptestsite/mytestsite/database.asp, line 39
this is the script im running :
<%
strDBVirtualPath = "/iishelp/iis/htm/tutorial/EECustmr.mdb"
strDBLocation = Server.Mappath(strDBVirtualPath)
strSource = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strDBLocation
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strSource
SQLQuery = "SELECT * FROM Customers"
Set rsCustomersList = objConnection.Execute(SQLQuery)
%>