Accessing Remote Database

[nbanaji]

I am creating a VB Exe to access a database that is located over the Internet(remote access). How can I achieve access to remote databases?

[VorTechS]

The simplest method, is to make a connection using the ODBC Data Sources.

Add a system data source (System DSN) and choose the driver, let's assume SQL Server.

Enter the datasource name, a description and in the Server box enter the IP address of the server. Choose the appropriate authentication details and complete the process.

The only shortfall with this, is that it won't work over a proxy server (you'll have to setup a mapping to get it working)....

All you need to do then is make your application connect to the database using the datasource.

If you want to make your connection avoiding using DSN, then first use the DSN to make a connection and in the immediate window of your application, do a '? myADOConnection.connectionstring' and that will give you the basis of the connection string you need to make a truly remote connection.

Note: As far as I know you can only make a DSN'less connection using ADO

This may not be a perfect answer, but it should give you somewhere to start......