A Toy for all you Windows Utility writers...

[Imaginator]

I've began working with Melchoir on the SpawnED utility, and found an abscence in a quick and easy interface to MySQL from VB...

ODBC is clunky and slow, and other solutions I've found are quick but return native MySQL API structures. This is bad because VB grids and such heavily rely on ADODB Recordsets and such, so to populate a grid you'd need to for loop through the native MySQL structs to populate you're grid... and in VB, that sucks and is slow...

My Solution: I'm working on creating a COM interface to MySQL in VC++ that anyone should be able to call from VB and other COM enabled programming languages...

I already have the baseline of the code, and am currently adding features on an as needed basis, and squashing bugs...

So what does this mean? It means I can throw 86,000 records from the Spawn2 table into a grid in 8 seconds...

I hope to make it available to anyone who could find it useful, look here for new developments....

- Imaginator

[Kaiyodo]

That's a good idea. I was toying with the idea of wrapping the mysql api into a .NET wrapper so I could use it from c# like I've done with the EQInside API. Handily COM stuff is also accessible from .NET, so it would make me happy

K.

[bbbill_42]

thats a great idea, i had the same problem before once, ended up going with java and jdbc for the db access.