Author |
Topic  |
|
Therion93
Junior Member
 
USA
263 Posts |
Posted - 19 June 2001 : 01:12:32
|
In trying to install this mode on a fresh install of Snitz 3.1sr4 I get the following error when I run mod_dbsetup.asp:
Creating table(s)... 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 Driver] Syntax error in CREATE TABLE statement.
I'm using an Access2000 db (converted the default) with a DNS.
Any suggestions?
Therion93 Because Legends Never Die! - Kiss-Forever.Net - HuwR's SR4 Release Mysteries & Magick Mysteria Magicka - Portal & Snitz Forums 2000 32a06
Edited by - Therion93 on 19 June 2001 01:13:25 |
|
dayve
Forum Moderator
    
USA
5820 Posts |
Posted - 19 June 2001 : 01:23:13
|
ok, whenever I run into a problem like this I find the most recent copy of mod_dbsetup.asp which can be found in the MOD W/Code area. Sorry I don't have a specific link.
one thing and I know I am going to get pinged for doing this but I noticed you are a KISS fan or at least run a KISS site. I love KISS too but I run a NIN site and recently I posted a topic about the KISS Kasket...

very cool...
Dayve |
 |
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 19 June 2001 : 01:54:29
|
hmm, i'm not clear why you're getting that error on the create statement.
do like dayve said and try it with the latest mod_dbsetup and see if that works.
Another possibility is that your DSN connection doesn't have the latest MDACS or something. Try it with the access 2000 connection string without the DSN.
- Alan www.iamviet.com www.calvsa.net Snitz Resource |
 |
|
Therion93
Junior Member
 
USA
263 Posts |
Posted - 19 June 2001 : 11:08:01
|
Dayve,
Yeah I saw the casket thing awhile ago. For me, that was the last straw. I mean merchandise marketing is one thing, but this crap is just silly. BTW, my KISS site will be closing on June 30th due to lack of interest (mine as well as the site just not being used).
Aznknight,
Changing the connection string worked like a charm. I guess I'll leave it that way until I get all the mods I want installed. Any idea why this doesn't work with a DSN connection? I would just like to know for informational purposes.
Edited by - Therion93 on 19 June 2001 11:10:49 |
 |
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 19 June 2001 : 16:20:43
|
quote:
Any idea why this doesn't work with a DSN connection? I would just like to know for informational purposes.
I think using dsn means it uses the system's default Microsoft Data Access Component (MDAC), which is usually not the latest or is a pretty generic one.
- Alan www.iamviet.com www.calvsa.net Snitz Resource |
 |
|
Therion93
Junior Member
 
USA
263 Posts |
Posted - 19 June 2001 : 16:58:41
|
That's good to know. I will talk to my hosting service about it.
Thanks!
Therion93 News Ways, New Ways..... Well I Dream Of Wires.. (Coming Soon) |
 |
|
|
Topic  |
|