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)
National Character Set issue in HSODBC (dg4msql). [message #595715] Fri, 13 September 2013 00:54 Go to next message
Manoj.Gupta.91
Messages: 194
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 Go to previous message
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
Previous Topic: listener configuration
Next Topic: Forms not connect on Remote site
Goto Forum:
  


Current Time: Sat Sep 20 07:04:58 CDT 2014

Total time taken to generate the page: 0.08714 seconds