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: MOD Implementation
 HI, lost my programmer, but I almost have it!!!
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jackstraw
Starting Member

USA
19 Posts

Posted - 29 February 2004 :  19:46:34  Show Profile  Visit jackstraw's Homepage
ok, I know little about programming if anything. Having said that I am in the middle of something I need to finish...You will soon see what..

I will be changing the look of the page but I have been kinda busy..

Here is my dilemma...I needed to mod my barebones forum to do a bunch of stuff...since I lost the programmer I figured I would start over with the modded forum....Here is what I did...

I cut and paste the connection string from the one that was working into the one that I got in the new zip file. I then uploaded that into the www.root/forums folder on my site. That seems fine...

I seem to be having a problem with iis so I dont really know how to "run" the dbs. I dont remember exactly what I did when I started it in the first place because I started it and then passed it to the programmer.

so..along with changing the connection stuff and pointing it correctly ect..I simply uploaded the new dbs's to the same place where the other one was, renaming the snitz forum db, the name of mine so it could find it......

that is where I am currently,,,,,,It is sorta working, I am like a little kid sitting here trying to figure this out, it cant be that hard its just language??

if someone could give me some insight into the error I am receieving and likely how to run dbs from the site? I cant get into anything just yet....

forum can be found here www.thegraphicdesignresource.com

thanks much
Nigel lew

Edited by - ruirib on 29 February 2004 19:57:38

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 February 2004 :  19:59:15  Show Profile  Send ruirib a Yahoo! Message
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=51080&SearchTerms=flang


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 29 February 2004 :  22:40:57  Show Profile  Visit jackstraw's Homepage
can someone please steer me to the language install instuctions I dont see them anywhere?

thanks
Nigel
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 01 March 2004 :  02:20:53  Show Profile  Visit jackstraw's Homepage
ok well I guess I am having a data base issue or I put something in the wrong place??? I dont know I made a little headway but I might be backing up

www.thegraphicdesignresource.com
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 01 March 2004 :  03:06:08  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Looks like you're using a Serverhacker modded forum.

Since you don't have any topics or posts at your forum I'd suggest you go there, download the package which contains installation instructions.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 March 2004 :  07:28:54  Show Profile  Send ruirib a Yahoo! Message
Why did you change the connection string? Or did you delete your database file?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 01 March 2004 :  07:49:54  Show Profile  Visit jackstraw's Homepage
man I have been up all night I need to sleep....I started over with a fresh install...worked great on iis. so I uploaded but I seem to have two of some stuff and yeah my connection string isnt right?



'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("database/forums/tgdr04.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("tgdrforum") '## 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=" & ("tgdrforum") '## DSN

strTablePrefix = "FORUM_"


I think all I need to do is get that right but my www folder on the server is sort of a mess, web folder looks like this database, logs, ecomm, www.....in the www folder is forums folder, the three new dbs are both in forums folder and database folder....
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 01 March 2004 :  15:57:41  Show Profile  Visit jackstraw's Homepage
ok well it didnt kill me....lol

I have the forum working perfectly on iis...., I have removed everything except my actual webpage from the server so I just need to move the **** thing...How should I build my directory on the server so the thing will work. Here is my current connection string.


'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("/forum/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\websites\setup\db\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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 March 2004 :  17:39:46  Show Profile  Send ruirib a Yahoo! Message
Create a folder at the same level of your www folder. Name it DB, for example. Then place the mdb file there. The connection string should then be:

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

You need to use Windows Explorer to give read/write permissions on this DB folder and on the database itself to the IUSR_.... user. If you're not running the server talk to your host for him to do it.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07