|
3dcandy
Starting Member
39 Posts |
 Posted - 28 May 2001 : 19:45:16
|
Hi,
I've spent ALL day trying to get this working, and I've totally hit a dead end.
I've got a MySQL server, and when I try and set up the forum's using setup.asp it says
"The database you are using needs to be updated"
" Code : 0"
I click to upgrade the database and get another error message
ADODB.Recordset.1 error '80004005'
Table 'threeDcandydb.FORUM_MEMBERS' doesn't exist
/3dcandy/forum/setup_login.asp, line 74
What's going on? I'm totally stuck! Help please.....
here's the config.asp that I'm using
'strDBType = "sqlserver"
'strDBType = "access"
strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/home/candy/cgi-bin/snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/home/candy/cgi-bin/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
strConnString = "driver=MySQL;server=webpanacea.co.uk;uid=threeDcandy;pwd=******;database=threeDcandydb" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Any ideas!?!?!?
|
|
Topic Locked
