[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] NVARCHAR Columns Dropped from Query Result
From:       Jason Lincoln <jlincoln () yahoo ! com>
Date:       2012-01-19 2:05:26
Message-ID: 42A32E4F-F6E9-4C98-B81E-73A8B2032ECD () yahoo ! com
[Download RAW message or body]

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

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]