FreeTDS Development Group

["cal kaiwen" <cal_kaiwen AT hotmail.com>]

Hi,

I manage to progress until here:-

(1) freetds
./configure --prefix=/usr/local/freetds
make
make install


(2) DBD::Sybase
export SYBASE=/usr/local/freetds
perl Makefile.PL
make
make install


(3) DBD::ODBC
cd DBD-ODBC-0.28
$ export SYBASE=/usr/local/freetds
// I can understand that /usr/local/freetds contains sybase libraries files, 
BUT, what is ODBCHOME for?

$ export ODBCHOME=/usr/local

$ export DBI_DSN=dbi:ODBC:LBX
$ export DBI_USER=lbs
$ export DBI_PASS=lbs
$ perl Makefile.PL
$ make //ERROR, do not proceed with test script


[root@localhost DBD-ODBC-1.04]# make
gcc -c  -I. -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI 
-I/usr/local/include -fno-strict-aliasing -I/usr/local/include -O2 
-march=i386 -mcpu=i686   -DVERSION=\"1.04\" -DXS_VERSION=\"1.04\" -fPIC 
-I/usr/lib/perl5/5.6.1/i386-linux/CORE  ODBC.c
In file included from ODBC.h:9,
                from ODBC.xs:1:
dbdodbc.h:6:21: libudbc.h: No such file or directory
make: *** [ODBC.o] Error 1



(4) parts of test scripts
use DBI;

my $dbh = DBI->connect("dbi:ODBC:192.168.250.71", 'lbs', 'lbs', {PrintError 
=> 0});
die "Unable for connect to server $DBI::errstr"
   unless $dbh;

Please advice. :)

Thank you,
Calvin





> From: Frediano Ziglio <freddyz77 AT tin.it>
> Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> Subject: Re: [freetds] freetdsODBC odbc.ini
> Date: 06 Mar 2003 07:31:42 +0100
>
>
> > Yes, when you install
> > http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-0.61.tgz,
> > following the instructions in the User Guide for building with iODBC or
> > unixODBC, you'll have the FreeTDS ODBC driver.
> >
> > It's been agreed that the ODBC section of the UG needs to be 
> reorganized.
> >
>
> Agree
>
> >
> > > "A third option is to use DBD::ODBC with the FreeTDS ODBC driver. 
> Brian
> > > has gotten this to work fairly well but it is still new, so YMMV. "
> >
> > That advice still holds; I think even Frediano would agree that the 
> db-lib
> > and ct-lib APIs remain more complete than ODBC.  However, great strides
> > have been made, and ODBC shouldn't be considered "experimental" anymore
> > (no more so than the rest of FreeTDS, that is).
> >
>
> Agree. ODBC design require much more implementation than other library.
> If program do not require too much it work good. Star Office, for
> instance, do not work.
>
> Coming back to real problem... odbc.ini configuration. Can you post your
> odbc.ini dsn section?
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail