PureBasic Forums - English

Does PureBasic have any sort of multi-user database built into it? Or do I have to use something like MySQL? I would like to offer a single .EXE file which can manipulate a database with other users on the network, without the user having to also install MySQL, if possible.

Thanks,
Phil Thien

Pure uses any ODBC database.
Just go to control panel -> ODBC Admin and create a link to a database supported, then use the PB data base commands to work with it

But then I need to have a user install another product which provides ODBC access, like MS Access, right? Is there any way to supply a single EXE which will do it all?

Thanks,
Phil

You can write in PB a connection, without the need to set ODBC via the control panel.

check: viewtopic.php?t=1835

pthien,

ODBC drivers for standard databases like MS Access and DBase are provided with windows.

You don't have to pay for them, and in the vast majority of cases they will have been installed by default.

Phil,

If you know SQL, you can use the free SQLite DLL (http://www.hwaci.com/sw/sqlite/) and the PureBasic SQLite library (http://www.reelmediaproductions.com/pb/ - click on "ASM Library" under "Code Archive").

I use this method and "IncludeBinary" the SQLite DLL into the PureBasic EXE file. Voilá - a complete SQL database application in one file!

Regards,
Eric

You can create and use Access databases on the fly - I did it in a little app I wrote when I first purchased PB. I'll gather the info up and post it soon..