R
Ron
Hello,
I keep getting a runtime error with the following ado
routine that I run from a VB6 app - note: I tried it with
ref to mdac2.6 and mdac2.7 and mdac2.8. This worked once,
but it doesn't work anymore. I think I changed something,
either in the code or on the system. It crashes at
rs.Open...
mylocattest.txt is a simple text file with one line of
text. I can see it at http://localhost/mylocaltest.txt
Could anyone suggest what the problem might be? Maybe the
wrong args for rs.Open...?
Public Sub HttpData()
Dim Cnxn As ADODB.Connection, strCnxn As String
Dim rs As ADODB.Record, strFile As String
Set rs = New ADODB.Record
Set Cnxn = New ADODB.Connection
'strCnxn = "url=http://localhost/"
strCnxn = "url=http://myServerName/"
Cnxn.Open strCnxn
strFile = "mylocaltest.txt"
rs.Open strFile, Cnxn, adModeRead, adOpenIfExists
'rcFile.Open "http://cnfrkccmc001/mylocaltest.txt", ,
adModeRead, adOpenIfExists
rs.Close
Cnxn.Close
End Sub
Thanks,
Ron
I keep getting a runtime error with the following ado
routine that I run from a VB6 app - note: I tried it with
ref to mdac2.6 and mdac2.7 and mdac2.8. This worked once,
but it doesn't work anymore. I think I changed something,
either in the code or on the system. It crashes at
rs.Open...
mylocattest.txt is a simple text file with one line of
text. I can see it at http://localhost/mylocaltest.txt
Could anyone suggest what the problem might be? Maybe the
wrong args for rs.Open...?
Public Sub HttpData()
Dim Cnxn As ADODB.Connection, strCnxn As String
Dim rs As ADODB.Record, strFile As String
Set rs = New ADODB.Record
Set Cnxn = New ADODB.Connection
'strCnxn = "url=http://localhost/"
strCnxn = "url=http://myServerName/"
Cnxn.Open strCnxn
strFile = "mylocaltest.txt"
rs.Open strFile, Cnxn, adModeRead, adOpenIfExists
'rcFile.Open "http://cnfrkccmc001/mylocaltest.txt", ,
adModeRead, adOpenIfExists
rs.Close
Cnxn.Close
End Sub
Thanks,
Ron