ADO calls to Oracle DB
385793Mar 18 2004 — edited Mar 18 2004I 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?