FreeTDS Development Group

["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:

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.

-----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.