Re: isql connects, tsql does not
Bernard Moreton <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | TNAUK |
| Message-ID | <[email protected]> |
Dear James,
Apologies for the delay - I've been out of office for a week - but thank you for
your detailed replies!
With regard to your BTW:
1
The initial response from osql was:
looking for odbc.ini and odbcinst.ini in /etc
reading "/home/mbm/.odbc.ini"
[tnauk] found in "/home/mbm/.odbc.ini"
found this section:
[tnauk]
Description = Live Membership database
Driver = FreeTDS
Servername =
Server = tnauk-sql
Address = 192.168.1.14
Port = 1433
Database = TNAUK
TDS_Version = 8.0
Language = us_english
TextSize =
Domain =
PacketSize =
Trace = yes
TraceFile = /tmp/trace.log
looking for driver for DSN [tnauk]
driver "FreeTDS" found for [tnauk] in .odbc.ini
found driver named "FreeTDS"
FreeTDS is not a readable file
looking for entry named [FreeTDS] in /etc/odbcinst.ini
driver "/usr/lib/odbc/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini
/usr/lib/odbc/libtdsodbc.so is a readable file
Using ODBC-Combined strategy
FreeTDS servername is "Server" (from /home/mbm/.odbc.ini)
looking for [Server] in /home/mbm/.freetds.conf
cannot read "/home/mbm/.freetds.conf"
looking for [Server] in /etc/freetds/freetds.conf
"/etc/freetds/freetds.conf" is a readable file
found this section:
osql.sh: no "host" entry found for [Server] in freetds.conf
2
When Servername is set (same as 'server ='), then
looking for odbc.ini and odbcinst.ini in /etc
reading "/home/mbm/.odbc.ini"
[tnauk] found in "/home/mbm/.odbc.ini"
found this section:
[tnauk]
Description = Live Membership database
Driver = FreeTDS
Servername = tnauk-sql
Server = tnauk-sql
Address = 192.168.1.14
Port = 1433
Database = TNAUK
TDS_Version = 8.0
Language = us_english
TextSize =
Domain =
PacketSize =
Trace = yes
TraceFile = /tmp/trace.log
looking for driver for DSN [tnauk]
driver "FreeTDS" found for [tnauk] in .odbc.ini
found driver named "FreeTDS"
FreeTDS is not a readable file
looking for entry named [FreeTDS] in /etc/odbcinst.ini
driver "/usr/lib/odbc/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini
/usr/lib/odbc/libtdsodbc.so is a readable file
Using ODBC-Combined strategy
FreeTDS servername is "tnauk-sql" (from /home/mbm/.odbc.ini)
looking for [tnauk-sql] in /home/mbm/.freetds.conf
cannot read "/home/mbm/.freetds.conf"
looking for [tnauk-sql] in /etc/freetds/freetds.conf
"/etc/freetds/freetds.conf" is a readable file
found this section:
[tnauk-sql]
host = tnauk-sql
port = 1433
tnauk-sql has address 192.168.1.14
DSN: tnauk
Server's hostname: tnauk-sql
Address: 192.168.1.14
Driver: /usr/lib/odbc/libtdsodbc.so
Attempting connection as tnauknrernard...
+---------------------------------------+
| Connected! |
3
If I take the 'Servername =' line out (it seems redundant, if the name is set up
in odbcinst.ini?), then again I get connect, with the servername found from
/etc/odbcinst.ini :
looking for odbc.ini and odbcinst.ini in /etc
reading "/home/mbm/.odbc.ini"
[tnauk] found in "/home/mbm/.odbc.ini"
found this section:
[tnauk]
Description = Live Membership database
Driver = FreeTDS
Server = tnauk-sql
Address = 192.168.1.14
Port = 1433
Database = TNAUK
TDS_Version = 8.0
Language = us_english
TextSize =
Domain =
PacketSize =
Trace = yes
TraceFile = /tmp/trace.log
looking for driver for DSN [tnauk]
driver "FreeTDS" found for [tnauk] in .odbc.ini
found driver named "FreeTDS"
FreeTDS is not a readable file
looking for entry named [FreeTDS] in /etc/odbcinst.ini
driver "/usr/lib/odbc/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini
/usr/lib/odbc/libtdsodbc.so is a readable file
"Server" found, not using freetds.conf
FreeTDS servername is "tnauk-sql"
tnauk-sql has address 192.168.1.14
DSN: tnauk
Server's hostname: tnauk-sql
Address: 192.168.1.14
Driver: /usr/lib/odbc/libtdsodbc.so
Attempting connection as tnauknrernard...
+---------------------------------------+
| Connected! |
Does this help?
- I'll work on, and hope to get Aubit4GL connected.
I hope Ubuntu will take on your 0.91 !
Bernard Moreton
IT Director, National Talking Newspapers and Magazines (TNAUK)
Charity registered in the UK 293656
DDI: 01 435 869 316
On 21/01/2012 19:27, James K. Lowden wrote:
> On Fri, 20 Jan 2012 13:42:13 +0000
> Bernard Moreton<[email protected]> wrote:
>
>> Found a bug in osql (Ubuntu 11.10 Server), corrected in local copy,
>> got reasonable results; in consequence set Servername=<NAME>
>> in .odbc.ini.
>
> Yes, this is fixed in the 0.91.
>
>> freetds.conf defines [global] tds version = 7.1 (for SQLServer 2000
>> 8.00) .odbc.ini sets TDS_version = 8.0
>> TDSVER not set
>> TDSDUMP shows
> ...
>> net.c:210:Connecting to 192.168.1.14 port 1433
>> (TDS version 4.2)
>
> http://www.freetds.org/82/userguide/tdshistory.htm
> http://www.freetds.org/82/userguide/choosingtdsprotocol.htm
>
> You almost stumped me, Bernard, because it's been a few years since
> 0.82. I suspect the problem is that "7.1" is meaningless to 0.82. It
> was called 8.0 in those days, before Microsoft released its
> documentation.
>
> There are only ever two choices for dealing with invalid input: halt or
> ignore. FreeTDS ignores in this case; it falls back to the default.
> That would explain why, whatever you do, you see 4.2.
>
> I'll share with you the warning I provide my coworkers: beware of the
> Google. When searching for documentation, look on the local machine
> *first*, because that is presumably where the documentation for your
> particular version is to be found. Using the 0.91 documentation so
> handy on the web will mislead you in subtle ways if you're using
> 0.82. That appears to be what sandbagged you.
>
> BTW, does osql indicate it uses freetds.conf? From your earlier post
> I'd guess not.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>