Zugg Software :: View topic

Apprentice Joined: 13 Aug 2007 Posts: 166

Hey all

I wonder if it's possible, and in that case how, to convert a zmud database to CMUD 3? Do I need other software or can it be done in CMUD? Maybe CMUD 3 can access and read/write data to the old databases?

//DanteX

Wizard Joined: 22 Mar 2007 Posts: 2320

A zmud database? Cmud is using the exact same database stuff that zmud did. The database software has not been updated yet. Or do you mean the mapper data? That gets converted fine.

[edited]
Oh, you probably mean converting to the new SQL database connection stuff. Right now, all that feature does is allow you to communicate with an external SQL database. It has nothing to do with the internal database, which I don't believe is actually an SQL system anyway.

Apprentice Joined: 13 Aug 2007 Posts: 166

CMUD 3 is using SQLite, but I have databases in the old Microsoft format. And when I've attempted to call the old databases in the same way as I used to, it's failed and that's why I wonder.

Posted: Fri Dec 04, 2009 5:13 pm

CMUD only uses SQLite for it's internal databases, and the mapper. If you have an external database in Microsoft ADO/MDAC format, then the same COM-based scripting should work for it as in zMUD. You should post the script that isn't working so we can try to help with it.

To convert a database from Microsoft ADO/MDAC format into SQLite format, you'll need to Google for that. Doing a general-purpose database conversion like that is beyond the scope of CMUD. But I'm sure there is some database tool that will do it somewhere.

Apprentice Joined: 13 Aug 2007 Posts: 166

In CMUD:
#VAR DB1 %comcreate( "ADODB.Recordset")
gives the following DB1 content:

<COMObject>

While the same code in zmud results in the following content:

<OLE object: ADODB.Recordset>

And when I use the same script, with string handling modifications, it will get stuck in an endless loop in CMUD. while it will display correct items in zmud. This is the alias used in CMUD:

Posted: Mon Dec 07, 2009 9:14 pm

You didn't show what the @MDBConnStr2 variable contains, but I think you need to be more careful putting " quotes around your string values. The #CALL command that you have:

#CALL @DB1.Open( SELECT ObjId FROM Mobs WHERE Name=~'@smobtof~', @MDBConnStr2)

should be this:

#CALL @DB1.Open( "SELECT ObjId FROM Mobs WHERE Name='@smobtof'", @MDBConnStr2)

The fact that CMUD shows instead of the more detailed shown in zMUD isn't a bug, it's just the way CMUD handles COM objects in a more general way than zMUD.

Finally, you don't need the ~ in front of the < charaters in the MXP command. Again, that's left over from zMUD bugs.