Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADO calls to Oracle DB

385793Mar 18 2004 — edited Mar 18 2004
I am having an issue with this code running within VBA in an MS Access 2003 database.

Dim cxn As ADODB.Connection
Dim vWHSID As String
Dim strST As String

Set cxn = New ADODB.Connection
cxn.ConnectionString = "Provider=MSDAORA;Data Source=ASP.World;User ID=xxxxx; Password=xxxx;"

Dim rRst As New ADODB.Recordset
cxn.Open

strST = "SELECT ALL FK_WAREHOUSEID FROM SAASDB.AMMUNITION_ITEM; "

rRst.Open strST, cxn, adOpenStatic, adLockReadOnly, adCmdText

cxn.Close

I am getting a ORA-00911 errorcode back when the rRst.Open line is executed and I am not sure why. I can take that statement listed and it runs fine within SQL*PLUS Worksheet. I have verified my connection has opened as well.

Has anyone seen this result before? Can't find any GOOD help on errorcode other than you can't place commented out lines after the statement being executed. Anyone have any suggestions or tips?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2004
Added on Mar 18 2004
1 comment
423 views