Re: SQL Server 2005 64-bit Connection oddities

2009/9/22 Hoellig, Peter <[email protected]>:
> 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: [email protected] [mailto:[email protected]] 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 <[email protected]>:
>> 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
> [email protected]
> 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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds