I want to have my asp pages on my server and connect to a database on another server.  I 

am wondering if this is possible.  So the pages with the code could be at www.something.com 

and the database could be at www.database.com, can I connect to it, or does it have to be on 

the www.something.com server? 



Thanks,

M. Sherman

what kind of db?



if it is sql then you can access it through the server ip or name. like:

"Provider=SQLOLEDB;Password=pass;User ID=DOdorisio;Initial

Catalog=Hausers;Data Source=server1.odorisio.local;"

(ole db connstring i use on my dev server)



if it is access then i guess you could uhh.. i think it would need to be on

the same server.



daniel



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

From: M. Sherman [mailto:msherman@d...]

Sent: Friday, May 18, 2001 4:21 PM

To: ASP Databases

Subject: [asp_databases] Connecting to a database on another server.





I want to have my asp pages on my server and connect to a database on

another server.  I

am wondering if this is possible.  So the pages with the code could be at

www.something.com

and the database could be at www.database.com, can I connect to it, or does

it have to be on

the www.something.com server?



Thanks,

M. Sherman

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I want to have my asp pages on my server and connect to a

: database on another server.  I am wondering if this is possible.

: So the pages with the code could be at www.something.com

: and the database could be at www.database.com, can I connect

: to it, or does it have to be on

: the www.something.com server?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



What type of database is it?

If it's SQL Server then you could connect by TCP/IP, provided the firewalls

etc allow connections on port 1433 (or whatever SQL Server is using). You

need to look at what capabilities the DB in question has...



Cheers

Ken