Hi Cetin,
You did now that I re-read it. But I did not undestand what you meant. I just remembered that whenever we had a double quote in an SQL passthrough statement to Oraqle, we always got errors.
Thanks for the help.
Regards,
Arriyel
>Glad you found. I remember I said that quotes might be the culprit in the first message:)
>Cetin
>
>>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.