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