| Author |
 Topic  |
|
djblingbling1
Starting Member
17 Posts |
 Posted - 19 March 2005 : 01:40:56
|
| Its somthing about the data base. Im pretty sure I did all the steps correctly form the guide, and I played around with it too and it still dosnt work. |
 |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 19 March 2005 : 02:09:08
|
| "Something" is not clear enough - Whenever you have an error you should copy and paste the exact error message so we can help you faster. |
eXtremeGossip  |
|
|
|
djblingbling1
Starting Member
17 Posts |
Posted - 19 March 2005 : 10:26:19
|
Heres what it says:
Database Setup....
Your strDBType is not set, please edit your config.asp
to reflect your database type.
Im almost positive I did that part correctly though. |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 19 March 2005 : 13:47:17
|
| Did you set both the Database Type and the Connection String? From what you posted it seems you forgot to do the first part. |
eXtremeGossip |
|
|
|
djblingbling1
Starting Member
17 Posts |
Posted - 19 March 2005 : 14:29:34
|
Ok so is this the part you are talking about? IF it is how do I fond out were my data base is?
'#################################################################################
'## 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 and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables |
Edited by - djblingbling1 on 19 March 2005 14:35:18 |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 19 March 2005 : 14:53:14
|
quote:
Originally posted by djblingbling1
Ok so is this the part you are talking about? IF it is how do I fond out were my data base is?
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
Here you need to uncomment the type of database you will be using.
quote:
## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
Here you need to uncomment the connection string that is appropriate to the type of database you are using, and fill in the database path. You can check the database path by placing the whereami.asp file in your database folder and opening it (i.e. www.myforum.com/db/whereami.asp)
quote:
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables
Leave these like they are. |
eXtremeGossip |
|
|
|
djblingbling1
Starting Member
17 Posts |
Posted - 19 March 2005 : 16:16:49
|
| Ok thanx, how do I know whta kind of dtabase I am using? |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 19 March 2005 : 18:23:28
|
Excuse me, but how am I supposed to know what database you are using?  You will have to make that decision yourself. If you have MySQL available then use it, otherwise use an Access db. |
eXtremeGossip |
|
|
|
djblingbling1
Starting Member
17 Posts |
Posted - 19 March 2005 : 22:52:25
|
| Ok I downloaded MySQL, so now all i do is put the location into one of the lines on the section of config that I have posted above? |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 19 March 2005 : 23:21:30
|
Your host has to support MySQL, it doesn't matter whether you have it on your computer or not.
The instructions in the readme file are very clear, just follow them and you shouldn't have a problem setting up. |
eXtremeGossip |
|
|
|
djblingbling1
Starting Member
17 Posts |
Posted - 20 March 2005 : 01:06:38
|
| Ok whatever, I still cant get it to work. Il just stick with my proboards forum. |
|
|
|
anekretia
Starting Member
4 Posts |
Posted - 20 March 2005 : 02:51:19
|
wow that wasnt very helpful, at any rate, I got it all on server i believe, and when i open the browser, I get what looks like a good sign,
something like this?
<%
'#################################################################################
'## Snitz Forums 2000 v3.4.05
'#################################################################################
'## Copyright (C) 2000-05 Michael Anderson, Pierre Gorissen,
'## Huw Reddick and Richard Kinser
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or (at your option) any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
now in the instructions that i think ive been carefully reading, it says i am to answer questions that will help me set up my forum . . . . .
where are these questions? |
|
|
|
anekretia
Starting Member
4 Posts |
Posted - 20 March 2005 : 02:57:42
|
i came to this place because I believe Snitz is the best, this was based on a clan i was in for medal of honor that used it for years, www.kaos.rocks.it so if i could get a hand here id appreciate it, I dun wanna be like that other guy, though ill be the first to tell you this stuff is all greek to me i dun know nuttin about it
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 20 March 2005 : 03:53:41
|
OK, Anekretia, the reason that you are getting the ASP code to display like that, is because you are on a FreeBSD server that doesn't support ASP. Snitz will not run for you no matter what you try unless your hosting company puts you on a Windows server or installs a product like SunOne which may be as expensive as running a Windows server.
It is the first thing you need to check, and that is, is my host able to run an ASP forum before trying to install Snitz to save you some time and heart ache.
|
Cheers,
David Greening |
|
|
|
anekretia
Starting Member
4 Posts |
Posted - 20 March 2005 : 04:23:05
|
| im on a free server? at www.guitar-dominion.com ? my friend pays out the rear for it, so i dont understand what you mean . . .should i just use a different one then? |
|
|
|
Topic |
|
Topic Locked
