FreeTDS Development Group

["Frank M. Kromann" <frank AT kromann.info>]

Perhaps a late answer ?

PHP has support for two extensions (MSSQL and Sybase) both extensions can
be compiled against FreeTDS, mand both extensions exposes mssql_* function
names.

In the case of the Sybase extension these names are generated as aliases
for the sybase_* functions. The "native" MSSQL extension includes
additional functions (batch selects and stored procedures). These php
documentation pages lists the differences.

http://www.php.net/manual/en/ref.mssql.php
http://www.php.net/manual/en/ref.sybase.php

Depending on how you compile php it will require a mssql.so fil to use the
mssql_* functions. This file should be copied to the correct extensions
folder (during the make install process or manually).

- Frank
> 
> Well, after further investigation, it at this point, doesn't seem to be
> FreeTDS.
> The problem lies in a library file, in which it is making a dl() method
call
> and it is for some reason escalating a simple warning to a fatal error
(the
> following):
> 
> Unable to load dynamic library './mssql.so' - Cannot open "./mssql.so"
in
> DB.php on line 564
> 
> now, if anyone has expertise on escalation of warnings to errors in php,
I
> could use the help, otherwise I'll leave the list alone, with my
insanity :)
> 
> Cheers,
> 
> Shawn Greene
> 
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of Lowden, James K
> Sent: Wednesday, April 09, 2003 11:51 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] FreeTDS & PEAR's db.php library
> 
> 
> > From: Shawn Greene [mailto:sgreene AT azorus.com]
> > Sent: April 9, 2003 10:22 AM
> >
> > I have been using FreeTDS 0.60 to connect to the MSSQL
> > database here for a
> > long time, and it works great.  I have mod_php4 (v 4.3.2)
> > installed with
> > SybaseDB support and this setup works great when using the
> > mssql_* commands to access the database.
> ...
> > #2 how does FreeTDS allow php to use the mssql commands when
> > /usr/local/lib/php/mssql.so is not there for it to utilize?
> 
> I don't understand what you mean by "mssql commands", Shawn, or, if I
do,
> then FreeTDS isn't "allowing" anything, really. It's up to the runtime
> linker to find the appropriate library and resolve the call.
> 
> > #3 (part of #2) is it using sybase?
> 
> More nouns, please.
> 
> I'm not familiar with PEAR, but if it relies on DBD::Sybase then I don't
see
> why it can't be made to work.  There are some things DBD::Sybase
supports
> that FreeTDS hasn't implemented (yet), but that doesn't sound like what
> you've bumped into.
> 
> --jkl
> 
> 
> 
> The information contained in this transmission may contain privileged
and
> confidential information and is intended only for the use of the
person(s)
> named above.  If you are not the intended recipient, or an employee or
agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
is
> strictly prohibited. If you are not the intended recipient, please
contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders
and/or
> instructions by e-mail, and therefore will not be responsible for
carrying
> out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>