Database Access in ASP

[sicko]

Hey guys I was woundering if one of you all could help me. I know how to connect to a MS Access database with ASP but what I need to do is connect to a MS Access database on a different server (completely different box). Does anyone know how I would go about doing this? I've been told that it probably can't be done but it seems like there should be something that could do that. If anyone of you knows how I can connect to a MS Access database on another server please let me know. Or if you have a link to information which might help me that would also be greatly appriciated. Thanks for any help you guys can give me, sicko

[Grizzly]

Is this on an NT box? The application server (ASP server) can be totally seperate from the database server, even with MS Access. It just takes some extra configuration in the ODBC/DSN manager built into NT.

Go to Administrative Tools / Data Sources (ODBC) / System DSN
-Add an MS Access database.
-The next dialogue box will a database section with the following options:
*Select
*Create
*Repair
*Compact

Click on the "Select" button.
This will pull up a "browse" box, and if you'll notice on the lower right hand corner, you'll find a "Network" button. Click on that and you can map a network drive to the database server on your network.

So it's not a question of ASP having this ability, or Access having this ability, this is a middleware issue, aka...the ODBC driver. So like I said, it just takes a few extra steps when setting up the DSN.

[sicko]

Thanks for your help. I just found the "Network" button and was playing around with it trying to get it to work when I got your reply. Thanks for your help I should be able to handle it from here. Thanks again, sicko