Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freetds, iodbc and odbctest on solaris not working..
  • Date: Mon, 30 Aug 2004 16:50:03 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page