| Author |
 Topic  |
|
|
roontoon
Starting Member
10 Posts |
 Posted - 06 May 2003 : 14:28:49
|
Can anyone point me to where the docs are if there are any for creating a script file that alters the Snitz dbf ala a dbs_xxx.asp file? I am working on a mod that will require the modification of the database and if there is a shortcut here other than rooting around in the code of the admin_mod_dbsetup.asp file to figure it out..... Thanks MUCH in advance.
 |
|
|
Steve D.
Average Member
USA
640 Posts |
|
|
roontoon
Starting Member
10 Posts |
Posted - 06 May 2003 : 15:31:10
|
quote:
Originally posted by Steve D.
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=25296&SearchTerms=dbs,file,mod
Thanks and now a question....
I have created this test dbs file
MOD: Test
[CREATE]
NEWS
NEWS_ID
NEWS_TITLE#VARCHAR (100)#NULL#
NEWS_DESCRIPTION#memo#NULL#
NEWS_ORDER#int#NULL#1
NEWS_CAT#int#NULL#
[END]
When I run it I get the following error and nothing is created.
Creating table(s)...
CREATE TABLE NEWS( NEWS_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , NEWS_TITLE text (100) NULL , NEWS_DESCRIPTION memo NULL , NEWS_ORDER int NULL DEFAULT 1, NEWS_CAT int NULL )
CREATE TABLE NEWS( NEWS_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , NEWS_TITLE text (100) NULL , NEWS_DESCRIPTION memo NULL , NEWS_ORDER int NULL DEFAULT 1, NEWS_CAT int NULL )
424 | Object required
What am I doing wrong???? TIA  |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 May 2003 : 15:43:25
|
| what database are you using ? |
|
|
|
roontoon
Starting Member
10 Posts |
Posted - 06 May 2003 : 16:06:22
|
quote:
Originally posted by HuwR
what database are you using ?
Access |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 May 2003 : 17:09:02
|
are you using the jet or older (*.mdb) drivers ?
Also check to see if there is an update, I think a fix was released for it, alternatively
try removing the 1 on the line NEWS_ORDER#int#NULL#1
|
|
|
|
roontoon
Starting Member
10 Posts |
Posted - 06 May 2003 : 17:27:31
|
quote:
Originally posted by HuwR
are you using the jet or older (*.mdb) drivers ?
Also check to see if there is an update, I think a fix was released for it, alternatively
try removing the 1 on the line NEWS_ORDER#int#NULL#1
This is on my hosting site so I beleive that they would have the most up to date driver. I will try removing the one.... how about the # before it?
|
|
|
|
roontoon
Starting Member
10 Posts |
Posted - 06 May 2003 : 17:49:51
|
quote:
Originally posted by HuwR
try removing the 1 on the line NEWS_ORDER#int#NULL#1
Just tried to remove the 1 and it had no effect.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 May 2003 : 18:40:30
|
| it doesn't matter what driver your host has, which one are you using in config.asp ? |
|
|
|
roontoon
Starting Member
10 Posts |
Posted - 06 May 2003 : 19:28:57
|
quote:
Originally posted by HuwR
it doesn't matter what driver your host has, which one are you using in config.asp ?
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\roontoon\roontoon\admin\databasename.mdb" '## MS Access 2000 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 May 2003 : 20:10:27
|
I am not sure what is wrong, what value are you using for strForumPrefix ?
also, do you have the correct strDBType set ? |
|
|
| |
Topic |
|
Topic Locked
