Connect to db on different server on same network

[chappi]

Hi,

I know this is probably something really simple, but I am going nuts trying to find references on this anywhere

I am moving parts of an intranet site to a new server. The database that the site is referencing still remains on the other server, which is not accessible to the web, outside the firewall. Now I am trying to connect to that database (which is Access, by the way). I have tried mapping drives, but had no success. I tried my luck with setting up DSN & ODBC, but can't figure that one out either. So, if anybody could help me out, I would REALLY appreciate it and it would definitely get me out of my constant stream of headaches.

J~

 

[Tarwn]

Ok, first off, if the web server is outside the firewall than your going to need to have a pass-through on the firewall to let the web server communicate through to the original server.
Second, since MS Access isn't a true database server (it's a file based system) I am pretty sure you are going to have to map a drive to the original system in order to access that access db. It would probably be easiest to use a DSN to the db on the mapped drive and the use that DSN for your connection string in your ASP pages.

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}

http://www.tiernok.com/

The never-completed website

 

[chappi]

Hi,

Thanks for your quick response.

Well, both servers are behind the same firewall. I tried mapping the drive and it just wouldn't work. I am not too familiar with setting up DSN. Could you give me an example on how to do it? That would be awesome.

Thanks :-D

 

[Tarwn]

Well, if you go to Administrative Tools, then Data Sources we se differant tabs for Data Sources. Go to the System DSN tab and select the Add button. Select the driver you want to use (ie, MS Access), click finish. We now have a window that pops up entitled ODBC Microsoft Access Setup
Give the DSN a name and description then click the select button. Locate the access db you plan on using and select it, then hit the OK button.

At this point you have a brand new System DSN. In order to use it simply use the name of the DSN as your connection string and the system should take care of everything else for you.

ps: If anyone see's anything off about this, please don't hesitate to correct me, it's been a while since I used DSN's so I may be misremembering something important.

-Tarwn

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}

http://www.tiernok.com/

The never-completed website