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

Frediano Ziglio freddyz77 at tin.it
Mon Aug 30 10:50:03 EDT 2004


Il lun, 2004-08-30 alle 14:14, Knight, Lloyd ha scritto:
> 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"

HOST= ?? Please read userguide, also DSN and "HOST" can't work together
...

> 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
> 

4.2 ?? mssql 6.5 ?? Sybase < 10 ??

> 
> 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
> 

bye
  freddy77





More information about the FreeTDS mailing list