Re: [VuFind-Tech] Horizon driver and Sybase

[Tod O. <to...@uc...>]

Okay, that makes sense. The history there being that MSSQL is actually a fork from Sybase[1], and so they both use the same on-the-wire protocol, TDS. That protocol does not seem to have diverged, at least not much. And FreeTDS works with both MSSQL and Sybase, and that's what the mssql and sybase packages are based on.

So why it didn't work the first time, when I was just trying the mssql package, is an open question. If I investigate further, I'll report the findings.

-Tod

[1] Editorial commentary on the advisability of Sybase entering that particular partnership with MicroSoft omitted.

On Nov 30, 2011, at 10:55 AM, Demian Katz wrote:

> I've been led to believe that the mssql package should also be able to talk to Sybase... for example, see this thread:
> 
> http://sourceforge.net/mailarchive/message.php?msg_id=27405033
> 
> If this is not really the case, we should make the driver configurable to use either library, but I really thought it was previously determined that this was not necessary.  Could anyone more familiar with the Horizon driver confirm or deny this?
> 
> thanks,
> Demian
> ________________________________________
> From: Tod Olson [to...@uc...]
> Sent: Tuesday, November 29, 2011 3:59 PM
> To: vuf...@li...
> Subject: [VuFind-Tech] Horizon driver and Sybase
> 
> VuFind Tech,
> 
> I'm trying to configure VuFind (running on Ubuntu 10.4) to use the Horizon adaptor to talk to our Horizon Sybase database.  But it seems like the Horizon driver is hardcoded to talk to MSSQL, like in this connection statement:
> 
>        // Connect to database
>        $this->_db = mssql_pconnect(
>                // [snip]
>        );
> 
> Now I'm not really a PHP hacker, and I certainly do not know the database abstraction layer. Based on the VuFind doc, the PHP Sybase documentation and the Horizon.php source code, I tried the following:
> 
> 1.      sudo apt-get install php5-sybase, and
> 2.      replace all mssql_* calls with sybase_* calls in , but that just leads to the following error:
> 
> But that just leads to the following error:
> 
>        PHP Fatal error:  Call to undefined function sybase_pconnect() in /usr/local/vufind/web/Drivers/Horizon.php on line 66
> 
> Looks like sybase_pconnect() should be defined, based on the documentation and the fact that the php5-sybase package is installed.
> 
> apt-get installed the freetds-common, libsybdb5, and php5-sybase packages.
> 
> At this point I'm looking for advice on how to proceed. Some specific questions would be:
> 
> 1. Were the above steps sensible and necessary, or should I undo them?
> 2. How can I confirm than the PHP Sybase support was correctly installed?
> 3. Is there a better way to proceed on talking to the Sybase Horizon database?
> 
> Any advice would be welcome.
> 
> -Tod
> 
> Tod Olson <to...@uc...>
> Systems Librarian
> University of Chicago Library
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Vufind-tech mailing list
> Vuf...@li...
> https://lists.sourceforge.net/lists/listinfo/vufind-tech