Hi Terry,
Thanks for the tool. It simplified the debugging process.
I found the problem, it seems that Oracle doesn't like double quotes. When I removed all the double quotes from my shape command, it worked. Te shape syntax sample I saw always placed the table names between double quotes so I was doing the same thing (it works fine in MS SQL).
Thanks again.
Regards,
Arriyel
>This download #
9840 , provides a GUI to test ADO calls. It will help analyze the data and SQL.
>
>>Hi,
>>
>>I have the following code to create an ADO Shape recordset. Everything is well until it tries to create the recordset. I keep getting a 'table or view does not exist' error message. Code below is the simplified version I use to make sure that the recordset gets created.
>>
>>oConnect = CREATEOBJECT('adodb.connection')
>>
>>oConnect.ConnectionString = "Provider=MSDataShape.1;Persist Security Info=False;Data Provider=OraOLEDB.Oracle.1;Data Source=DEMO;User ID=moad_test;Password=moad_test;PLSQLRSet=true"
>>
>>oConnect.Open
>>
>>oRecH = CREATEOBJECT('veRecHandler')
>>
>>lcSqlCmd = 'SHAPE {SELECT * FROM "MyTable"} AS TestTable'
>>oResultRS = oRecH.InitRecordSet(3, 3, 3, lcSqlCmd, oConnect)
>>oResultRS.Close()
>>
>>
>>Any help is greatly appreciated.
>>
>>Thanks,
>>Arriyel
Speak using soft and sweet words in case you have to eat them later.