Oracle Provider with Unicode support

[Cip]

Hello I need a .NET provider for Oracle with Unicode support. (I need
to view Asian characters)

1) I have tried the .NET Oracle Data Provider, but unfortunately I am
not using Oracle client version 8.1.7 or above. We are using
8.something, but it is not supported by this Provider. As a result, I
get exceptions when I try to use this provider.

Upgrading the client is NOT an option.


2) I have tried the .NET OleDB Provider for Oracle, but it does NOT
have Unicode support. Why is this? The .NET OleDB Provider for SQL
Server has unicode support and it works beautifully with Korean,
Japanese characters... I wonder why the provider for Oracle cannot do
this.


Are there any other options I have not looked at, or am I out of luck?

 

[Eric]

Embedded:

Hello I need a .NET provider for Oracle with Unicode support. (I need
to view Asian characters)

1) I have tried the .NET Oracle Data Provider, but unfortunately I am
not using Oracle client version 8.1.7 or above. We are using
8.something, but it is not supported by this Provider. As a result, I
get exceptions when I try to use this provider.

Upgrading the client is NOT an option.

Why? 8.0.5 - 8.1.6 is not supported (and one of the prime candidates for
why the .net provider would also not support it)

Be careful, however. The 9i client does not and will not let the client
connect to 7.3.4 databases and below

2) I have tried the .NET OleDB Provider for Oracle, but it does NOT
have Unicode support. Why is this?

Why don't Ford Focus's have seat warmers and Mercedes do?
The microsoft layer runs on top of the Oracle layer (OCI)(you can have the
MS driver but it won't do you any good without the Oracle Client). If you
use the tools provided by Oracle, they usually have unicode support.

The .NET OleDB Provider for SQL

Server has unicode support and it works beautifully with Korean,
Japanese characters... I wonder why the provider for Oracle cannot do
this.


Are there any other options I have not looked at, or am I out of luck?

You might try .net provider from Oracle (may not support 8.1.6 and below)
You can use the OLEDB provider from Oracle. (You may still have to install
the OleDb provider over the client)
You may want to try Oracle Objects for OLE (OO4O). I know this will work
(you still may have to install OO4O on the client)

It does not sound like you will succeed without installing some sort of
software.


You also should

 

[Cip]

You might try .net provider from Oracle (may not support 8.1.6 and below)
You can use the OLEDB provider from Oracle. (You may still have to install
the OleDb provider over the client)

Hi I went to the Oracle downloads page and only found two providers
for .NET: one was for 10i and one was for 9i.

I cannot seem to find anything that supports 8.

If anyone finds anything please let me know!

 

[Eric]

You can still download the oledb provider (it may be in archived products
for 8i) and use the generic oledb with the connection string provided in the
oracle docs.

If you can get the driver, I can give you some code.

You can download OO4O and just create a reference. That will work, too.