I am stack in this same place.
Whenever i try to access Access database I get a error msg:
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/data/bank.asp, line 9
I am using the examples from Beginning ASP 3.0
I tried all of them.
I am logged in as admin
Access files are in the right directory c:\datastores
I noticed that each time I get an error in a line where the asp script
tries to access database:
<!--#INCLUDE FILE=3D"BankConn.asp"-->
<HTML>
<HEAD>
<%
Dim dcBank, rsBank
Set dcBank =3D Server.CreateObject("ADODB.Connection")
Set rsBank =3D Server.CreateObject("ADODB.Recordset")
dcBank.Open strConn <---- error line
BankConn.asp file:
<%
Dim strConn, strDatabaseType
' Use one of these lines, and comment out the other
strDatabaseType =3D "Access"
'strDatabaseType =3D "MSDE"
' Now use that to set the connection string
If strDatabaseType =3D "Access" Then
strConn =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DC:\datastores\Bank.mdb;" & _
"Persist Security Info=3DFalse"
Else
strConn =3D "Provider=3DSQLOLEDB;Persist Security Info=3DFalse;" & _
"User ID=3Dsa;Initial Catalog=3DBank;" & _
Initial File Name=3DC:\MSSQL7\Data\Bank_Data.mdf"
End If
%>
Do u guys have any ideas what is causing it?
Please help this is driving me crazy. I can not get it to work.
Thanks a lot
Oskar
View Cart
