accessing remote SQL server database

I have to connect to a SQL server database held on our network from a hosted
server that we rent. I have written a VB6 application for use in the
business and we need to be able to connect a website to it so that field
agents can connect view there diary from the backend database. We dont want
to have two databases where we have to update the web version every night.
We are going top open a port in the firewall from the web server, what i want
to know is how easy is it to connect via ado to a database on our network.
and what types of things would i have to do to accomplish it, ie redirects
etc.

thanks for the help in advance

Re: accessing remote SQL server database

steven scaife wrote:
> I have to connect to a SQL server database held on our network from a
> hosted server that we rent. I have written a VB6 application for use
> in the business and we need to be able to connect a website to it so
> that field agents can connect view there diary from the backend
> database. We dont want to have two databases where we have to update
> the web version every night. We are going top open a port in the
> firewall from the web server, what i want to know is how easy is it
> to connect via ado to a database on our network. and what types of
> things would i have to do to accomplish it, ie redirects etc.
>

Basically, just do it the same way you do it in VB: use a connection string
that specifies the native SQL Server OLE DB provider
(http://www.aspfaq.com/show.asp?id=2126) and open a connection.

Here is a list of problems that can arise.
http://www.aspfaq.com/show.asp?id=2009

The article contains info about both Access and SQL Server, so make sure you
carefully read it (and follow the links to the KB articles) to avoid missing
any of the SQL Server information.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"