Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC-only connection to SQL Server from FreeBSD

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC-only connection to SQL Server from FreeBSD
  • Date: Thu, 4 Aug 2005 15:14:30 +0200

>
> Hello,
> I don't have root access to my server, so I installed
> FreeTDS in my home directory. I tried it several times,
> because I didn't manage to install libtdsodbc.so. Finally I
> managed to do it, putting --with-iodbc=/usr/local/ .
> Now tsql connects fine:
>
> carlo@qs41% ./tsql -H ip.ip.ip.ip -p 1433 -U user -P psw
> locale is "C"
> locale charset is "US-ASCII"
> 1>quit
> carlo@qs41%
>
>
> However, sometimes the connection is refused.
>
> Anyway, the point is that iodbc does not connect:
>
> carlo@qs41% /usr/local/bin/iodbc-odbctest "DSN= SCAM;
> UID=user; P= psw"

Try to remove spaces.

> iODBC Demonstration program
> This program shows an interactive SQL processor
> [FreeTDS][SQL Server]Unable to connect to data source, SQLSTATE=08001
>
> Have a nice day.carlo@qs414%
>
> So, it looks like the problem was in the .odbc.ini. Here it is:
>
> [ODBC Data Sources]
> SCAM= SQL Server 2000
>
>
> [SCAM]
> Driver = /usr/home/carlo/freetds/lib/libtdsodbc.so
> Description = SQL SERVER
> Server = ip.ip.ip.ip
> Address = ip.ip.ip.ip
> Host = ip.ip.ip.ip

Server is sufficient

> Port = 1433

> ServerType = SQL Server 2000
> Trace = yes

??? iODBC setting ??

> TDS_Version = 8.0

ok

> UID = user
> PWD = psw

RTFM

> Database = SYSMA4

> ReadOnly = no

??? iODBC ???

>
> [Default]
>
> Driver = /usr/home/carlo/freetds/lib/libtdsodbc.so
>
> Could anybody point me to my error? Thank you in advance for
> any help. Regards;
>
>
> Carlo.
>

Try removing additional settings and enabling FreeTDS logging (see
manual at http://www.freetds.org/userguide/logging.htm)

ciao
freddy




Archive powered by MHonArc 2.6.24.

Top of Page