ADO connection over the internet

[jason]

Hi, i have built an application that sets and retrieves
information in a database. It works fine with a simple
ADO connection object/string when the db is on my
machine. But i ultimetly want to have the database on my
IPS's webserver where my application can access it over
the internet. It appears that MS remote is more complex
than i had originally thought. I use a single connection
object class for all my recordsets, so i thought i had
made it extremely simple to change once i moved the db...
I need help with determining which option i need to use to
easily connect to the database and what modifications
would have to be done to use this option
(RDS,RDO,TCPIP)... plz be detailed and use code examples.
My database has a dsn.

[Nam Kang]

Jason,

Take a look at these articles using RDS.

Q183609 SAMPLE: Rdsvb.exe Demonstrates How to Use RDS with Visual Basic
http://support.microsoft.com/support/kb/articles/q183/6/09.asp

Q245745 SAMPLE: RDS_Comp.exe Demonstrates How to Use RDS.Dataspace
http://support.microsoft.com/support/kb/articles/q245/7/45.asp

Hope that helps,
Nam

This posting is provided "AS IS" with no warranties, and confers no rights.