Click to See Complete Forum and Search --> : More elementary questions!


solafide
12-08-2004, 10:03 AM
I want to know what this DSN thing is. DO I need it for just a .mdb? How do I do that on the remote server? THank you for your help!

Billy

buntine
12-08-2004, 09:02 PM
You can use a DSN-less connection by just specifying the driver and path of the database.

Dim connString
connString = "DBQ=" & Server.MapPath("path/database.mdb") & ";" & _
"Driver={Microsoft Access Driver(*.mdb)}"

To my knowledge, you cannot use a DSN from another server. And note, Server.MapPath only refers to the local server. Im not sure whether you can use an explicit URI.

Regards.

solafide
12-11-2004, 12:03 PM
I then go Server.CreateObject('ADODB.Connection').Open(connString); ? Also, what is the equivalent of &_ in javascript ASP? Or how do I change languages , since it is <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> right now? Thank you for your help!

Billy