Author |
Topic  |
|
Datahead
Starting Member
USA
14 Posts |
Posted - 17 October 2007 : 19:09:25
|
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
|
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 |
 |
|
Datahead
Starting Member
USA
14 Posts |
Posted - 17 October 2007 : 21:09:33
|
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 |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
|
Datahead
Starting Member
USA
14 Posts |
Posted - 18 October 2007 : 01:03:21
|
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 |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 18 October 2007 : 06:27:47
|
Where you see:
Add the part in red:
(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 |
 |
|
|
Topic  |
|