OraFAQ Forum: Networking and Gateways » National Character Set issue in HSODBC (dg4msql).

Home » RDBMS Server » Networking and Gateways » National Character Set issue in HSODBC (dg4msql). (Oracle 11g Enterprise 11.2.0.1.0 - 64bit on GNU/Linux 2.6.32-358.el6.x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

National Character Set issue in HSODBC (dg4msql). [message #595715]

Fri, 13 September 2013 00:54

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi All,

Database : Oracle 11g Enterprise 11.2.0.1.0 - 64bit
Operating System : GNU/Linux 2.6.32-358.el6.x86_64

I've recently installed and configured HSODBC (dg4msql) gateway for Oracle to SQL Server. I'm able to select SQL Server's table's data in oracle except for National Character set columns (NVARCHAR2 of SQL Server).

Whenever I select SQL Server's NVARCHAR2 columns data in oracle it gives me protocol error and connection gets disconnected.

NLS_LANGUAGE	AMERICAN
NLS_TERRITORY	AMERICA
NLS_CURRENCY	$
NLS_ISO_CURRENCY	AMERICA
NLS_NUMERIC_CHARACTERS	.,
NLS_CHARACTERSET	AL32UTF8
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_DATE_LANGUAGE	AMERICAN
NLS_SORT	BINARY
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY	$
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_RDBMS_VERSION	11.2.0.1.0

Please guide me to resolve this issue.

Thanks & Regards
Manoj

[Updated on: Fri, 13 September 2013 01:41]

Report message to a moderator

Re: National Character Set issue in HSODBC (dg4msql). [message #595769 is a reply to message #595715]

Fri, 13 September 2013 06:52

sidhu.bhim
Messages: 3
Registered: September 2013
Location: India

Junior Member

Hi Manoj,

This is not a issue of SQL Server. It should be issue of SQL Developer. Please check whether same statement is working in SQL*Plus.

Thanks, Bhim

Report message to a moderator

Previous Topic:	listener configuration
Next Topic:	Forms not connect on Remote site

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 00:33:56 CST 2025