Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

> 

  Return to Index