I would suggest you create a folder named database and move the snitz database folder out of tools to that folder and make sure the folder is read/write enaabled and secuere. Your host may have to set this up for you.
Then edit two places in your config.asp file. First, remove the ' statement in front of the access 97 database type. Second, find the driver string that is an access 2000 driver and edit that string (also removing the ' remark statement with the path to your database folder and database on your server. Something like this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=THE LOCATION ON YOUR HOST/YOUR FORUM/database/snitz_forums_2000.mdb;" '## MS Access 2000
From your forum directory in your go window, run setup.asp to set up the forum and database then run default.asp to view and setup your forum. That's it.
ok here is how i have it now but it still wont accsess the db. '################################################################################# '## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql) '################################################################################# 'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:/atlantastarz\forum\Snitz_Forum_2000_V3_1_SR4\tools\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath\db\snitz_forums_2000.mdb" '## MS Access 2000 using virtual path strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\www22.brinkster.com\atlantastarz\db\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=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
Topic Locked
Posted - 21 June 2001 : 11:26:05
