OLD DB and ADO problems

Hello Colleagues,

During the last week, I sent an email which had the information of problem that we have right now.
Here is more brief and detail information about our problems.
If anyone out there already went through this, please let us know.

Thanks in advance!

Chris







OLE DB Provider Problem

Environment:

Windows 2000 Advanced Server
Internet Information Server 5
Visual C++ 6.5 sp3
ActiveX Data Object (ADO) MDAC 2.5
Microsoft OLE DB Provider for Oracle (MSDAORA) 2.50.4403.0
Oracle 8i data base created in UTF8 character encoding


Problem 1:

Microsoft OLE DB Provider for Oracle does not support Unicode

We have ASP pages and Visual C++ programs which use ADO and Microsoft OLE DB
Provider for Oracle (MSDAORA) to access data in an Oracle 8i database.  We
have created the Oracle 8i database with UTF8 character encoding so that it
can support all key writing systems in the world.  Our Visual C++ programs
are compiled with UNICODE defined and ASP internally uses Unicode.

Unfortunately Microsoft OLE DB Provider for Oracle does not work with data
bases encoded in UTF8.  According to Microsoft Support the current version
does not support UTF8 and the next version will not support UTF8 either.
Microsoft Support said that the following version would support UTF8 but the
timeframe is the end of this year.


Problem 2:

Oracle OLE DB provider for Oracle supports Unicode but it is not stable

If we replace Microsoft OLE DB Provider for Oracle with the latest version
of Oracle OLE DB provider for Oracle (OraOLEDB) then the Unicode support
works correctly.  We can correctly read and write Japanese data from/to the
data base and confirmed that the data is correctly stored in UTF8.
Unfortunately our tests have shown that the Oracle OLE DB provider for
Oracle is not stable so we are not able to switch to this provider.

Christian Kim
Program Analyst
e-mail: ckim@ecal.com
http://www.ecal.com
eCal Corporation
Penn Mutual Tower, 2nd Floor
520 Walnut Street
Philadelphia, PA 19106 
TEL: 215-627-5001, Ex.3727
Fax: 215-574-9481
"YOUR ULTIMATE INTERNET CALENDAR!"

Received on Monday, 24 July 2000 09:51:10 UTC