Where are the .mdb files?
.mdb
Posted by Syros on Tue 29 Jul 2003 04:32 AM — 18 posts, 74,254 views.
What .mdb files are you referring to? Which plugin are you using? The ones that need mdb files create them as part of the plugin.
Both the Calendar and the MudDatabase told me that. This is the message I get "Could not find file 'C:\Program Files\MUSHclient\worlds\calendar.mdb'." and "Could not find file 'C:\Program Files\MUSHclient\worlds\mushclient_db.mdb'."
It is supposed to detect they are not there, and create them. Try removing and reloading the plugin(s).
Tried reinstalling them and no such luck.
Try reading the posting about Calendar, todo list, events - towards the end (page 3) is offered a copy of at least one of the databases, and maybe in the middle you might find the solution.
This whole thing doesn't show:
Plugin Calendar installed.
Database 'C:\Program Files\MUSHclient\worlds\calendar.mdb' created.
Table 'todo' created.
Table 'event' created.
Database is: C:\Program Files\MUSHclient\worlds\calendar.mdb
Plugin Calendar installed.
Database 'C:\Program Files\MUSHclient\worlds\calendar.mdb' created.
Table 'todo' created.
Table 'event' created.
Database is: C:\Program Files\MUSHclient\worlds\calendar.mdb
Did you check the other things described in that posting? For instance, which VBscript version do you have? There is a plugin that will tell you that.
Also, do you have the appropriate versions of the database DLLs? They are also mentioned in that posting, and in the description for that plugin.
Also, do you have the appropriate versions of the database DLLs? They are also mentioned in that posting, and in the description for that plugin.
Script engine = JScript
Version = 5.6
Build = 8513
Script engine = VBScript
Version = 5.6
Build = 7426
Plus I have those plugins but scrrun.dll is higher than yours.
Version = 5.6
Build = 8513
Script engine = VBScript
Version = 5.6
Build = 7426
Plus I have those plugins but scrrun.dll is higher than yours.
What version of MUSHclient do you have? Are timers enabled? Have you changed the timer interval (global preferences) from the default of 1 second?
3.42 and I didn't know about those other things.
If you go into the control panel (Start - Settings - Control Panel on Windows 98, probably similar on the others), then you should see something called ODBC Datasources. Under the Drivers tab you should see something like 'Microsoft Access Driver (.mdb)'. If you can't find this in the control panel or you manage to load the control, but the driver is missing from the list, then you may for some odd reason not have it installed. It is also possible that only the ADO drivers are missing. Check for them in "C:\Program Files\Common Files\SYSTEM\ADO". Since these plugins employ the ADO method of creating a database (pure VB or C++ can use a more direct method), if they are missing, it won't work.
If you can't find any of these things on your computer, then you will have to download and install the actual ODBC database stuff from Microsoft, MDAC specifically. The link for this is in the for first page of the mess of posts Nick already pointed you to. Assuming of course that Micro$loth didn't rearrange all there links again by now. :( The have a bad habit of this sometimes.
The problem with these plugins is there are no real checks. It simply assumes everything is working, since most peoples computers 'should' already have all these things on them. For a plugin this is reasonable, but in a real program you would check to make sure that the ADO object actually got created, that each command actually executed without an error, etc. The plugins have no such safe guards unfortunately, so when something goes wrong it just hops along to the next command without stopping. Or if it does check, then it is only telling you when it actually worked, which isn't quite as helpful.
If something else is going wrong...
If you can't find any of these things on your computer, then you will have to download and install the actual ODBC database stuff from Microsoft, MDAC specifically. The link for this is in the for first page of the mess of posts Nick already pointed you to. Assuming of course that Micro$loth didn't rearrange all there links again by now. :( The have a bad habit of this sometimes.
The problem with these plugins is there are no real checks. It simply assumes everything is working, since most peoples computers 'should' already have all these things on them. For a plugin this is reasonable, but in a real program you would check to make sure that the ADO object actually got created, that each command actually executed without an error, etc. The plugins have no such safe guards unfortunately, so when something goes wrong it just hops along to the next command without stopping. Or if it does check, then it is only telling you when it actually worked, which isn't quite as helpful.
If something else is going wrong...
I got the calendar working with the database Nick put up but I still can't get the MudDatabase to work. I have the .mdb driver and I have the .dlls but for some reason it still won't work. Why not just tell me how to make the database and I'll go from there. Might be easier that way.
Because there is no way to do that. The ADO system creates it. You could possibly use the control panel to create one with the right name, but even then, you still have to use commands in the plugin to generate the tables and things. There is no simple 'just open notepad and type ....' method to do so, these are compressed files generated through special applications and nothing short of using ADO or writing a full program in VB or C++ will allow you to simply create the file from scratch and even then you have to rely in functions that may not work if something is not installed that it needs.
It is possible something is not installed properly or that some, but not 'all' of the dlls are there. ADO contains two parts, ADO and ADOX. ADO is used to manage things like the tables and stuff, but "can't" actually create the database. The complete set of ADO files (at least on my system) are:
MSADOMD DLL 172,304 05-27-02 6:10p msadomd.dll
MSADOX DLL 184,592 05-27-02 6:10p msadox.dll
MSADO15 DLL 487,696 05-27-02 6:10p msado15.dll
MSADOR15 DLL 57,616 05-27-02 6:10p msador15.dll
If msadox.dll is missing, it won't work anyway. This is quite possible, since the default installation that comes with Windows probably only supplies the files needed to 'read or modify' databases, not actually create them. If it isn't working, then one of these files has to be missing or not installed correctly. I can't tell you how to create the database any other way. No one except maybe Microsoft themselves is likely to have a clear enough understanding how to do that to create one manually. Try installing the newest MDAC. That should install any missing files or fix any glitches that keep it from working. If not, then I haven't a clue what to do about it.
It is possible something is not installed properly or that some, but not 'all' of the dlls are there. ADO contains two parts, ADO and ADOX. ADO is used to manage things like the tables and stuff, but "can't" actually create the database. The complete set of ADO files (at least on my system) are:
MSADOMD DLL 172,304 05-27-02 6:10p msadomd.dll
MSADOX DLL 184,592 05-27-02 6:10p msadox.dll
MSADO15 DLL 487,696 05-27-02 6:10p msado15.dll
MSADOR15 DLL 57,616 05-27-02 6:10p msador15.dll
If msadox.dll is missing, it won't work anyway. This is quite possible, since the default installation that comes with Windows probably only supplies the files needed to 'read or modify' databases, not actually create them. If it isn't working, then one of these files has to be missing or not installed correctly. I can't tell you how to create the database any other way. No one except maybe Microsoft themselves is likely to have a clear enough understanding how to do that to create one manually. Try installing the newest MDAC. That should install any missing files or fix any glitches that keep it from working. If not, then I haven't a clue what to do about it.
MSADER15.dll
MSADO15.dll
MSADOMD.dll
MSADOR15.dll
MSADOX.dll
MSADRH15.dll
MSJRO.dll
Those are the .dll files that are in
C:\Program Files\Common FIles\System\ADO on my computer.
MSADO15.dll
MSADOMD.dll
MSADOR15.dll
MSADOX.dll
MSADRH15.dll
MSJRO.dll
Those are the .dll files that are in
C:\Program Files\Common FIles\System\ADO on my computer.
Hmm. Real odd. I tried installing it on mine and it worked right first time, so whatever quirk keeps yours from working... However, I also installed several programs that included ODBC drivers and may have installed MDAC at some point. I don't have a clue what is going wrong.
I downloaded the MDAC and tried to install it. I got a message telling me that they were already there and that MDAC couldn't update the system.
I have updated this file to contain both databases:
http://www.gammon.com.au/mushclient/plugins/calendar.zip
http://www.gammon.com.au/mushclient/plugins/calendar.zip