I get and update data in the database (8i) using oo4o in MS Excel VBA. Data is in Latvian (NLS_LANG is AMERICAN_AMERICA.WE8ISO8859P1)
The code is:
Set OSes = CreateObject("OracleInProcServer.XOraSession")
Set ODb = OSes.OpenDatabase("test", "scott/tiger", 0&)
Set ODy = ODb.createdynaset("select ename from emp ", 0)
The problem is, when I get data (ename), or put data into OraPrameter object, all Latvian letters are converted to some simbols. The example of the result is: 'KredØta', where at the place of Ø, should be letter ī.
I've used this code for some years with Office 2000 and Oracle Client 8i, and everything was ok, but now I have Office 2003 and Client 10g, and it does not work :(