Skip to Content.
Sympa Menu

freetds - Re: [freetds] NVARCHAR Columns Dropped from Query Result

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jason Lincoln <jlincoln AT yahoo.com>
  • To: Jason Lincoln <jlincoln AT yahoo.com>
  • Cc: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] NVARCHAR Columns Dropped from Query Result
  • Date: Wed, 18 Jan 2012 20:05:26 -0600

It appears the problem is with Oracle heterogenous database connectivity and
not with unixODBC or FreeTDS. I'm still at a bit of a loss as to why it was
working flawlessly before the SP3 patch with FreeTDS 0.64.

On Jan 16, 2012, at 3:48 PM, Jason Lincoln wrote:

> My freetds/unixODBC Oracle XE Heterogenous database connectivity setup was
> working great until SP3 came along recently. I was unable to connect until
> I upgraded to the latest freetds version (0.91) using tdsver=7.1. Now I am
> able to connect to SQL Server from Oracle using unixODBC/freeTDS but
> columns are dropped. Seriously. I can run a query in SQL Developer on
> Windows with a connection to the SQL Server DB and get all the columns in
> the table but when I run the same query (select * from ...@mssql) from an
> Oracle DB it drops all nvarchar columns.
>
> Anyone have any suggestions?
>
> Thanks,
> Jason




  • Re: [freetds] NVARCHAR Columns Dropped from Query Result, Jason Lincoln, 01/18/2012

Archive powered by MHonArc 2.6.24.

Top of Page