Snitz Forums 2000 - Connecting to a access DB over a network

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Connecting to a access DB over a network

New Topic

Topic Locked

Printer Friendly

Author

Topic

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 27 February 2005 : 16:19:31

I think this is possible, right guys? Using a connectiong string like

set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Ws1\Inventory.mdb"

to connect to the network share and then to the database.

But the database is on a Win 98 computer. So you can't really give the database read/write permission and the folder read/write permission.

So the win98 computer will have to be upgraded win 2000 or XP Pro to allow that correct?

Support Snitz Forums

DarkDrift
Junior Member

USA
126 Posts

Posted - 27 February 2005 : 17:07:53

nah just give it a mapped drive on the computer connecting to it...
so on the server map drive z: <example to that share
then it SHOULD be fine cause by default win98 gives full permission

http://www.xcalliber.com - The Future of Boards

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 27 February 2005 : 18:19:27

Alright cool. I'll try that.

So would you change the connection to "Data Source=z:\Inventory.mdb" ?
Or would you still refer to the win98 machine as "Data Source=\\Ws1\Inventory.mdb"?

Taking Ws1 as the name of the win98 machine on the network.

Support Snitz Forums

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 27 February 2005 : 19:26:00

Nevermind. Got it working using the "Data Source=\\Ws1\Inventory.mdb" connection. Thanks DarkDrift.

Support Snitz Forums

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.94 seconds.