Hi all,
Good Morning, I wants to make a connection with our company remote server which is located in centralised place (shared). For that i am using the following connection string.
gConSample.Prov ider = "MS Remote;Remote Server=Http://x.x.x.x;Remote Provider=SQLOLE DB.1;UID=uid;Pw d=pwd;Data Source=xxx;DATA BASE=DB name"
gConSample.Open
Dim rstSQL As ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT * FROM Item_Master ORDER BY Item_Code"
The connection is established (ie State of connection is 1). Then the execution move into the next line like ...
Set rstSQL = gConSample.Exec ute(strSQL, , adCmdText)
Now i am getting the Error
RUN TIME ERROR '8447'
Internet Server Error
Please anyone guide me ...... thanks in advance. .. .
Ram
Good Morning, I wants to make a connection with our company remote server which is located in centralised place (shared). For that i am using the following connection string.
gConSample.Prov ider = "MS Remote;Remote Server=Http://x.x.x.x;Remote Provider=SQLOLE DB.1;UID=uid;Pw d=pwd;Data Source=xxx;DATA BASE=DB name"
gConSample.Open
Dim rstSQL As ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT * FROM Item_Master ORDER BY Item_Code"
The connection is established (ie State of connection is 1). Then the execution move into the next line like ...
Set rstSQL = gConSample.Exec ute(strSQL, , adCmdText)
Now i am getting the Error
RUN TIME ERROR '8447'
Internet Server Error
Please anyone guide me ...... thanks in advance. .. .
Ram