| Author |
 Topic  |
|
RampantMind
Starting Member
26 Posts |
 Posted - 29 March 2001 : 21:35:14
|
WTF does this mean:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7ac Thread 0x73c DBC 0x2495024 Jet'.
/forum/inc_top.asp, line 42
I know its probably a simple answer... but... yeah, thanks for the help.
Webmaster - Dreamcastfun.com
Edited by - RampantMind on 30 March 2001 17:22:37 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 March 2001 : 23:57:29
|
Can you post the connection string you are trying to use?
It's the line that starts with strConnString in config.asp |
 |
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 16:50:37
|
Nevermind, I got it. The path to my database wasnt e:/83/dreamcast.../cgi-bin/snitz_forums_2000.mdb like it shows up on FTP, but e:/domains/dreacas.../cgi-bin/snitz_forums_2000.mdb
I do have another problem, I am unable to upgrade and install mods. I run the mod_dbsetup.asp, the forum annoucements mod doesnt show up, when I try to run the avatar setup, I get this:
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , A_URL#varchar (255)#NULL# NOT NULL , A_NAME#varchar (50)#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
CREATE TABLE FORUM_AVATAR2( A_SIZE#int#NULL# NOT NULL , A_BORDER#int#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Whats wrong??
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 March 2001 : 17:07:46
|
You are using an old version of mod_dbsetup make sure you are using the one that cane with the mod.
I removed the post you made in the other topic, since they are not related.
|
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 17:16:09
|
I am using the one that came with the mod, so am I just using an older mod?
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 18:43:55
|
I've also tred with the one that comes with my release, which is 4... I think. I've got the latest, downloaded it two days ago to place some code I screwed up, so... what ever shall I do?
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 March 2001 : 18:44:49
|
relace your mod_dbsetup.asp with this one
mod_dbsetup
|
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 19:20:38
|
thanks for the help! Hopefully this will work...
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 19:46:38
|
I'm stilling getting the same errors, any idea what else could be wrong?
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 March 2001 : 20:11:33
|
which error are you still getting ? the one when running mod_dbsetup, or the one when trying to add an avatar?
You should also try changing your connectionstr to the Jet 4 driver instaed of the access 97
|
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 20:42:59
|
I get this error whenever doing any kind of database upgrading:
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , A_URL#varchar (255)#NULL# NOT NULL , A_NAME#varchar (50)#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
CREATE TABLE FORUM_AVATAR2( A_SIZE#int#NULL# NOT NULL , A_BORDER#int#NULL# NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Thats what I get for avatars, but its basically the same thing for anything. And forum announcements aren'y showing up at all in mod_dbsetup.asp, but that very well could be because I dont have the call to the file in inc_top.asp, but the database wouldnt update when they were either, it still wouldnt show up... what have I done to my database?
and this is what happens when I switch up drivers(from 97 to Jet):
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : -2147467259
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick.
Edited by - RampantMind on 30 March 2001 20:44:57 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 March 2001 : 20:50:41
|
can you send me the following.
the dbs files you are trying to use, and the mod_dbsetup.asp from your forum.
|
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 30 March 2001 : 21:02:29
|
I'm using the mod_dbsetup file that you gave me the link to above; my database is 6 or 7 megs. Thats where I beleive the problem lies. If you still want my database, I'll send it tomarrow. I'm out for tonight... I have a party to go to ;)
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 March 2001 : 21:08:50
|
No I don't want your db, just the files you are trying to execute, download them from your webspace, and send them to me please, I will check why they are not working.
Also, the mod_dbsetup I posted above is NOT the mod_debsetup running on your site, if it was you would have got a different error, since it would not have found any of your dbs files.
|
|
|
|
RampantMind
Starting Member
26 Posts |
Posted - 01 April 2001 : 12:55:02
|
Okay... sorry about the delay, I was going to try to figure it out on my own. Ok, I'd miss placed your mod_dbsetup.asp in another dir, thats why it didnt change, now its up... but no mods show up. So... I'll send you the files, whats your email so I can send these for ya.
Webmaster - Dreamcastfun.com
Hardware: The part of the computer can kick. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 01 April 2001 : 19:34:49
|
if no mods show up, that is good, it means it is now using the new mod_dbestup, to get the mods to show, rename the .dbs files to dbs_filename.asp instead of filename.dbs
|
|
|
|
Topic |
|
Topic Locked
