i am using free brinkster.com hosting, when i install the guesbook, run mod_dbsetup.asp, these errors occur:
GuestBook Addon
Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int COUNTER 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 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int COUNTER 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 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
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')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_GB_OPTIONS'.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE memo NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
I thought i was the problem with the FileObject! When i look at FQAs of Brinkster, it said that it does and only support writting to database directory ( database is in another directory, my forum in another directory).I would appriciate your help!
Regards,
ABCD