The auto-commit mode cannot be changed for th
Brought to you by:
canajun2eh,
yalnifj
Menu
▾
▴
When trying to install phpGedView 4.2.3 using MS SQL server as database I get the message:
Your current database configuration is bad. Please check your database connection parameters and configure again.
The auto-commit mode cannot be changed for this driver .
What´s causing this, and what to do?
Regards Stefan
Stefan
Although older help text with PGV may imply that MS-SQL is supported, it is doubtful to me that it is or, if at all possible, certainly not well-supported. PGV v4.2.3 uses PDO and configuration of those parameters is imperative and may not be possible. It is primarily designed to work with the free MySQL database.
-Stephen
Thanks for your answer, Stephen! Then I really don't understand why there is an option, when installing, to chose between MySql and MS SQL. Anyway, what does PDO stand for?
PHP Data Objects (PDO) interface enables access from PHP to MySQL 3.x, 4.x and 5.x databases
-Stephen
Stefan - The core of PVG was switched from generic drivers to PDO a couple of versions back. In theory PDO SHOULD be cross database, but in practice only MySQL and Postgres work with any degree of compatibility. So while older versions of PGV supported a number of databases, the PDO change was very much a backwards step. Certinly the MSSQL PDO driver is less than functional. I ported the code base to ADOdb so that I could continue to use Firebird, and that port may be OK on MSSQL since the ADOdb layer does properly support cross platform operation. However the installer is in such a state that I've not been able to make that work in my own port. I've built the database I need via an alternative route and have a blank for any other Firebird users to work with.
http://lsces.co.uk/wiki/index.php?page=Port+of+phpgedview+back+to+ADOdb&highlight=phpgedview
My own PGV site is running on this version, but it does need some further work to make it fully cross database.