| Author |
 Topic  |
|
|
vweyes
New Member
74 Posts |
 Posted - 25 July 2002 : 17:27:40
|
First, you need to know that I get that Microsoft Jet error, so the only way I can set up the database is to use that 2nd data-base set up thing (if you search you can find it). Anyway, that doesn't work because tetris uses a seperate dbs file. so, when I try to set it up, it can't find the table that was created. So, what can I do?
Edited by - vweyes on 25 July 2002 17:31:24 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
|
vweyes
New Member
74 Posts |
Posted - 25 July 2002 : 17:33:24
|
quote:
is the forum working?
If so try the tips here for mod setup
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26081
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk
Yeah, the forum works fine. I just edited the topic so it makes more sense. Anyway, I think the problem is that it can't set up the seperate tetris database (because the mod uses tetris.dbs instead of the main database).
|
 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 July 2002 : 17:54:30
|
Are you sure you ran the dbs_setup, I cant see anything in the readme about using its own database, its says it makes a new table called FORUM_TETRIS, the .dbs fiel contains the instructioins to make the new table it looks like this
TETRIS Games
[CREATE]
TETRIS
userID
userName#varchar (50)#NULL#
userPassword#varchar (20)#NULL#
playingTimes#int#NULL#0
highestScore#int#NULL#0
[END]
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk |
|
|
|
vweyes
New Member
74 Posts |
Posted - 25 July 2002 : 18:00:16
|
quote:
Are you sure you ran the dbs_setup, I cant see anything in the readme about using its own database, its says it makes a new table called FORUM_TETRIS, the .dbs fiel contains the instructioins to make the new table it looks like this
TETRIS Games
[CREATE]
TETRIS
userID
userName#varchar (50)#NULL#
userPassword#varchar (20)#NULL#
playingTimes#int#NULL#0
highestScore#int#NULL#0
[END]
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk
yeah, that's what I put in, but when I went to try to set it up, it said there was no FORUM_TETRIS. So, I tried putting it in again and it said there already was a FORUM_TETRIS, so I know it went through.
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 July 2002 : 18:03:58
|
Can we have a link to the forum, or can you give us the full error message you get when viewing the page...
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk |
|
|
|
vweyes
New Member
74 Posts |
Posted - 25 July 2002 : 18:04:28
|
I also get this error when I try to run the mod_dbsetup.asp that comes with the tetris mod:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'Scripting.FileSystemObject'
/kjaboards/mod_dbsetup.asp, line 15
link to forum & error: http://freehost11.websamba.com/kjaboards/mod_dbsetup.asp
Edited by - vweyes on 25 July 2002 18:06:05
Edited by - vweyes on 25 July 2002 18:51:46 |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
|
vweyes
New Member
74 Posts |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 July 2002 : 18:40:33
|
Oh yeah I understand your first post now  bit slow on the uptake, hmm I'm not sure then, do you get an error related to the mod, that error is related to the table setup which the second way fixes...
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk |
|
|
|
vweyes
New Member
74 Posts |
Posted - 25 July 2002 : 19:03:09
|
Here is the error I get when I try to go to mod_tetris.asp:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_TETRIS'. Make sure it exists and that its name is spelled correctly.
/kjaboards/mod_tetris_login.asp, line 100
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 July 2002 : 19:10:33
|
Hmm I think that means the database has not be updated properly, as it cant find the table, but that brings us back to where we were...
*feels the water rising up...*
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk
Edited by - Hamlin on 25 July 2002 19:13:38 |
|
|
| |
Topic |
|
Topic Locked
