Using DG4ODBC to MSSQL: Handling nvarchar columns
693892Mar 31 2009 — edited Apr 3 2009Hi All,
I'm brand new to the forum so please be gentle! I've tried numerous searches and can't find quite the info I need. Thanks in advance.
I need to be able to simply run select statements against data in a remote MSSQL database (host is in a different domain but not firewalled) from my (just upgraded) Oracle 10.2.0.4 database. I tried to do this with a 10.2.0.3 database using hsodbc and was successful with one major exception. The mssql data uses nchar and nvarchar datatypes. Only date and numeric columns were visible when I queried the table via the oracle db_link. I tried various of the universal unicode character sets in the HS_NLS_NCHAR parameter in my init.ora file but no joy. It would seem from the docs that nchar and nvarchar is not supported using the generic odbc connection?
Next try involves upgrading to 10.2.0.4 and installing the 11.1.0.7 gateways to use the Generic ODBC Gateway. I'm hoping someone can tell me whether this will allow me to see the nchar columns?
Or do I need to use the gateway specific to MS SQL Server? If so, does that require additional licensing?