SQL error... Access DB cant find tables...

[JSThePatriot]

Okay I finally got phpbb to connect to my access database, do I need to create the proper tables because I get an error when I try to install the forum... below are the errors recieved.

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 159

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 159

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_users'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_users'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176

And the following a bit further down on the page...

An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1098117430) :: 871 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 878 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'patriot@the-patriot.net' WHERE config_name = 'board_email' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/fca/forum/' WHERE config_name = 'script_path' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'www.the-patriot.net' WHERE config_name = 'server_name' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'JSThePatriot', user_password='2ec418f96a6e922dfb5a4c12ce75721c', user_lang = 'english', user_email='patriot@the-patriot.net' WHERE username = 'Admin' :: 906 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1098117430 :: 913 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Also as a side note it took over a week for me to recieve the email for confirmation. I know that you guys are busy and everything I just wanted to alert you to that No biggie though.

Thanks for your help in advance. I am sure it is something I am doing.

JS

[pentapenguin]

Hi!
Are you sure you're using the correct DSN name?
You need to ask your host to be sure.
Tip: Access can't handle more than 2 or 3 users at once, so you might want to upgrade to a more robust database server like MSSQL or MySQL.

[JSThePatriot]

Hi!
Are you sure you're using the correct DSN name?
You need to ask your host to be sure.
Tip: Access can't handle more than 2 or 3 users at once, so you might want to upgrade to a more robust database server like MSSQL or MySQL.

Yea I am just testing it out on this server. We are fixing to be hosting our own server. We I am sure will use MySQL or atleast I am going to push for it as it is free and robust.

I know my problem doesnt have anything to do with my DSN as I know what it is first off, and secondly it allows me to connect (get past the first page). I know that because I accidently miss spelled it once.

If you have any other ideas/solutions please let me know. Thank you very much for looking at my problem.

JS

[JSThePatriot]

Can no one help me here? I am having errors in the PHP. I dont know why it isnt working. The documentation says nothing of this! I understand there are hundreds of posts... sorry if mine is trivial.

JS

[JSThePatriot]

Bump

JS