Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle - Sql Server connectivity using ODBC

886681Sep 7 2011 — edited Sep 15 2011

Hi,

I am using ODBC (DG4ODBC) to connect Oracle and Sql Server. Oracle version is 11g and Sql Server is 2008. The whole set up is on windows 2008 server on a single machine.

The character set used by oracle is AL32UTF8

In the ODBC configuration file:
HS_LANGUAGE=AL32UTF8
HS_FDS_REMOTE_DB_CHARSET=UCS2

But when we send data from oracle to sql we get junk characters in sql. The columns on the sql side are nchar and nvarchar.

I have tried to get the data using SSIS and I was successful, but we need to use only ODBC

Please let me know if you need more info.

Any type of help will be highly appreciated.

Regards
Nitin

Edited by: 883678 on Sep 7, 2011 5:33 AM

Edited by: 883678 on Sep 7, 2011 5:36 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2011

Added on Sep 7 2011

#heterogeneous-connectivity

13 comments

2,311 views