-
"trappable error occurred in an external object"
I am attempting to issue a simple SQL statement to an Access97 database. Below is some code from the ActiveX .dll I have created. (The msgboxes are for debugging purposes.) Just after ther msgbox displaying the SQL statement I receive the error.
'Open data source
Dim conn As New ADODB.Connection
'set the connection properties
conn.Properties("Data Source" = "ASPDatabase"
conn.Open
'open recordset
Dim oRS As New ADODB.Recordset
oRS.CursorLocation = adUseServer
oRS.LockType = adLockReadOnly
MsgBox strSQL
oRS.Open strSQL, conn, adOpenForwardOnly, adLockOptimistic
MsgBox "oRS.Open"
I have tried variations of the cursor and lock types, but nothing works. I new to ASP and would appreciate any help with this. I am currently developing with ASP using Microsoft Personal Webserver 4.0 on a Windows 95 machine.
Thank you.
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
|
|