ConnectinG REMOTE sql server FROM VB6
-
Hello All how can i connect to remote sql server FROM VB6 This is my sample connections strings Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim str As String On Error GoTo HAND cn.ConnectionTimeout = 30 Dim ConnString As String Method 1 -------- cn.Open "Trusted_Connection=yes;driver=SQL Server;server=20.19.69.13;database=XXXX;User Id=YYYYY;Password=ZZZZ" str = "Provider=SQLOLEDB.1;Server=23.19.69.13;Database=xxxx;Uid=yyyy;Pwd=zzzz" cn.Open str Method 2 -------- cn.Open "Provider=MS Remote;Data Source=XXXX;Remote Server=http://www.mysite.com;USER ID=XXX;PASSWORD=YYYY"
-
Hello All how can i connect to remote sql server FROM VB6 This is my sample connections strings Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim str As String On Error GoTo HAND cn.ConnectionTimeout = 30 Dim ConnString As String Method 1 -------- cn.Open "Trusted_Connection=yes;driver=SQL Server;server=20.19.69.13;database=XXXX;User Id=YYYYY;Password=ZZZZ" str = "Provider=SQLOLEDB.1;Server=23.19.69.13;Database=xxxx;Uid=yyyy;Pwd=zzzz" cn.Open str Method 2 -------- cn.Open "Provider=MS Remote;Data Source=XXXX;Remote Server=http://www.mysite.com;USER ID=XXX;PASSWORD=YYYY"