Error while installing PHPBB, IIS, MySQL?

Question

Hi friends,
I downloaded phpBB 3.0.4 and I have IIS and MySQL 5.1 installed in my system. I started the installation of phpBB and in the Create Tables section, I get an error message:


A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1193 ]

SQL : BEGIN TRANSACTION

[MySQL][ODBC 5.1 Driver][mysqld-5.1.30-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRANSACTION' at line 1

What am I supposed to do?
Thanks.
Aishu.

Answer 1

You have selected MS SQL Server as the Database Connection through ODBC in IIS. Install MS SQL Server and create a database in the root. It must surely work. For getting Microsoft SQL Server 2008 Express: http://www.microsoft.com/express/download



Praveen

Answer 2

I would erase all of the tables and then try it all again, do you have mySQL installed.





Can you Creae tables or Inset using the login details you would have entered in a .php file.



These would be good steps to try then try again

Answer 3

Give phpBB full rights in MySQL.