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"
Conn.Open

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

Thanks

: 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"
: Conn.Open
:
: 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
:
: Thanks


Try

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

www.freesql.org

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?


Regards,

Dr M

thanks doctor but i've tried it before you said... but that's not working ha ha ha

it should work but it do not
Umer Saleem
Lahore - Pakistan
luckyumer@yahoo.com
Mob: 0092 321 4257504