freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] freetds, iodbc and odbctest on solaris not working..
- From: "Knight, Lloyd" <Lloyd.Knight AT adc.com>
- To: <freetds AT lists.ibiblio.org>
- Subject: [freetds] freetds, iodbc and odbctest on solaris not working..
- Date: Mon, 30 Aug 2004 07:14:01 -0500
i have configured, compiled and installed freetds and iodbc on solaris 8.
i used the --with-iodbc param to configure.
tsql -H host -p port -U user -P pwd works just fine.
when i try to run odbctest "DSN=dsn;HOST=host;PORT=port;UID=user;PWD=pwd"
i get the error:
./odbctest.orig
"DSN=ljkfree;HOST=host;PORT=2433;UID=user;PWD=pwd;DATABASE=portals"
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
SQLDriverConnect = [iODBC][Driver Manager]Driver's SQLSetConnectOption
failed, SQLSTATE=IM006
SQLDriverConnect = [FreeTDS][SQL Server]Read from SQL server failed.,
SQLSTATE=08S01
SQLDriverConnect = [FreeTDS][SQL Server]Login incorrect., SQLSTATE=28000
SQLDriverConnect = [FreeTDS][SQL Server]Unable to connect to data source,
SQLSTATE=08001
i have ODBCINI FREETDS and ODBCINSTINI set in my environment.
freetds.conf
[ljkfree]
host = MN01DBPROD6.adc.com
port = 2433
tds version = 4.2
[free1]
host = MN01DBPROD6
port = 2433
tds version = 4.2
odbcinst.ini
[ODBC Drivers]
freetds = installed
[freetds]
Description = freefree
Driver = /usr/local/freetds/lib/libtdsodbc.so
Setup = /usr/local/freetds/lib/libtdsodbc.so
[ODBC]
trace = 0
Debug = 0
Polling = no
odbc.ini
;
; $Id: odbc.ini,v 1.8 2002/03/25 09:11:44 source Exp $
;
; Systemwide ODBC parameters
;
[ODBC Data Sources]
ljkfree = OpenLink Generic ODBC Driver
free1 = freetds
[ljkfree]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = Sample OpenLink MT DSN
Host = MN01DBPROD6.adc.com
Server = MN01DBPROD6.adc.com
Port = 2433
ServerType = SQL Server
FetchBufferSize = 99
UserName = krone_parts
Password = engineering
Database = krone
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no
[free1]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = Sample OpenLink MT DSN
Host = MN01DBPROD6
Server = MN01DBPROD6
Port = 2433
ServerType = SQL Server 2000
FetchBufferSize = 99
UserName = krone_parts
Password = engineering
DataBase = krone
ServerOptions =
ConnectOptions =
Options =
ReadOnly = yes
[Default]
Driver = /usr/local/freetds/lib/libtdsodbc.so
i have tried so many different things, i do not know which way is up.
i have seen many examples in the freetds group, but none seem to help.
i have also seen postings suggesting freetds/iodbc doesn't work on solaris.
can i do this?
if so, what am i doing wrong?
HELP????
thanks
ljk
-
[freetds] freetds, iodbc and odbctest on solaris not working..,
Knight, Lloyd, 08/30/2004
- Re: [freetds] freetds, iodbc and odbctest on solaris not working.., Frediano Ziglio, 08/30/2004
- <Possible follow-up(s)>
-
RE: [freetds] freetds, iodbc and odbctest on solaris not working..,
Knight, Lloyd, 08/30/2004
- Re: [freetds] freetds, iodbc and odbctest on solaris not working.., Daniel Fazekas, 08/30/2004
- RE: [freetds] freetds, iodbc and odbctest on solaris not working.., Knight, Lloyd, 08/30/2004
Archive powered by MHonArc 2.6.24.