Google Answers: Connecting to an SQL 2000 database remotely over the internet using VB 6

View Question

Q: Connecting to an SQL 2000 database remotely over the internet using VB 6 ( No Answer, 2 Comments )

Question

Subject: Connecting to an SQL 2000 database remotely over the internet using VB 6
Category: Computers > Programming
Asked by: damobut-ga
List Price: $10.00

Posted: 20 Jan 2005 03:30 PST
Expires: 24 Jan 2005 05:15 PST
Question ID: 460336

Hi. I'm writing a Visual Basic 6 program to connect to an SQL 2000
database that is hosted on a server with a dedicated IP address. Is
there a way of connecting to this database over the internet from a
home PC using VB6. The application will hopefully allow me to connect
to the database and use the application to manage and upload new
content to the tables in the database. Can you give me an example of
the code to connect to such a database over the internet?

Answer

There is no answer at this time.

Comments

Subject: Re: Connecting to an SQL 2000 database remotely over the internet using VB 6
From: pondpine-ga on 20 Jan 2005 11:15 PST

You can define connection stirng:

Dim Conn As New ADODB.Connection

Conn.Open("Provider=sqloledb;Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;")
Define your ip, port for Data Source param and Catalog User ID and
Password for your login.

Subject: Re: Connecting to an SQL 2000 database remotely over the internet using VB 6
From: damobut-ga on 21 Jan 2005 01:26 PST

Hi, Thanks for that. If there is an SSL cert on the domain will it
affect access to the database?

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy