: Hi Everyone,
: I am new in SQL, I use the following connection String for connecting to SQL server on a local or network PC.
: Dim Conn as New ADODB.Connection
: Conn.ConnectionString "PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=MyUserName;PWD=Secret;DATABASE=MyDatabaseName"
: But I want to connect to a SQL Server over the internet
: I have changed the DATA SOURCE to the web address but that's
: not working.
: PLEASE TELL ME THE CONNECTION STRING FOR CONNECTING
: VB6 TO A SQL SERVER RUNNING ON THE INTERNET
: FOR EXAMPLE TO CONNECT MY VB6 APPLICATION TO
: A DATABASE ON WWW.FREESQL.ORG
Conn.ConnectionString "PROVIDER=SQLOLEDB;DATA SOURCE=http://www.freesql.org;UID=MyUserName;PWD=Secret;DATABASE=MyDatabaseName"
Please note i have put the full URL or link address in for
I believe you would need the http:// bit in too.
In the same way it is needed in HTML or XHTML.
By the way i'm guessing as i've not done SQL stuff in VB yet.
No harm giving it a try though eh?