MS SQL via ODBC

[Anon]

Again...

I tried to access a MS SQL database via ODBC, which should be possible but sadly didn't work. I'm really starting to give up on Windows....

But: has anyone ever succesfully connected to a MS SQL database on IIS using ODBC instead of the "normal" MS SQL dll ? If so, PLEASE let me know because I can't figure out how to get in....

thanks,
Michiel.

[Anon]

Just got done doing a pretty large website using MSSQL on WINNT 4.0 with IIS. Unfortunately I couldn't get the MSSQL drivers to connect so I had to use ODBC. It connected great.

First you have to setup the ODBC data source on the system you are running IIS. Make sure you test the connection.

Also make sure your PHP.ini file has ODBC support enabled. This is where my problems were at first.