Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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






Archive powered by MHonArc 2.6.24.

Top of Page