vbscript, Open remote Access database in ASP code

Open remote Access database in ASP code

Author	Message
Judy Sha #1 / 5	Open remote Access database in ASP code Hi, there: I have a problem trying to open an Access database on machine A from ASP code which runs on machine B. Code like: ----------------------------------- str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=\\machineA\db\test.mdb" set conn=Server.Createobject("adodb.connection") conn.open str ----------------------------------- does not work. Does anybody know how to resolve such kind of case? Thanks in advance! Judy
Sun, 16 Jan 2005 23:36:47 GMT

Alex Burd #2 / 5	Open remote Access database in ASP code is "db" a share on machine A? in the code that you have it has to be, otherwise you need to specify the full path including the drive. Alex Quote: > Hi, there: > I have a problem trying to open an Access database on > machine A from ASP code which runs on machine B. > Code like: > ----------------------------------- > str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA > SOURCE=\\machineA\db\test.mdb" > set conn=Server.Createobject("adodb.connection") > conn.open str > ----------------------------------- > does not work. > Does anybody know how to resolve such kind of case? > Thanks in advance! > Judy
Mon, 17 Jan 2005 00:02:55 GMT

Judy Sha #3 / 5	Open remote Access database in ASP code Yes, "db" is a shared folder on machine A. BTW, how to include the full path for a remote machine. I know for local folder, I can use like: ----------------------------------- str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\db\test.mdb" ----------------------------------- and it works. Just don't know what's that for remote machine. Thanks for your reply, Judy Quote: >-----Original Message----- >is "db" a share on machine A? in the code that you have it has to be, >otherwise you need to specify the full path including the drive. >Alex >> Hi, there: >> I have a problem trying to open an Access database on >> machine A from ASP code which runs on machine B. >> Code like: >> ----------------------------------- >> str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA >> SOURCE=\\machineA\db\test.mdb" >> set conn=Server.Createobject("adodb.connection") >> conn.open str >> ----------------------------------- >> does not work. >> Does anybody know how to resolve such kind of case? >> Thanks in advance! >> Judy >.
Mon, 17 Jan 2005 01:07:54 GMT

Alex Burd #4 / 5	Open remote Access database in ASP code For a remote machine it would be \\machineA\C$\db\testdb.mdb Quote: > Yes, "db" is a shared folder on machine A. BTW, how to > include the full path for a remote machine. I know for > local folder, I can use like: > ----------------------------------- > str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA > SOURCE=C:\db\test.mdb" > ----------------------------------- > and it works. Just don't know what's that for remote > machine. > Thanks for your reply, > Judy > >-----Original Message----- > >is "db" a share on machine A? in the code that you have > it has to be, > >otherwise you need to specify the full path including the > drive. > >Alex > >> Hi, there: > >> I have a problem trying to open an Access database on > >> machine A from ASP code which runs on machine B. > >> Code like: > >> ----------------------------------- > >> str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA > >> SOURCE=\\machineA\db\test.mdb" > >> set conn=Server.Createobject("adodb.connection") > >> conn.open str > >> ----------------------------------- > >> does not work. > >> Does anybody know how to resolve such kind of case? > >> Thanks in advance! > >> Judy > >.
Mon, 17 Jan 2005 02:43:32 GMT

Judy Sha #5 / 5	Open remote Access database in ASP code Thanks, Alex. I now find it's more likely a network permission problem instead of path issue. Judy Quote: >-----Original Message----- >For a remote machine it would be \\machineA\C$\db\testdb.mdb Quote: >> Yes, "db" is a shared folder on machine A. BTW, how to >> include the full path for a remote machine. I know for >> local folder, I can use like: >> ----------------------------------- >> str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA >> SOURCE=C:\db\test.mdb" >> ----------------------------------- >> and it works. Just don't know what's that for remote >> machine. >> Thanks for your reply, >> Judy >> >-----Original Message----- >> >is "db" a share on machine A? in the code that you have >> it has to be, >> >otherwise you need to specify the full path including the >> drive. >> >Alex >> >> Hi, there: >> >> I have a problem trying to open an Access database on >> >> machine A from ASP code which runs on machine B. >> >> Code like: >> >> ----------------------------------- >> >> str = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA >> >> SOURCE=\\machineA\db\test.mdb" >> >> set conn=Server.Createobject("adodb.connection") >> >> conn.open str >> >> ----------------------------------- >> >> does not work. >> >> Does anybody know how to resolve such kind of case? >> >> Thanks in advance! >> >> Judy >> >. >.
Mon, 17 Jan 2005 04:10:35 GMT

Page 1 of 1

[ 5 post ]