I have this connection string that works for locallan connection:
[Highlight=VB]
ConnectionString = "Provider=MSDASQL.1;Password=" & sPWD _
& ";User ID=" & sUserName & _
";Extended Properties=""Description=strData;DRIVER=SQL Server;SERVER=" _
& "myServer" & _
";UID=strUSER;PWD=strPASS;DATABASE=myDB"""
VBCODE]

but i want to modify it to connect remotely (internet) to my DB....

do I only have modify "myServer" to "IP:Port//ServerName" ?