This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / when I uploaded the database, how to refer to the location of the database. Thanks a loti uploaded Access databse, I want to know how to connect to the database. When I protype on my machine, i learned to use following code
Set Con=Server.CreateObject("ADODB.Connection")
Con.Open "*****DSN"
But when I uploaded the database, how to refer to the location of the database. Thank you very much.
-waokool(waokool);
2002-9-2
{317}
(#724653@0)
-
Further informatin of post above.I found sth.from Internet, and changed the code like following:
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DBQ=http://ftp.xxx/xxx/cxxo.mdb;DRIVER={MS Access (*.mdb)}"
objConn.Open
Now the following informatino display: Object required: ''
Give me some advice please. Thank u.
-waokool(waokool);
2002-9-2
{333}
(#724765@0)