Problem with the MudDatabase plugin.

Posted by MushclientNewbie on Fri 26 Mar 2004 03:24 AM — 9 posts, 32,640 views.

USA #0
At first, I was getting an error on line 180 with the 'OnSetup' subroutine. I realized it might be because I wasn't giving the plugin a file to make the database in. So, I set this up:

setdatabase C:\Program Files\MUSHclient\database.mdb

I get the 'Database changed to' message just fine. Then, as a test I used the example realms_of_despair line and got nothing but a newline as output. Sure enough, listmuds didn't show anything either. Before all of this I got Jet 4.0 as well as WindowsScript5.6 just to be safe. For the most part - I don't think that's my problem.

To get the setdatabase command to work I had to make the \Mush\database.mbd file with a word program and then just give it the mdb extension. Otherwise MUSHclient would return a "File 'blahblah' does not exsist' error. So, there could be header and footer info and such that I'm missing, but I dunno how I would get something like that to work. And yea, it is a .mdb extension not database.mdb.txt ^^.
USA #1
Umm. First off.. It is hard to say where the error happened or why with the info you gave. Second, databases are a binary format that includes 8 system tables describing everything from the tables and columns themselves to who has authority to access them, even 'before' you get the the actually information you put into it. Needless to say, making something in word and trying to save it as a mdb file isn't going to do the job.

In any case, without a precise error, it is hard to say what the problem is. If it is a 'file does not exist' error.. Then sounds like you never got the file created, in which case the critical ADOX dll may be missing. This file is 'not' installed with the basic database files I think, but requires that you install something called MDAC, which includes both the database drivers and a mess of other files for special uses, including the ADOX dll that Mushclient needs. 90% of the other programs don't require or use ADOX, since VB and other compilers 'link' directly to the database engines in a way that lets them create files directly through them. ADOX is designed to allow scripts the same ability and isn't therefor normally installed on the computer.

However, if you did install the MDAC files from the links on this site... I have no clue what is going wrong and we still need that error message. ;)
USA #2
Okay, I thought that might be it. So I get rid of the fake .mdb file that I made. Then, how am I supposed to tell the MudDatabase plugin where I want all the tables and whatnot stored? It refuses to make a new file.
USA #3
List I said, if you really do have the latest database drivers (which is to say *all* of them, including the ADOX dll), then it should create the file automatically. If it isn't doing so, then it probably means you don't have the correct system files. Try looking for msadox.dll in the 'C:\Program Files\Common Files\SYSTEM\ADO' directory. If there is no such directory at all or the msadox.dll is missing, then you need to install the latest version of the drivers to get it. The driver are in something called the MDAC. (Microsoft Data Access Controls) Though how you ended up with Jet 4.0, but are missing the rest of the MDAC files....

If that isn't the problem, then I am not sure what else to look for.
USA #4
You were right. I have the the directory and a few dlls, but not the dox dll.

Okay, I got rid of the fake database file and I have the complete MDAC. But, I still can't get the plugin to make the database:

Could not find file 'C:\Program Files\MUSHclient\database.mdb'.
File 'C:\Program Files\MUSHclient\database' does not exist.
File 'C:\Program Files\MUSHclient\database.mdb' does not exist.
Amended on Fri 26 Mar 2004 11:56 PM by MushclientNewbie
USA #5
At this point I haven't a clue..
Australia Forum Administrator #6
Have you read Calendar - todo list, events? This describes some of the problems using the database and possible solutions.
Australia Forum Administrator #7
The plugin is supposed to create the database if it doesn't exist. Creating a blank file in Word or something will totally defeat that behaviour, because it expects a database file, not a Word file.

Are timers enabled? If you look at the plugin it uses a 5-second timer to create the database after installation.

I would delete the "state" file for that plugin and try again.
USA #8
Man, that was an adventure :(. Cleaned out the states and restarted MUSHclient and it worked. Thanks.