FreeTDS Development Group

[Rebecca Witmer <rwitmer AT versay.com>]

Okay, here's the answer:

To get Sybase to install you have to read the suggestion here:

http://www.mail-archive.com/dbi-users AT perl.org/msg31071.html

Those symbols are missing from the FreeTDS include files.

Edit dbdimp.c, and somewhere near the top add:

#define BLK_VERSION_150 BLK_VERSION_100
#define BLK_VERSION_125 BLK_VERSION_100
#define BLK_VERSION_120 BLK_VERSION_100

Also, do not try testing using the scripts here:
http://www.freetds.org/userguide/perl.htm#DBD.SYBASE

Because there is no Sybase public server since about 10 years ago, 
apparently.  Definitely not now.

Rebecca


James K. Lowden wrote:
> Rebecca Witmer wrote:
> > QUESTION 1
> >
> > I am trying to install DBD::Sybase.  I got FreeTDS running and can do
> > queries with it from the command line, so I know that's working fine.
> > But now I want to do queries from Perl. So I am trying to install the
> > DBD::Sybase module.  perl Makefile.pl works fine, but running make
> > doesn't work.  I am running OSX and I am having basically the same
> > problem the guys are here:
> >
> > http://www.cpanforum.com/posts/9843
> > http://www.cpanforum.com/posts/9851
> ...
> > dbdimp.c:777: error: ‘BLK_VERSION_150’ undeclared (first use in this
> > function)
> > dbdimp.c:777: error: (Each undeclared identifier is reported only once
> > dbdimp.c:777: error: for each function it appears in.)
>
> http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/README
> http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/cspublic.BLK_VERSION_150.patch
>
>
> > Unable for connect to server [iODBC][Driver Manager]Data source name not
> > found and no default driver specified. Driver could not be loaded
> > (SQL-IM002) at testFreetds.pl line 20.
> >
> > What kind of driver is it looking for and where do I find it?
> >
> > The readme says to define these:
> >
> >      DBI_DSN   The dbi data source, e.g. 'dbi:ODBC:YOUR_DSN_HERE'
> >      DBI_USER  The username to use to connect to the database
> >      DBI_PASS  The username to use to connect to the database
> >      ODBCHOME  (Unix only) The dir your driver manager is installed in
> >                or specify this via -o argument to Makefile.PL
> >
> > I don't have ODBCHOME defined because I have no idea what a driver
> > manager is, or whether I have it.
>
> I don't have all this cooking on my Mac, which I use mostly for answering
> the mail, but /Library/ODBC seems like it would would be a good guess. 
> cf. iodbc-config(1).  
>
> HTH.  
>
> --jkl
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds