ODBC on MS SQL and MySQL both come back with that annoying PConnect option which I wasn't willing to spend the time on investigating as the MySQL worked.

I successfully installed, but now I'm having a problem accessing the site as it keeps sending all the pages to the root of the web directory instead of the subdir I am using.

I hope the information provided helps others.

During MS SQL Server 7.0 installation:
Installation returns blank page after Step 5 (which is attempting to create tables in database).

I'm on Windows 2000 with IIS 5.0

Okay, here's what I've done so far.

My PHP_MSSQL.DLL extension wasn't found. So I had to revert to PHP 4.0.x.x to get the extension to work correctly. I was experiencing the same problem with the PHP_MYSQL.DLL. Both are working correctly now.

My ODBC version wouldn't connect to the MYSQL so I've had to go up a version.

Status as of Now:

Getting ready to test OPN2 with MS SQL 7.0
Then ODBC to MS SQL 7.0
Then MySQL
Then ODBC to MySQL

I'll post back when I'm finished.

Never tried to use ODBC via PHP. So, I beg your pardon that I can't offer you any support for that.

OPN is tested and verified with: mySQL, Postgress, Firebird and SQLite as DB Backend. What about using one of these?

What system is your Webserver on? Win or Linux? Apache? PHP version?

Alex

Okay. I can't get the php.ini to see the mssql php extension. It says it can't find the library.

so I went to the ODBC instead. Now I'm getting this error "odbc - not tuned for specific databases. To connect, use PConnect('DSN','user','pwd')."

Am I suppose to use the persistent connection in the connection string?

No, it isnt. You have to "activate" the mssql extension in your php.ini File.

BTW: opn with Mssql as backend is untested and that means that it will not work (i think)

Alex

Trying to install OPN on a MS SQL Server 7.0 from the full.zip file.

Receiving following error "Fatal error: Call to undefined function mssql_get_last_message() in ..classsqladodbdriversadodb-mssql.inc.php on line 429"

I did a search through the site and found no function mssql_get_last_message. Am I missing a file? I am running PHP4. Isn't this function suppose to be part of PHP4?

[ This message was edited by: cybersensei on 2004-10-27 17:35 (Original date 2004-10-27 17:31) ]