March 13, 2010 at March 13, 2010 · Filed under enart.nnxj.comedit
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?Hi, Thanks for that. If there is an SSL cert on the domain will it
affect access to the database?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.#If you have any other info about this subject , Please add it free.# |
|
