StefanoCarniel
Programmer
Hello everybody, I need to retrieve data from a database Oracle in a MFC application. I connect successfully to the database and set the sql command, but when I try to open the recordset I get the error "Invalid character" from Oracle. I don't know exactly if this is the right place to post this question. If not, please tell me which is the right one (if there is). I post the code:
conn.CreateInstance (__uuidof(Connection));
connessione->Open(<path to db>, <user>, <password>, adModeUnknown )
command.CreateInstance (__uuidof (Command));
command->ActiveConnection = conn;
command->CommandText ="SELECT * FROM myTable;";
table.CreateInstance (__uuidof (Recordset));
table->Open ((IDispatch *) command, vtMissing, adOpenStatic, adLockBatchOptimistic, adCmdUnknown);
...and here I get the error
Can you help me?
Thank you
Stefano
conn.CreateInstance (__uuidof(Connection));
connessione->Open(<path to db>, <user>, <password>, adModeUnknown )
command.CreateInstance (__uuidof (Command));
command->ActiveConnection = conn;
command->CommandText ="SELECT * FROM myTable;";
table.CreateInstance (__uuidof (Recordset));
table->Open ((IDispatch *) command, vtMissing, adOpenStatic, adLockBatchOptimistic, adCmdUnknown);
...and here I get the error
Can you help me?
Thank you
Stefano