IonicWind Software

Aurora Compiler => Database => Topic started by: Doc on June 14, 2006, 10:10:23 AM

Title: question about mdb files
Post by: Doc on June 14, 2006, 10:10:23 AM
I'm really not at all familiar with the capabilities of Microsoft's .mdb format I'm wondering whether or not you can store "blobs" (binary data, images, etc.) with it? If so, is there any sample code floating around?

Also, since Aurora will eventually be cross-platform, will the same format be used on the Linux side or will we have access to something more generic like SQLite? Maybe more important, has anyone yet tried using SQLite with Aurora? 

Geeshz, I'm sure full of questions (or something) this morning.  ;) ;D

Thanks,

-Doc-
Title: Re: question about mdb files
Post by: Rock Ridge Farm (Larry) on June 14, 2006, 10:58:43 AM
Aurora uses the ODBC interface - any database that works with that should work.
I got it to work with .mdb - am now playing with Progress interface.
Title: Re: question about mdb files
Post by: Doc on June 14, 2006, 12:09:58 PM
Hi Larry,

QuoteAurora uses the ODBC interface - any database that works with that should work.
Yepper, I'm aware of that. (thanks!)

Unfortunately when going that route, there must always be an assumption that the end user has the correct ODBC driver installed for any given DB. In itself that's not generally much of a problem if the user is running XP, but it can be in the case where they use an earlier version of windows. If the end user does not have the correct drivers installed or (looking ahead) is running Linux, it could be a big pain in the wazoo.

SQLite on the other hand, is absolutely free for any use and available for almost every platform on the planet. Even more important (from my viewpoint), the resulting DB file can also be used to run server based apps without any changes.

Who knows, maybe someday I'll become smart enough to do the interface to Aurora. :)

-Doc-
Title: Re: question about mdb files
Post by: Rock Ridge Farm (Larry) on June 14, 2006, 01:43:54 PM
I think Paul built a generic interface. Not sure what triggers the specific ODBC interface but it seems to work
so far. :)
Title: Re: question about mdb files
Post by: Rock Ridge Farm (Larry) on June 14, 2006, 01:47:11 PM
Check the 'How to connect to a database' thread. It has some connect specific data.
Title: Re: question about mdb files
Post by: Ionic Wind Support Team on June 14, 2006, 03:07:01 PM
Any system that has IE installed will have the .mdb drivers.  Or any version of Office of course.