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
 connection string problem maybe
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jackstraw
Starting Member

USA
19 Posts

Posted - 09 March 2004 :  23:49:18  Show Profile  Visit jackstraw's Homepage
I am using a modded forum from sh.....I havent really been able to get an answer on anything over there for days so here is my question...

Nothing seems to work, ie: file and photo upload, guestbook, if you click on the member name under member spotlight it goes to an empty page? http or iis error.. All my permissions are fine I think..

Here is what I have been able to figure out on my own....I did not have a dns(data string thing?) set up on the server. So while talking to the isp, I had them set up an sql server assuming it would be better. so that is in place and I can change it to access or whatever on the fly now also.

the problem is I have only been able to get the whole thing to work on the connection string that worked on iis on my computer which was the brinkster free server string...Presumeably I need to be using a different one?


So, could this have something to do with my problems..I shouldnt really have to do anything I started with a clean install so all dbs were already present etc...

Having said all of that, the only person who volunteed to crawl in there and see what was up cant get to that page at all? I dont know?

Hence, does anyone have any suggestions. I dont really want to have anyone do anything for me, I have perservered this far. I couldnt get it up at all for a couple days but I stuck with it..

So I would maybe need to shoot someone some server info off list and maybe get a little connection string help I am unfamiliar with how to plug in server info, cus the string looks a little different?(yeah I know).....Also, If I am unable to make this work in a day or so I may need to have someone do it I guess. Who can I inquire with about said task, I saw it in a thread somewhere...

thanks much..
Nigel lew can you'll see the page in progress?

www.thegraphicdesignresource.com the second button should take you to the forum...I am almost done with the new website the one sitting there is a bit of an eyesore lol......

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 10 March 2004 :  03:23:10  Show Profile  Visit HuwR's Homepage
couple of points.

1) if you come here looking for help, it is generally not a good idea to force us to register before we can take a look at your forum.

2) You really should be asking your questions at SH's forum not here, we are not familiar with his code and do not offer support for it, if you get no joy at their forum, then I would suggest that you download someone elses modded forum where you can get support.
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 10 March 2004 :  03:30:25  Show Profile  Visit jackstraw's Homepage
reg. should no longer be required
thanks
Nigel
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 10 March 2004 :  03:57:21  Show Profile
the problem with the member spotlight link is that you have your Forum URL entered wrong.

Admin Options --> Main Forum Configuration --> Forum URL

you have: http://www.thegraphicdesignresource.com/forums/default.asp/

it should be: http://www.thegraphicdesignresource.com/forums/

that could be the culprit for some of your other problems as well.
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 10 March 2004 :  04:20:25  Show Profile  Visit jackstraw's Homepage
Richard I can't thank you enough finally something worked

as for my connection string my server is currently set up for an"sql server" hence I gather I should use this string? Its on the free brinkster string

strConnString = "driver={SQL Server};server=ipsqlrooo7atl2;uid=UID;pwd=PWD;database=snitz_forums_2000.mdb" '## MS SQL Server...

I need to move my .dbs back a level I think, they are in the forums folder. So I would have db's, logs, www, ecomm, then, in www, my forums folder??what I dont quite get on this string is server_ip. Does that look right. I will change name of db obviously too...

Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 10 March 2004 :  04:26:49  Show Profile  Visit Gremlin's Homepage
If your using SQL Server there are most likely no physical "database files" that you have access to. The .dbs files you refer too are just files with a number of commands contained within which are used by the Admin screens to make changes to database tables for various mods that come with the SHN Portal version.

That connection string you have there will not work unless you actually have a SQL Server database called snitz_forums_2000.mdb (not sure its possible to name a SQL Database with a period in it)

You mentioned earlier your host setup a DSN for you? If so then the DSN should already point to the correct database and the connection string you'd then use would be

'strConnString = "DSN_NAME" '## DSN

DSN_NAME is the name of the DSN your host should have supplied you.

Alternatively if you are indeed using SQL Server then the best connection string to use would be

'strConnString = "Provider=SQLOLEDB;................
(Theres only one that starts like that) though using this one you'll need some info from your host like server name, database name, logon user name/password etc.

BTW I'm also having trouble accessing your site, right now I'm getting a "Service Unavailable" message.

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 10 March 2004 04:29:28
Go to Top of Page

jackstraw
Starting Member

USA
19 Posts

Posted - 10 March 2004 :  04:40:50  Show Profile  Visit jackstraw's Homepage
ok well it sounds like I will want to use an access database...I will have to go look at my admin panel. I have control over all of that stuff, I just dont quite get it..I can set up whatever dns I want I think, I know I can tell it access, sql etc, then it just happens.. I will try to switch it to access then change my config file. Done that enough times lol..

as for service unavailable, that just happened, and thats what happens when I attempt to upload a file or photo, it locks up the whole page for about 3-4 minutes...?? There was a default photo in uploads, admin, so that is what I set my path to be, I may have just removed admin but it didnt seem to work either,,,,I have read, write ,delete permissions from the server on the uploads folder.

If you want to take a look at the server feel free to shoot me an email and I will give you ftp login...

thanks again guys
Nigel

I will go change to access now
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.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07