Not sure if this is the correct location. I have a connection to Oracle 10g in VBA. The connection string is correct.
When the sql statement is "Select sysdate from dual" and executed by a recordset.OpenRecordset(): this returns a value as I would expect.
When the sql statement is "Select * from mytable" (which is a table created in my schema which I create and which I can query with THAT query in SQL Developer just fine) and execute by a recordset.OpenRecorset(): 3146 (ODBC--call failed)
I'm using ODBC and the ODBC Version is "Microsoft ODBC for Oracle".
3146 seems to indicate that the driver doesn't support SOMETHING but I don't know what, it's not like these are super-complicated queries here. I can query dual, heck I can even run "select * from user_tables" and get back information.
Thoughts?
Erin