[freetds] freetds, iodbc and odbctest on solaris not working..

Knight, Lloyd Lloyd.Knight at adc.com
Mon Aug 30 08:14:01 EDT 2004


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





More information about the FreeTDS mailing list