Cross Server database connection

[ducky62]

Hi,
I'm trying to connect to a Access 97 Database through ASP. The Server my database is on is not the same server that my asp pages are on. Now when I try to connect to the database I get the following error:

Microsoft JET Database Engine error '80040e4d'

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

the connection line I am using to reference the database is:

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\CCOPR\Data\db2.mdb;Jet OLEDBatabase=c:\inetpub\

http://wwwroot\colo\power\system.mdw;"

and the paths are correct...

If you have any info as to what my problem is any help would be appreciated

thx
Derek

 

[vasah20]

You can't connect to an Access database from across servers. It needs to reside on the same server as the asp pages. The only way I think you can do this, is through RDS (i'm not sure), but in order to do that you would need to create a separate component.

hope this helps
leo

 

[ducky62]

Can you connect to an sql database between servers?

 

[ducky62]

also If I do have to use RDS can you recommend a good site which will tell me how to use it..

thx
Derek

 

[vasah20]

you can connect to a SQL database, across server, across the internet even. Check out the connectivity FAQ (faq333-178) and change the Data Source name to SQL Server's IP Address or whatever's applicable in your situation.

Personally - I've never really used RDS, I was researching it for an application that I was creating, but I wasn't able to find an extensive resource on it, so I scrapped the idea.

good luck to you.
leo