Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Tearing my hair out.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Datahead
Starting Member

USA
14 Posts

Posted - 17 October 2007 :  19:09:25  Show Profile  Visit Datahead's Homepage  Send Datahead an AOL message
After creating not only a SQL database, and a Access Database, I have come to the conclusion that I don't know dink about coding and Web site development. I can not get this application to work. I'm sure it is a simple thing I am overlooking, but I cannot find the information I need to resolve it. I have installed SQL Server and Access on the server, but to no avail. Please if there is an installation manual or someone who can get me going in the right direction I would really appreciate it. I keep getting a error 500 when I try to access the Forum.

As I really want to use this product on my server, any help would be appreciated. It has to be something I'm overlooking. I am very new to web development and coding, but I also have allot of tenacity.

Regards:
Ron

Need help with you Media room? The MCE HTPC Support Group

gary b
Junior Member

USA
267 Posts

Posted - 17 October 2007 :  20:33:11  Show Profile  Visit gary b's Homepage
Ron...

Let me see if these pointers help.

1. Place your Access database in a folder on the web server. This folder MUST be accessible by an Internet user. Check with host if you are not sure.

2. Look at these lines from config.asp

You stipulate what type of database you have by UNcommenting (removing lead apostrophe) for the appropriate line. (I'm using Access.)

'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

3. [Watch out for line wraps!] The next section stipulates where the database is located. In my case, my database is located in a folder called dbases. This folder allows web visitor access. Notice that all other lines in this section is 'commented out'. Edit the line that applies to your scenario and comment out the others.

'## 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("../dbases/forum.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

Setting up the forum is really that easy. However, if you have other issues -- perhaps about the web server --, other actions may be required. Try the above and see if this works. If you are still unsuccessful, post back and someone will try to help!

gary b

BTW... I believe there is a README file included in the Snitz Zip file. Make sure you read that. Directions are included in that file.

Edited by - gary b on 17 October 2007 20:35:29
Go to Top of Page

Datahead
Starting Member

USA
14 Posts

Posted - 17 October 2007 :  21:09:33  Show Profile  Visit Datahead's Homepage  Send Datahead an AOL message
Making progress:
Found the installation file,

got the application to come up but with errors. When I go to run the setup.asp file it trys to create the DB but I am getting this as an error when I try to load the admin name and password.

Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147467259 Operation must use an updateable query

BTW: this occurs 13 times,
So I think I'm getting closer.

Need help with you Media room? The MCE HTPC Support Group

Edited by - Datahead on 17 October 2007 21:13:07
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 17 October 2007 :  21:33:44  Show Profile  Visit AnonJr's Homepage
The answer is closer than you think.

Search and ye will find: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16559
Go to Top of Page

Datahead
Starting Member

USA
14 Posts

Posted - 18 October 2007 :  01:03:21  Show Profile  Visit Datahead's Homepage  Send Datahead an AOL message
Thanks Anon:
Were making some real progress here. Got the forum up and running, but I somehow got the database in the same directory as the forum is. So now its a matter of moving the database. I tried moving it down one level, but now the the mappath points to the forum directory and I don't know how to change it. I tried using the Search engine, but it wasn't much help.

Need help with you Media room? The MCE HTPC Support Group
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 18 October 2007 :  06:27:47  Show Profile  Visit AnonJr's Homepage
Where you see:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("databasename.mdb")


Add the part in red:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/directory/databasename.mdb")


(using the name of the folder where it says "directory" and the name of the database where you see "databasename.mdb")

Edited by - AnonJr on 18 October 2007 06:28:36
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07