Adding Forums - phpBB

I would like to an a forum to my website and see that it was posted that it's possible to add phpbb, so I have been trying to do so. I'm running SQL Server and have been accessing the database directly and running ASP scripts only, so I tried using that info to set up the forum, but am struggling:
Database Type: chose MS SQL 7/ 2000?
Also tried "MS SQL Server ODBC"
DSN: mssql05.discountasp.net
username:
password:
database name: DB_65955

what am i missing or doing wrong here:

 

I honestly have no clue about phpbb, I was just going by the recommendation in here to use this....
http://forum.discountasp.net/topic.asp?TOPIC_ID=1396

Your post says that it has been tested here, and I just uploaded it as it was. I was unable to chmod the config file as per the instructions however

Not sure if it helps, but this is the link to the config file:
http://loansifter.com/phpBB2/config.php

 

quote:Originally posted by bruce

Can you post the configuration file for your phpBB?

Does PHPBB support OleDB?


quote:Originally posted by cragi

I would like to an a forum to my website and see that it was posted that it's possible to add phpbb, so I have been trying to do so. I'm running SQL Server and have been accessing the database directly and running ASP scripts only, so I tried using that info to set up the forum, but am struggling:
Database Type: chose MS SQL 7/ 2000?
Also tried "MS SQL Server ODBC"
DSN: mssql05.discountasp.net
username:
password:
database name: DB_65955

what am i missing or doing wrong here:
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET

</blockquote id="quote"></font id="quote">

I opened up the config file in a php editor and it shows as blank

 

can someone help? bruce?

I tried it with MS SQL 7 / 2000 chosen:
Database Server Hostname / DSN: loansifterc_sqlConn
Your Database Name: DB_65955
Database Username: loansifterc
Database Password: xxxxxxxxx
Domain Name: loansifter.com
Server Port: 80
Script path: /phpbb/

Error message:
The PHP configuration on your server doesn't support the database type that you chose


same thing as above with database switched to MS SQL (ODBC):
Error Message:
phpBB : Critical Error

Could not connect to the database PHP Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed, SQL state IM004 in SQLConnect in E:\web\loansifterc\htdocs\phpBB2\db\mssql-odbc.php on line 54 PHP Warning: odbc_error(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\phpBB2\db\mssql-odbc.php on line 377 PHP Warning: odbc_errormsg(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\phpBB2\db\mssql-odbc.php on line 378

 

I re-read the installation notes and one thing it asks you to do is to temporarily change the permissions of one of the files to global read-write, something I was unable to do in the control panel.... is this the cause and how would I do that?

 

I would rather have this forum based on functionality if possible. Is there something wrong with what I've entered in the form that you can see offhand? Am I supposed to supply a different pathname? Is my entry for the DSN correct?

 

Would I need a different DSN than the one I use in the ASP scripts? This is php-based... The port default was '80' for the script..is this correct for the SQL Server databases?

 

the 'config' file is just a blank file they have set aside to access the database with. The result of the installation is this file gets written to..

 

I downloaded the recent version...2.0.10
The config file is formed when you fill out the "install" page as I described above.... to do that it needs to connect to the database, which doesn't seem to be happening.. it doesn't support OLEDB.. need to connect via DSN / ODBC

I posted the same problem to the phpbb support forum and they said the problem was definitely on the host side. Do I have a DSN that php can access MS SQL with?

 

The MSSQL DSN should already be created. You can find it in the MSSQL 2000 section of the control panel.

 

quote:Originally posted by Lukas

The MSSQL DSN should already be created. You can find it in the MSSQL 2000 section of the control panel.
</blockquote id="quote"></font id="quote">

That's what I thought. But it doesn't work.

 

I tried installing phpBB2 on my site and was successfull.

The database type should be MS SQL Server [ODBC] if you are using a DSN.

Are you sure you're using the right username and password?

 

this is driving me nuts. I'm using the same database user name and password that I use to log into the database with OLEDB. Could you possible provide a screenshot of the input you entered? It seems like I've attempted every combination.

I downloaded phpbb 2. I was told I didn't need to change the permissions so I just ftp'd the files through the browser. I cut & pasted most of the input from the control panel of discountasp.

This is my screenshot of my discountasp control panel, corresponding input, and error msg
http://www.loansifter.com/phpbb/test.jpg

If I have the DSN, there is no need to enter the server info, correct?

 

ARGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGH!!!!!!!!!!!!!

Okay, now I see what happened. My entire site is password protected for now and that messed up installation. GRRRRRRRRRRRRRRRRRRR!

Thanks for all the help guys