Skip to Content.
Sympa Menu

freetds - Re: [freetds] Two Qs, one on Sybase, one on ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rebecca Witmer <rwitmer AT versay.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Two Qs, one on Sybase, one on ODBC
  • Date: Fri, 29 May 2009 12:02:11 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page