| Author |
 Topic  |
|
|
quietstorm
Starting Member
27 Posts |
 Posted - 06 April 2001 : 02:49:14
|
can someone tell what I might be doing wrong...my forum works fine, but the guestbook mod won't! (have tried the mod_dbsetup.asp)
Thanks
url is "http://www.barcin.net/forum/
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 April 2001 : 04:43:11
|
looks like your tables were not created for the guestbook, try re-running mod_dbsetup note down any errors it produces
|
 |
|
|
quietstorm
Starting Member
27 Posts |
Posted - 06 April 2001 : 04:46:40
|
quote:
looks like your tables were not created for the guestbook, try re-running mod_dbsetup note down any errors it produces
here is what I get...
Snitz Forum Modifications
Database Setup.....
Your strDBType is not set, please edit your config.asp
to reflect your database type
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 April 2001 : 05:15:32
|
The problem is exactly as it states, check your config.asp and ensure you have uncommented one of the strDBType lines to reflect your choice of DB
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 06 April 2001 : 10:17:24
|
quote:
The problem is exactly as it states, check your config.asp and ensure you have uncommented one of the strDBType lines to reflect your choice of DB
Still having problems when I uncommented all of them..one at a time!!
Strange tho, my forum is working fine, but not this!
what else can I do?
Thanks
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 April 2001 : 18:33:54
|
Saying you still having problems, isn't helping you or us. You need to tell us what happened when you tried un-commenting one of the strDBType strings. Did you get an error? What was the error?
And what database type are you using? SQL, MySQL or Access?
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 07 April 2001 : 01:23:57
|
quote:
Saying you still having problems, isn't helping you or us. You need to tell us what happened when you tried un-commenting one of the strDBType strings. Did you get an error? What was the error?
And what database type are you using? SQL, MySQL or Access?
I am using MS 200 Access and it is pondering me why my forum it working..if my strDBType wasn't set correctly, my forum wouldn't be working..but it is!
I am lost!!
Thanks
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 07 April 2001 : 04:50:23
|
again... I have uncommented either MS Access 97 or 2000 and my forum works perfect!! (Using ACCESS as my database) The guestbook still continues to give me the same error when I uncomment as the beginning....
Snitz Forum Modifications
Database Setup.....
"Your strDBType is not set, please edit your config.asp to reflect your database type"
This must not be my day!!
I might just give up and forget the whole thing!!
Thanks
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 April 2001 : 13:00:07
|
Post your strDBType code from your config.asp file so we can take a look at it.
HuwR, is this an updated version of your mod_dbsetup.asp file he/she is using?
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 07 April 2001 : 19:51:31
|
quote:
Post your strDBType code from your config.asp file so we can take a look at it.
HuwR, is this an updated version of your mod_dbsetup.asp file he/she is using?
Here you go.....
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=*:\**\**\***\***\snitz_forums_2000.mdb;" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("*:\***\***\***\****\snitz_forums_2000.mdb;") '## MS Access 2000
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*:\***\*****\*********\********\snitz_forums_2000.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
the path is not shown, due to security reasons
thanks again!!
Edited by - quietstorm on 07 April 2001 19:55:02 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 April 2001 : 23:26:44
|
Ok, that was your strConnString.
I need to see your strDBType code. It comes before the code you just posted, in your config.asp file.
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 08 April 2001 : 00:19:37
|
quote:
Ok, that was your strConnString.
I need to see your strDBType code. It comes before the code you just posted, in your config.asp file.
Dave...
check your email and or ICQ!!
Thanks
|
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 08 April 2001 : 13:32:47
|
quote:
Ok, that was your strConnString.
I need to see your strDBType code. It comes before the code you just posted, in your config.asp file.
ok..here is everything!!
on error resume next
Session.LCID = 1033 '## Do Not Edit
Response.Buffer = true
dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=*:\****\*****\*********\********\snitz_forums_2000.mdb;" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("*:\****\*****\*********\********\snitz_forums_2000.mdb;") '## MS Access 2000
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*:\****\*****\*********\********\snitz_forums_2000.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Can someone plz help..this is getting out of hand on my hand!!
Thanks
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 08 April 2001 : 14:32:27
|
the error statement says uncomment one of these:
'strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
You're probably using this one:
strDBType = "access"
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
quietstorm
Starting Member
27 Posts |
Posted - 08 April 2001 : 14:52:13
|
quote:
the error statement says uncomment one of these:
'strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
You're probably using this one:
strDBType = "access"
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
getting this error now....
Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int IDENTITY (1, 1) NOT NULL , G_NAME VARCHAR (50) NOT NULL , G_EMAIL VARCHAR (100) NOT NULL , G_WEBSITE VARCHAR (100) NULL , G_ICQ VARCHAR (30) NULL , G_MESSAGE memo NOT NULL , G_DATE VARCHAR (50) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL )
-2147217900 | Table 'FORUM_GUESTBOOK' already exists.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int IDENTITY (1, 1) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL , G_V1_SWITCH INT NOT NULL , G_V2_SWITCH INT NOT NULL , G_V3_SWITCH INT NOT NULL )
-2147217900 | Table 'FORUM_GB_OPTIONS' already exists.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_VARFIELD1, G_VARFIELD2, G_VARFIELD3) VALUES (0, 0, 0, 'ab', 'ab', 'ab')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE memo NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217887 | Field 'G_MESSAGE' already exists in table 'FORUM_GB_OPTIONS'.
Table(s) updated
Been working 12-14 hrs a day at my work and trying to gt my forum going when I get home. Must be tired and need the rest..ehh?
Edited by - quietstorm on 08 April 2001 20:16:52 |
|
|
|
MisterVB
Junior Member
274 Posts |
Posted - 08 April 2001 : 21:46:57
|
dude that error happened cause you ran the mod_dbsetup already... thats just telling you the tables are already there. The guestbook will work fine now.
|
|
|
| |
Topic |
|
Topic Locked
