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')   && class we use for record handler
>
>lcSqlCmd = 'SHAPE {SELECT * FROM "MyTable"} AS TestTable'
>oResultRS = oRecH.InitRecordSet(3, 3, 3, lcSqlCmd, oConnect)
>oResultRS.Close()
>

>
>Any help is greatly appreciated.
>
>Thanks,
>Arriyel