|
twum
New Member
Netherlands
50 Posts |
 Posted - 27 March 2001 : 09:15:03
|
Hi,
I'm hoping someone can help me with this one.
I downloaded the files for link manager and put them in the forum directory. Then I run the links_mod_dbsetup.asp in the browser window and i had to choose Snitz Links Manager from the drop down box and then click on Update. This came up with a whole page full of error messages, and below are a few of them:
******************************
Creating table(s)...
CREATE TABLE LINKS_CATEGORIES( CAT_ID int COUNTER NOT NULL , CAT_NAME text (100) NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE LINKS_SUBCATEGORIES( SUBCAT_ID int COUNTER NOT NULL , SUBCAT_NAME text (100) NULL , CAT_ID int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE LINKS( LINK_ID int COUNTER NOT NULL , NAME text (100) NULL , URL text (100) NULL , KEYWORD text (255) NULL , DESCRIPTION text (255) NULL , EMAIL text (100) NULL , POST_DATE text (100) NULL , BANNER_URL text (100) NULL , HIT int NULL DEFAULT 0, CATEGORY int NULL , PARENT_ID int NULL , SHOW int NULL , BADLINK int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO LINKS_CATEGORIES (CAT_NAME) VALUES ('News and Media')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'LINKS_CATEGORIES'.
*******************************
Did I do something wrong or is there a bug somewhere in the code?
Help is very much appreciated.
thanks
twum
|
|
Topic Locked
