By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,278 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,278 IT Pros & Developers. It's quick & easy.

PEAR MDB2 works with MySQL, not with MSSQL

P: n/a
Apologies if this is not the right forum.

I have an application written originally to work with MySQL which now
has to be extended to work with MSSQL also. I have modified all my
database calls to use the PEAR MDB2 methods rather than mysqli.
Everything still works fine with MySQL, but I have an odd problem when I
test against MSSQL.

Any database query which does not return a resultset is OK e.g. an
update works fine. If I execute a query returning a resultset it always
comes back empty. var_dump shows that the returned object is of the
right type for the db driver being used, but the result sub-object at
the end is very different; for mssql it shows as a mysqli_result object,
but for mssql shows as a "resource(11) of type (Unknown)".

Any hints and tips gratefully accepted.

PHP 5.1.6, MDB2 2.3.0, MDB2 driver 1.1.2, MySQL 5.0.27
MS SQL Server 2000 installed with client tools on PHP machine

Regards

-- Jim.
Feb 21 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.