|
 |
asp_web_howto thread: Server Question - Please help!
Message #1 by info@e... on Wed, 17 Oct 2001 02:27:00
|
|
Does anyone know if it is possible to acess a SQL database that is on
another server? I have a ASP application that uses a SQL server 2000
database. Now, the database server will be located internally, it is my
own server. The other server will have the ASP pages and the images but
will be hosted by another company. What do I have to do to the external
server that will host the ASP? How can I make this work? I would
appreciate instructions.Thanks in advance!
Regards,
Elmer M.
Message #2 by Ludwig Brandon-FBL017 <Brandon.Ludwig@m...> on Tue, 16 Oct 2001 23:08:35 -0400
|
|
If you can create a DSN on the server hosting the application that points to
the SQL server-do that. Or if you put DSNless-you can put the server name or
IP in the connection string. If the SQL server is behind a firewall-you'll
have to see if the SQL port can be opened.
Brandon Ludwig
Brandon.Ludwig@M...
-----Original Message-----
From: info@e... [mailto:info@e...]
Sent: Tuesday, October 16, 2001 10:27 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Server Question - Please help!
Does anyone know if it is possible to acess a SQL database that is on
another server? I have a ASP application that uses a SQL server 2000
database. Now, the database server will be located internally, it is my
own server. The other server will have the ASP pages and the images but
will be hosted by another company. What do I have to do to the external
server that will host the ASP? How can I make this work? I would
appreciate instructions.Thanks in advance!
Regards,
Elmer M.
Message #3 by "Enzo Zaragoza" <enzaux@g...> on Wed, 17 Oct 2001 22:02:00 +0800
|
|
Elmer,
Yes, it is possible to have it on the different machines.
I got this information from http://www.able-consulting.com/ado_conn.htm ,
it's a great site for connection string examples. I got this from Tony
before
Enzo
Message #4 by info@e... on Thu, 18 Oct 2001 05:37:23
|
|
Thanks everyone! I will try both suggestions to see which is better.
Thanks again!
Regards,
Elmer M.
Message #5 by "ricahrd todd" <rmtodd@b...> on Thu, 18 Oct 2001 19:00:28
|
|
you will require the SQL server tools on your machine to be able to access
the sql server accross the network, the client tools will install the MDAC
components you requre to make odbc connections to servers.
if you want to connect to the ASP site you will probably need something
like frontpage 2000 or visual interdev for altering the site.
hope this helps
|
|
|
View Cart
