| Author |
 Topic  |
|
|
Stickboy
Starting Member
USA
28 Posts |
 Posted - 13 April 2001 : 07:39:35
|
I tired to install the Events Calendar MOD and this is the error I received when executing mod_dbsetup.asp:
quote:
CREATE TABLE FORUM_EVENTS( EVENT_ID int IDENTITY (1, 1) NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
Can someone tell me what I did wrong?
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 07:54:11
|
could you state which strConn you are using in config.asp, the error says you are using 97, but the create table staement shown is for Jet4
|
 |
|
|
Stickboy
Starting Member
USA
28 Posts |
Posted - 13 April 2001 : 08:01:43
|
I just set up a System DSN for the database.
I am using access and the connect string is just the System DSN for the database.
I could not get the forums to work using the path.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 08:07:47
|
OK, this is the problem, unfortunately the mod_dbsetup does not like DSN connections, as it cannot work out which driver you are using, and it requires this information to calculate the SQL strings
|
|
|
|
Stickboy
Starting Member
USA
28 Posts |
Posted - 13 April 2001 : 08:09:54
|
I switched back to this connect string:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\www\db\snitz_forums_2000.mdb" '## MS Access 97
And I still cannot get the mod to work. 
I do not think our server is using Jet4.
The Microsoft Access Driver is v3.51.1029.00.
Does that make a difference?
Thanks,
Stickboy
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 08:25:06
|
what errors are you getting when not using the DSN connection
|
|
|
|
Stickboy
Starting Member
USA
28 Posts |
Posted - 13 April 2001 : 08:43:05
|
The same ones:
Calendar Errors:
quote:
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int COUNTER NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
Classified Events Errors:
quote:
Creating table(s)...
CREATE TABLE ADS_CONTENT( ID int COUNTER NOT NULL , TOPIC_ID int NOT NULL , NAME varchar(75) NULL , EMAIL varchar(50) NOT NULL , DATE_POSTED text (20) NOT NULL , PRICE varchar(20) NULL , AD_TITLE varchar(100) NOT NULL , CONTENT memo NOT NULL , ADDRESS varchar(100) NULL , CITY varchar(50) NOT NULL , STATE varchar(20) NOT NULL , ZIP varchar(12) NULL , LINK varchar(100) NULL , IMAGE_URL varchar(75) NULL , ADDED_BY int NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE ADS_CATEGORY( ID int COUNTER NOT NULL , CATEGORY_NAME varchar(50) NOT NULL , DESCRIPTION memo NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking man, etc...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.
I am using the latest version of Snitz Forums also 3.1sr4.
Thanks,
Stickboy
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 08:57:24
|
OK, edit your mod_dbsetup.asp and search for
if Instr(strConnString,"(*.mdb)") then
strSql = strSql & idFieldName &" int COUNTER NOT NULL "
and replace it with
if Instr(strConnString,"(*.mdb)") then
strSql = strSql & idFieldName &" COUNTER CONSTRAINT PrimaryKey PRIMARY KEY "
|
|
|
|
Stickboy
Starting Member
USA
28 Posts |
Posted - 13 April 2001 : 10:11:35
|
I am still getting errors:
Calendar Mod:
quote:
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
That change WORKED for the Classified Ads MOD.
Thanks,
Stickboy
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 12:16:01
|
OK, I think it is not liking the DEFAULT statement.
if you could open the dbs file, and look at the lines in it you will see that most of them either end in a ; or a # depending which version you have, find the line which references PRIVATE, you will see that that ends with a 0, remove the 0 and try again
|
|
|
|
Stickboy
Starting Member
USA
28 Posts |
Posted - 13 April 2001 : 12:36:37
|
Thanks! That did the trick!
Stickboy
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 13 April 2001 : 12:41:46
|
Glad your sorted.
|
|
|
| |
Topic |
|
|
|
Topic Locked
