[freetds] Two Qs, one on Sybase, one on ODBC

Rebecca Witmer rwitmer at versay.com
Fri May 29 13:02:11 EDT 2009

Okay, here's the answer:

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


Those symbols are missing from the FreeTDS include files.

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


Also, do not try testing using the scripts here:

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


James K. Lowden wrote:
> Rebecca Witmer wrote:
>> 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

More information about the FreeTDS mailing list