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

Wolfgang Gruen wgruen at caci.com
Mon Jan 30 17:24:43 EST 2006


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




More information about the FreeTDS mailing list