Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Event Calendar v 2sr1
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Therion93
Junior Member

USA
263 Posts

Posted - 19 June 2001 :  01:12:32  Show Profile  Send Therion93 an ICQ Message
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  Show Profile  Visit dayve's Homepage
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
Go to Top of Page

Aznknight
Senior Member

USA
1373 Posts

Posted - 19 June 2001 :  01:54:29  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
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
Go to Top of Page

Therion93
Junior Member

USA
263 Posts

Posted - 19 June 2001 :  11:08:01  Show Profile  Send Therion93 an ICQ Message
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
Go to Top of Page

Aznknight
Senior Member

USA
1373 Posts

Posted - 19 June 2001 :  16:20:43  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
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
Go to Top of Page

Therion93
Junior Member

USA
263 Posts

Posted - 19 June 2001 :  16:58:41  Show Profile  Send Therion93 an ICQ Message
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)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.5 seconds. Powered By: Snitz Forums 2000 Version 3.4.07