Once again I need your help folks.



The assignment is.......



An user enters some search criteria in an HTML form which comes from 

server1. The server1 receives the search criteria and then has to access 

some database server, which is not at the same physical location as that of 

the server1, for running the SQL query against. Make the search and get the 

results on the server1 and display the same to the user.





I would like to know the efficient way of doing this.



Thanks

The db server doesn't have to be on the same machine. In fact, it's more

secure

if it is on a different machine running a protocol other than TCP/IP. You

just

need access to the second machine.



Currently, I have an application setup in this fashion. The IIS50 webserver

is on a separate machine from the SQL70 server. The webserver talks

TCP/IP to the internet and Named Pipes to the SQL70 server. Access to

the SQL70 server is granted by SQL authentication.



If you don't control the db server, contact your system administrator and

have him setup access for you. Then use either a DSN or OLEDB connection

string to access the db server from your page2.



hth,



Dallas Martin







----- Original Message -----

From: "David E" <registerukh@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Saturday, December 09, 2000 6:26 PM

Subject: [asp_databases] Accessing remote database server from ASP





> Once again I need your help folks.

>

> The assignment is.......

>

> An user enters some search criteria in an HTML form which comes from

> server1. The server1 receives the search criteria and then has to access

> some database server, which is not at the same physical location as that

of

> the server1, for running the SQL query against. Make the search and get

the

> results on the server1 and display the same to the user.

>

>

> I would like to know the efficient way of doing this.

>

> Thanks

>

>