Can anyone help. I have a problem connecting to a version 7 database using the Oracle OLE DB provider.

I am creating an ADO connection in a VB.NET application using the Oracle OLE DB provider. The connection seems to work but as soon as I try to open a simple recordset I get the following error:

"ORA-24329: Invalid character set identifier".

The database is version 7 and the client is version 9i.

I thought this was an incompatability between the client and server character sets so I changed the client character set in the registry but still received the same error message. For information the server character set is WE8ISO8859P9.

Does anyone have any ideas about this?


Mark P