Snitz Forums 2000 - Code on one server access db on another

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Current Version (Old)

Code on one server access db on another

New Topic

Topic Locked

Printer Friendly

Author

Topic

xtce
Starting Member

Denmark
5 Posts

Posted - 07 May 2001 : 02:25:48

Hi all!

Has anyone experimented on the possibility of having all the code on one server and the database (Access) on another... Can't seem to figure out whether or not this is possible...

If possible - how do I assign the db in the config.asp?

quote:
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("??") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=??" '## MS Access 97

Thanx in advance..

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 07 May 2001 : 06:44:25

I'm pretty sure that unless the two servers are on the same domain or have a trusted relationship that you can't do this with Access.

You would need to create a DSN which pointed to the datasource on the other server (if possible)

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.28 seconds.