ASP Problems

[edgarv]

hello,

I have an asp login page and it keeps giving me this error

Error Type:
Provider (0x80004005)
Unspecified error
/calendar/cal/dsn.asp, line 6


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
GET /calendar/cal/login.asp




my dsn.asp code looks like this

<%
dim dsn
dim Conn
dsn="DBQ=" & Server.Mappath("o12cal.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open dsn
%>

what am I doing wrong?

thanks

 

[DreXor]

are you redimming a variable from login.asp?

perhaps you're mapping incorrectly to the db? is the db located where login.asp is or where dsn.asp is?

try root relative on the db mappath like "/data/mydb.mdb"

DreX
aKa - Robert

 

[edgarv]

I checked the path and it is the correct path, I even put the db in the same folder (for testing purposes) and still the same. Is there an ADODB.Connection upgrade or something like that?

 

[DreXor]

just the mdac

http://www.microsoft.com/mdac

but the mdac/ADO would throw an error in that instance.

try making the connection via dsn, just for testing.


DreX
aKa - Robert