Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connecting to an SQL 2005 server in a windows 2000 machine[Scanned]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Wolfgang Gruen <wgruen AT caci.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>, freetds-bounces AT lists.ibiblio.org
  • Subject: Re: [freetds] Connecting to an SQL 2005 server in a windows 2000 machine[Scanned]
  • Date: Mon, 30 Jan 2006 17:24:43 -0500

I am building the libraries on HP and tow libraries get added as static
libraries in the ODBC component. Does somebody know why this is happening?
I see it being added with the -l parameter in the Makefile and couldn't
figure out where we add the entire path.


1)The libraries are
-lodbcinst.sl
-libiconv.sl

2) The build log:
gcc -shared -fPIC -Wl,+h -Wl,libtdsodbc.sl.0 -Wl,+b
-Wl,/home/i3build/freetds/lib -o .libs/libtdsodbc.sl.0.0 .libs/odbc.o
.libs/connectparams XXXXX
-L/home/i3build/unixODBC/lib /home/i3build/unixODBC/lib/libodbcinst.sl
/usr/local/lib/libiconv.sl -lc -lc -Wl,-Bsymbolic

3) Makefile :
Makefile:ODBCINSTLIB = -lodbcinst

I would appreciate if somebody could let me know how to add theses dynamic
libaries without the static path.
Thanks
Wolfgang







"ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
Sent by: freetds-bounces AT lists.ibiblio.org
01/30/2006 10:36 AM
Please respond to
FreeTDS Development Group <freetds AT lists.ibiblio.org>


To
"FreeTDS Development Group" <freetds AT lists.ibiblio.org>
cc

Subject
Re: [freetds] Connecting to an SQL 2005 server in a windows 2000
machine[Scanned]







> Hi michael
>
> I check my SQL Server configuration and it listen on port 1433 and ip
> 172.25.X.X . I can connecto to SQL from my laptop with Toad
> and SQL 2005
> Manager.
> This is the output from tsql -C:
>
> tsql -C
> Compile-time settings (established with the "configure" script):
> Version: freetds v0.63
> MS db-lib source compatibility: no
> Sybase binary compatibility: unknown
> Thread safety: yes
> iconv library: yes
> TDS version: 8.0
> iODBC: yes
> unixodbc: no
>
> Regards

Usually we suggest following steps
- ping if hostname used. Does machine resolve ip from name?
- telnet to sql port. This avoid problems with firewall and similar
- tsql with -H -p -U -P to check lower FreeTDS layer (libTDS)
- tsql with -S -U -P to check for freetds.conf configuration
- try with same parameter on upper layer (PHP script and similar)

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page