|
 |
asp_databases thread: Accessing A Database Through A Different Server
Message #1 by "Jared" <jwp@n...> on Thu, 15 Jun 2000 18:43:25
|
|
We are currently running IIS 4 on our web server and use DSN's to
connect to serveral Visual FoxPro databases which reside on the same web
server. What I would like to be able to do is have another server on our
network do the database crunching. I attempted to setup a DSN on the other
server but I didn't have any success accessing it from the ASP pages on the
web server. Is there any way that this can be done, and if so, how?
Thanks,
Jared
Message #2 by Kevin_Riggs@p... on Fri, 16 Jun 2000 10:40:22 -0400
|
|
Using the Visual FoxPro driver on your NT server, You should be able to use UNC
notation (\\computername) to access a server. Accessing another server in SQL
Server is as easy as putting in the IP address of the other machine; you might
want to try that.
KD
Message #3 by smartin@c... on Fri, 16 Jun 2000 17:19:30 -0400
|
|
The DSN gets created on the IIS server and points to the VFP files on the
second server.
> -----Original Message-----
> From: Jared
> Sent: Thursday, June 15, 2000 2:43 PM
> To: ASP Databases
> Subject: [asp_databases] Accessing A Database Through A
> Different Server
>
>
> We are currently running IIS 4 on our web server and use
> DSN's to
> connect to serveral Visual FoxPro databases which reside on
> the same web
> server. What I would like to be able to do is have another
> server on our
> network do the database crunching. I attempted to setup a
> DSN on the other
> server but I didn't have any success accessing it from the
> ASP pages on the
> web server. Is there any way that this can be done, and if so, how?
>
>
> Thanks,
> Jared
>
|
|
 |