Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ MUSHclient ➜ Plugins ➜ Problem with the MudDatabase plugin.

Problem with the MudDatabase plugin.

It is now over 60 days since the last post. This thread is closed.     Refresh page


Posted by MushclientNewbie   USA  (33 posts)  Bio
Date Fri 26 Mar 2004 03:24 AM (UTC)
Message
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 ^^.
Top

Posted by Shadowfyr   USA  (1,792 posts)  Bio
Date Reply #1 on Fri 26 Mar 2004 06:45 PM (UTC)
Message
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. ;)
Top

Posted by MushclientNewbie   USA  (33 posts)  Bio
Date Reply #2 on Fri 26 Mar 2004 07:42 PM (UTC)
Message
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.
Top

Posted by Shadowfyr   USA  (1,792 posts)  Bio
Date Reply #3 on Fri 26 Mar 2004 08:09 PM (UTC)
Message
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.
Top

Posted by MushclientNewbie   USA  (33 posts)  Bio
Date Reply #4 on Fri 26 Mar 2004 10:33 PM (UTC)

Amended on Fri 26 Mar 2004 11:56 PM (UTC) by MushclientNewbie

Message
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.
Top

Posted by Shadowfyr   USA  (1,792 posts)  Bio
Date Reply #5 on Sat 27 Mar 2004 12:08 AM (UTC)
Message
At this point I haven't a clue..
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #6 on Sat 27 Mar 2004 12:43 AM (UTC)
Message
Have you read Calendar - todo list, events? This describes some of the problems using the database and possible solutions.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by Nick Gammon   Australia  (23,173 posts)  Bio   Forum Administrator
Date Reply #7 on Sat 27 Mar 2004 12:46 AM (UTC)
Message
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.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

Posted by MushclientNewbie   USA  (33 posts)  Bio
Date Reply #8 on Sat 27 Mar 2004 12:56 AM (UTC)
Message
Man, that was an adventure :(. Cleaned out the states and restarted MUSHclient and it worked. Thanks.
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


30,824 views.

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum


[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.