| Author |
 Topic  |
|
|
TFRadio
Starting Member
USA
5 Posts |
 Posted - 11 March 2001 : 18:25:15
|
Let me start off by saying that this forum app is by far the best I have ever seen. UBB is pretty good, but a little tough to understand certain aspects. I absolutely love the Snitz package, and will probably make a donation if I can actually iron out these problems.
I know that many of the experienced users will most likely begin to ignore me as soon as I say this, but I've never used ASP before. Never even considered it until I saw this package. So, becausee of this I must admit that I'm certain most, if not all, of my problems are due to my own ignorance.
I have a dedicated server with Win2K Adv. Server, SQLServer 7 (SP3), and IIS 5 installed.
Using the Internet Services Manager, I created a new web and directory named 'forum' within the default web site, and extracted the ZIP file contents to this directory. I also did the same with the 'tools.zip' to a subdirectory called 'tools'. I even moved the MDB file to the suggested directory even though I didn't intend to use it.
I then used SQL7's 'Enterprise Manager' to create a new, empty database called 'forum' using all default settings.
I then opened config.asp with Notepad and removed the ' from in front of strDBType = "sqlserver" as well as the appropriate strConnString. Specified the SERVER_NAME as localhost and the database as 'forum', but I was unsure of the uid and pwd settings, so left them alone. At this point I receive:
"The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : -2147467259"
when running the URL to the 'setup.asp' page.
I was thinking it had to do with not specifying a user and password in the strConnString, so I added the 'sa' account info and am still continuing to get this error.
Can anyone help a newbie and point me in the right direction, or provide straight answers without straying into UNIX-guru attitude? <g>
Thanks in advance,
-joe |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 11 March 2001 : 18:31:48
|
Well, you're not being ignored as you see. Welcome 
Like you thought, the problem probably has to do with not being able to connect to the database.
If you use the default sa account of Sql-server then the password is empty, if the sql server is on the same machine, try using the machine-name instead of localhost or the ip-number of the server.
So you would end up using:
strConnString = "driver={SQL Server};server=XXXXX;uid=sa;pwd=;database=Forum"
where XXXXX is the servername.
Pierre |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 18:31:49
|
instead of using localhost, try using your machine name, also check the SQL Network library settings to see if it is set to use TCPIP
|
|
|
|
TFRadio
Starting Member
USA
5 Posts |
Posted - 11 March 2001 : 18:42:55
|
Wow! Talk about quick responses. Thank you so much. :o)
Okay, I edited config.asp and replace 'localhost' with the actual servername, and it worked. It told me the tables needed to be created, then asked me for a database login. Entered the 'sa' account login and ran like a champ. Clicked on the 'Check Database' link, and everything was fine, then went to the forums and clicked on Admin Options, but was not asked to login again as outlined in the readme file.
How much of a problem will THIS be? Are 'my' forums wide open, security-wise, now?
Thanks again for the fast responses, too.
-joe
...Not all Blues are created equal...
TexasFloodRadio.Com |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 11 March 2001 : 18:47:15
|
hmm, it should have asked you to logon for a second time.
If you close the browser, and then return to the forum does it still not require you to logon before going into the Admin Options ?
Pierre |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 18:49:20
|
just to make sure everything is working ok, close down your browser and wait 5 minutes or so, then try admin_home.asp again, it should ask you to login.
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 11 March 2001 : 18:50:14
|
I checked your forum...and it worked ok for me...before I got access to the admin options I had to enter the admin username/password again.
But yes, the forum is wide open until you change the admin password.
You can do that by logging on as admin and then click on the profile link in the menubar.
It is best to do that right away
Pierre |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 18:52:59
|
hey isn't this fun
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 11 March 2001 : 18:57:51
|
It is, though it is way past my bedtime (need my beautysleep)  so I'm really logging off now.... (I think I also said that 2 hours ago)
Pierre |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 18:59:52
|
mmm... probably, but sleep tight anyway just incase you make it this time 
|
|
|
|
TFRadio
Starting Member
USA
5 Posts |
Posted - 11 March 2001 : 19:02:45
|
Fun? Yes, actually. So far, with help from you folks, this is working great! Tomorrow at lunch, I'll have to run out and grab a book or two on ASP and begin to explore the possibilities. This is really fantastic!
Thanks so much, folks.
...Not all Blues are created equal...
TexasFloodRadio.Com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 March 2001 : 19:06:24
|
| The reason you weren't asked to log in when you clicked on the Admin Options was because in the setup process you are asked for the Admin username/password which sets the Session cookie. So you were already logged in. |
|
|
|
TFRadio
Starting Member
USA
5 Posts |
Posted - 11 March 2001 : 19:26:23
|
Hmmm...one other thing.
I went and changed the Admin password, and when I log in as Admin, it doesn't seem to recognize me as such. I mean, it will accept my login, but I'm no presented woth a link to Admin Options, nor can I create/edit categories, all the little icons do do the admin tasks are gone, there's no "You are logged in as..." text. It's as if it doesn't accept the login, actually.
If I change the password back to the original "admin", things work just fine and everything is back to normal.
What am I still doing wrong here?
...Not all Blues are created equal...
TexasFloodRadio.Com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 March 2001 : 19:38:27
|
after you have changed the password, logout out of the forum, and delete any cookies you have pertaing to the forum on your computer. then log back in to the forum, that should fix it.
|
|
|
|
TFRadio
Starting Member
USA
5 Posts |
Posted - 11 March 2001 : 19:53:57
|
quote:
after you have changed the password, logout out of the forum, and delete any cookies you have pertaing to the forum on your computer. then log back in to the forum, that should fix it.
That was it! Thanks so much. (Again!)
...Not all Blues are created equal...
TexasFloodRadio.Com |
|
|
| |
Topic |
|
Topic Locked
