mssql 2000

[Anon]

Can anyone tell me if php4 can talk to mssql 2000? Or maybe you have found a workaround....

I'm currently connection via the odbc functions. Works okay but I'd prefer native really.

Thanks

Chris

[partner2partner]

It appears to work fine. We loaded it on a server today and will have better experience in a few days. We are using the ADODB library to access it natively on Windows 2000 Server from PHP 4.0.4pl1.

Michael J. Upchurch

[Anon]

Thanks Michael,

Can you, by any chance, direct me to some installation instructions? I'm using Apache/php4 on NT4.

If it might work for us I'd be very interested to try.

Thanks

Chris

[partner2partner]

We're using Windows 2000, IIS5 and PHP4.0.4pl1. I'm sure it works the same under NT4, but not so sure from Apache. My guess is that it would because a lot of people are running Apache instead of IIS5.

All we did to get SQL Server 7 and SQL Server 2000 to work was turn on the module in the PHP.INI file. The line should read:

extension=php_mssql70.dll

We are really pleased with the ADODB library. It's available at http://php.weblogs.com/ADODB. You can access multiple databases by just changing a setting in your code. I highly recommend it. There are several modes for accessing SQL Server databases. We're using the setting for 'mssql'.

Mike

[Anon]

Thank you very much Mike. Please feel free to e-mail me at work [e-mail] if you ever want to run anything by us. I'm about to use our set-up in an e-business context.

regards

Chris