Connect to Oracle8i using OLEDB 1

[thchng]

Maybe a stupid question:
I try to connect to Oracle8i using Oracle OLEDB Provider, the connection is successful, however, when I try to build a recordset from the connection using code like that:

rs.Open SqlString, Connection, adOpenStatic, adLockReadOnly

It always prompt me following error:
ORA-00911: Invalid character.

I doubt that maybe the error is due to character set, so I build same table in another database with character set of American. (The orginal one is UTF8.) Unfortunately, the same error still occurs. What can I do to deal with the error? Please help.

 

[vbvictim]

Yes, get the actual sql string that is being passed and paste it into SQL Plus. I find building the sql string to be quite tedious and often I have errors with inserting needed quotes and commas............. I find the simplest way to see if it is my sql or some other problem (other than the cut and paste mention above) is to insert a real simple sql like "select * from tablename". There is not too much that can go wrong with this statement. If it runs, then your problem has to be with the statement you're trying to create.