Garbage Return from 9i

[Jan]

Hi Forum.

Today our sysdba's moved from oracle 8 to 9i, and suddenly my applications doesn't work.

I tried to hook up a small app. with an OracleConnection, OracleDataset,a datasource and a DBgrid (3.4.6.1)

I can connect to the database, but if i make a simple query (select * from atable) i only get garbage returned.

I tried to upgrade to 4.0.3 but i got the same result : Garbage return.

Does anyone have some ideas ?

Thanks
Jan

 

[al0]

There is not enough information to have some ideas. For me 3.4.6.4 and 4.0.3 works with 9i (from 9.0.1.3 to 9.2.0.3 with those I have tested them) equally well. Guess, you have some problems with your installation of Oracle Client. Can you provide more information and describe your garbage as well.

 

[Marco Kalter]

Maybe it's an NLS_LANG / character set issue? Characters are converted between server and client (Oracle Net), and finally your application controls need to display these characters.

 

[Jan]

Thanks guys.

It was the character set setting. Everything works fine now.

Rgds
Jan