freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] Unable to connect to Data Source using iodbctest
- From: "Lee, Gary" <GLee AT etrade.com>
- 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 11:42:26 -0400
Freddy, your response wasn't very useful.
- 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.
- "Why you need this?" So the drivers and iodbctest program can find the
files.
- "Read the manual" - Oh, gee, never thought of that. Maybe next time you
could point to a document or section that would be helpful.
Basically, your response was totally useless. Please don't post if you have
nothing to say.
Gary
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of ZIGLIO, Frediano,
VF-IT
Sent: Wednesday, September 22, 2004 12:52 AM
To: FreeTDS Development Group
Subject: RE: [freetds] Unable to connect to Data Source using iodbctest
> Problem in a nutshell: tslq works, iodbctest doesn't.
>
> I've configured FREETDS and iODBC on Solaris.
>
> The tsql program works, with this freetds.conf file:
>
> [Canada]
> host = 10.xx.xx.xxx (blocked out for privacy reasons)
> port = 1433
> tds version = 8
>
8 ??
> Environment variables ODBCINI and FREETDS are defined in my
environment, and point to the files in my
> home directory.
>
why you need this ?
> BUT:
>
> Running iodbctest, results in the following error from FreeTDS:
>
> ./iodbctest "DSN=Canada;UID=gary;PWD=lucky"
> iODBC Demonstration program
> This program shows an interactive SQL processor
> Driver Manager: 03.51.0002.0224
> 1: [FreeTDS][SQL Server]Unable to connect to data source (0),
SQLSTATE=08001
>
> Here's my odbc.ini file:
>
> ;
> ; odbc.ini
> ;
> [ODBC Data Sources]
> Canada = Foreign Symbol Database
>
> [Canada]
> Driver = /usr/local/freetds/lib/libtdsodbc.so
> Description = FREETDS / odbc test db
> Host = qa1
> Port = 1433
> ServerType = SQL Server 2000
> FetchBufferSize = 99
> UserName = gary
> Password = lucky
> Database = IMM2
> ServerOptions =
> ConnectOptions =
> Options =
> ReadOnly = no
>
???
please read the manual before posting...
> [Default]
> Driver = /usr/local/freetds/lib/libtdsodbc.so
>
freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-
[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.