|
-
Mar 7th, 2001, 11:22 AM
#1
Thread Starter
New Member
See below, when i try to open my string "XML", i got this error
Run-time error '3709': The application requested an operation on an object
with a reference to a closed or invalid Connection object.
i'm on MDAC 2.6
I know there a bug report on Knowledge DB, but the solution is : install a
recent MDAC like MDAC 2.6. But i'm already on MDAC 2.6 !!!
If someone can help me.
Private Sub abd()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim os As ADODB.Stream
Dim strXML As String
On Error Resume Next
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
Set os = New ADODB.Stream
sConnectionString = cgsConnectionString & " Source=" &
"E:\F1\Data\F1.mdb"
cn.CursorLocation = adUseClient
cn.Open sConnectionString
rs.Open "Select * From Participant", cn
rs.Save os, adPersistXML
rs.Close
Set rs = Nothing
strXML = ostream.ReadText(adReadAll)
'***************
rs2.Open strXML
'***************
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|