freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Unable to connect to Data Source using iodbctest
- From: Daniel Fazekas <fdsubs AT axelero.hu>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Unable to connect to Data Source using iodbctest
- Date: Wed, 22 Sep 2004 18:07:58 +0200
On Sep 22, 2004, at 17:42, Lee, Gary wrote:
- Yes, version 8 for MS SQL SERVER 2000, as can be found in many places in the documentation. But I tried 4.2 and 7 also with no luck.
It's not "8", it's "8.0"
Corresponding manual entry:
<http://www.freetds.org/userguide/freetdsconf.htm#TAB.FREETDS.CONF>
- "Why you need this?" So the drivers and iodbctest program can find the files.
They do not need environment variables for that if you keep everything in the default directories established at compile time.
- "Read the manual" - Oh, gee, never thought of that. Maybe next time you could point to a document or section that would be helpful.
Most likely it's the FreeTDS manual's ODBC section:
<http://www.freetds.org/userguide/prepodbc.htm>
More specifically, you seem to be looking for an ODBC-only setup, without taking advantage of the freetds.conf file:
<http://www.freetds.org/userguide/odbcinionly.htm>
I think your problem is due to one of the following:
- Try "Server" instead of "Host" and is "qa1" a working name on your system? Why did you use a numerical address in the freetds.conf + tsql test?
- Since you are setting up ODBC to ignore your freetds.conf entry, and you also don't have a global TDS version override specified in freetds.conf, the TDS version used will be determined by the compile-time default. If you haven't told the configure script otherwise, it will be 5.0 which is incompatible with MSSQL servers.
Add a TDS_Version setting to your odbc.ini as detailed in the FreeTDS manual.
--
fds
-
[freetds] Unable to connect to Data Source using iodbctest,
Lee, Gary, 09/21/2004
- <Possible follow-up(s)>
- RE: [freetds] Unable to connect to Data Source using iodbctest, ZIGLIO, Frediano, VF-IT, 09/22/2004
-
RE: [freetds] Unable to connect to Data Source using iodbctest,
Lee, Gary, 09/22/2004
- Re: [freetds] Unable to connect to Data Source using iodbctest, Daniel Fazekas, 09/22/2004
- RE: [freetds] Unable to connect to Data Source using iodbctest, Lowden, James K, 09/22/2004
- RE: [freetds] Unable to connect to Data Source using iodbctest, Lowden, James K, 09/22/2004
Archive powered by MHonArc 2.6.24.