FreeTDS Development Group

["Hoellig, Peter" <Peter.Hoellig AT trane.com>]

" it's ok. Personally I always use TDS_Version explicitly but this is
not a problem (I imagine you used configure option)."

Wow, now I feel like an idiot. Setting TDS_Version in the odbc.ini file to 
8.0 is now giving me proper results. The original install must've used the 
configure option and thus didn't need the line. Inheriting systems is a 
wonderful thing.

Thanks very much for all of your help. 

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: Wednesday, September 23, 2009 3:56 AM
To: FreeTDS Development Group
Subject: Re: [freetds] SQL Server 2005 64-bit Connection oddities

2009/9/22 Hoellig, Peter <Peter.Hoellig AT trane.com>:
> Thanks for replying,
>
> I've now verified that I'm running 0.82 by removing the 0.64 files and 
> rebuilding and installing 0.82 again. So I'm definitely running that now. 
> I've also removed the PORT=1433 from the odbc.ini file.
>
> I figure that I should probably concentrate on getting ODBC only running 
> properly before I worry about whether or not I need combined. Reinstalling 
> did not change the inconsistent results problem. So I'm still able to isql 
> and running a query three times is going in patterns of correct results, 0 
> results, -1 results, repeat. I'm starting to run out of ideas, should I 
> start looking at unixODBC or is there something still suspect about my 
> setup? My odbc.ini and odbcinst.ini are as follows now:
>

At this time a TDSDUMP and some queries would be helpful. It would be
also useful a odbc trace (see
http://www.easysoft.com/support/kb/kb00945.html).


> odbc.ini
>
> [MSSQL]
> Description = database
> Driver = FreeTDS
> Server = xxx.xxx.xxx.xxx\Instance
> DATABASE = GSETP
>
> odbcinst.ini
> [FreeTDS]
> Description       = v0.82 with protocol v8.0
> Driver            = /usr/lib/libtdsodbc.so.0
> UsageCount        = 2
>
> Thanks again.

it's ok. Personally I always use TDS_Version explicitly but this is
not a problem (I imagine you used configure option).

freddy77

>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> Sent: Tuesday, September 22, 2009 5:04 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] SQL Server 2005 64-bit Connection oddities
>
> 2009/9/16 Hoellig, Peter <Peter.Hoellig AT trane.com>:
>> Hello, I've recently set up a MS SQL Server 2005 64bit (Win Server 2003
>> 64bit) database and I'm trying to establish a connection to it using
>> FreeTDS (Fedora box) so that a Java app can pull information out of it.
>> I've had FreeTDS running properly with a SQL Server 2000 for quite some
>> time now and that still works fine. I've tried both ODBC-only and
>> ODBC-combined methods of connecting and they receive different results.
>>
>>
>>
>> If I set up ODBC-combined then I'm able to tsql connect, but I cannot
>> isql connect. If I try with -v then all it says is "Could not connect to
>> the datasource".
>>
>>
>>
>> If I set up ODBC-only then I am able to isql connect properly. However,
>> when running queries I receive a lot of SQLPrepare and SQLExecute errors
>> along with inconsistent result sets for the same query.
>>
>>
>
> Regarding connection probably there is a configuration problem.
> Regarding result problems the key is probably update. Either ODBC (the
> standard) and unixODBC had problems with 64-bit (and well.. even
> FreeTDS but with a 0.82 you shouldn't have any problems).
>
>>
>> When I started this I was running FreeTDS .64 (and the errors were
>> occurring) so I figured that it would be a good idea to update so I
>> downloaded and installed .82. There were no problems during
>> installation, but I wouldn't discount something odd happening with my
>> configuration because of that. I've pasted my freetds.conf, odbc.ini,
>> and odbcinst.ini below. It's currently setup so that I can isql MSSQL
>> and get the odd results that I explained above.
>>
>
> Assure you are using 0.82 and not the previous version.
>
>>
>>
>> Thanks in advance.
>>
>>
>>
>> odbc.ini
>>
>> [MSSQL]
>>
>> Description =  database
>>
>> Driver = FreeTDS
>>
>> Server = xxx.xxx.xxx.xxx\Instance
>>
>> PORT = 1433
>>
>> DATABASE = GSETP
>>
>>
>
> Mm.... or server with instance or port, not both. Here you are not
> using freetds.conf (ODBC-only). I would add a TDS_Version entry.
>
>>
>> odbcinst.ini // looking at this is it possible I need to update the
>> driver separately from the program or something along those lines?
>>
>
> of course !
>
>> [FreeTDS]
>>
>> Description       = v0.63 with protocol v8.0
>>
>> Driver            = /usr/lib/libtdsodbc.so.0
>>
>> UsageCount        = 2
>>
>>
>
> /usr/lib/libtdsodbc.so.0 is our driver file.
>
>>
>>
>>
>> freetds.conf
>>
>> [global]
>>
>>        # TDS protocol version
>>
>> ;     tds version = 8.0
>>
>>
>>
>> ;     dump file = /tmp/freetds.log
>>
>> ;     debug flags = 0xffff
>>
>>
>>
>>      # Command and connection timeouts
>>
>> ;     timeout = 10
>>
>> ;     connect timeout = 10
>>
>>
>>
>>      text size = 64512
>>
>>
>>
>> [Test]
>>
>>      host = xxx.xxx.xxx.xxx
>>
>>      instance = Instance
>>
>>      tds version = 8.0
>>
>
> Not used by isql but by tsql
>
>
> bye
>  freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> The information contained in this message is privileged and intended only 
> for the recipients named. If the reader is not a representative of the 
> intended recipient, any review, dissemination or copying of this message or 
> the information it contains is prohibited. If you have received this 
> message in error, please immediately notify the sender, and delete the 
> original message and attachments.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
The information contained in this message is privileged and intended only for 
the recipients named. If the reader is not a representative of the intended 
recipient, any review, dissemination or copying of this message or the 
information it contains is prohibited. If you have received this message in 
error, please immediately notify the sender, and delete the original message 
and attachments.