Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetdsODBC odbc.ini

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "cal kaiwen" <cal_kaiwen AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] freetdsODBC odbc.ini
  • Date: Thu, 06 Mar 2003 07:26:57 +0000

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




Archive powered by MHonArc 2.6.24.

Top of Page