Need help setting up MYSQL DB for phpbb3

Hi all.

I have setup phpbb3 successfully in the past with MYSQL. Fast and easy. But my friend has a server here, and I just discovered it only supports MSSQL. The phpbb3 setup programs states only that 'MSSQL Server 2000+ via ODBC is available.' I have been spoiled using all the tolls Godaddy has to offer with the MYSQL. I'm really lost with the MSSQL. I see things in the server's CP which I thought were obvious. Like the data source being the server address. Initial catalog perhaps being the database name, etc. I've setup a user name and pw, and plugged it all into the phpbb3 setup, but I am sure I am most certainly doing something wrong with the database as I keep getting the error:
Could not connect to the database, see error message below.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I would like to simply setup this one forum for my friend on his server, and in no way do I do this professionally. I just do these forums for fun.

If anyone can offer me a simple step by step on how to setup MYSQL 05 with this ODBC stuff, or links to a site showing how to, I'd greatly appreciate it. Thanks

 

There are a few people on DASP servers using the latest PHPBB with SQL Server...
Hopefully one of them will chime in to offer you some tips.
If you don't get any help with this in the next few days please bump this post.
Salute,
Mark

 

Do you mean MS SQL 2005? If so I can try a quick setup and see about the SQL connection parameters. I haven't done a phpBB setup on our servers specifically,and I don't really remember what their config file looks like,but it shouldn't take long to work it out.

 

Okay, I just set it up on my test account here. All the config info phpBB needs is in your Control Panel. But the terminology is a little different in a couple spots.

And of course, you'll have to have the MS SQL 2000 add-on for this to work, obviously. It won't work with MS SQL 2005, and we don't offer MySQL anymore. But it worked great on MS SQL 2000.

phpBB Database configuration

Database type: (choose MySQLMSSQL Server 2000+ via ODBC)
Database server hostname or DSN: (in Control Panel this is called: ODBC DSN)
Database server port: (leave this blank)
Database name: (in Control Panel this is called: Database Name)
Database username: (in Control Panel this is called: Database Login)
Database password: (your password - probably the same as the Control Panel password unless you changed it)
Prefix for tables in database: (this is up to you)

The rest I just did plain standard install.

 

Just a comment - phpBB has certainly changed a lot since I last installed it - maybe 5 years ago. Much better looking interface, seems to be more intuitive (well, as intuitive as forum management can be).

They are all still little brothers to vBulletin though.