Recently developed a project, you have to use VB ADO to access SQL Server on WAN, try a lot of ways but have not succeeded. The access code is as follows:
fconnectionstring = "provider = SQLOLEDB.1; DATA SOURCE =" &
Remote server IP or domain name & _
"; Initial catalog = info; persist security info = true; user ID = sa;" & _
"Password =" &
Database Password & "; Connect Timeout = 15"
Plus the port number 1433 is not used, the brothers save me, let me get out of the sea soon!
Very urgent!
