Is there a database built-in?

pthien · Post by **pthien** » Sun Jun 29, 2003 9:45 pm

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

Num3 · Post by **Num3** » Sun Jun 29, 2003 10:01 pm

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

pthien · Post by **pthien** » Sun Jun 29, 2003 10:09 pm

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

Num3 · Post by **Num3** » Sun Jun 29, 2003 10:22 pm

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

check: viewtopic.php?t=1835

GedB · Post by **GedB** » Mon Jun 30, 2003 10:25 am

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.

ebs · Post by **ebs** » Mon Jun 30, 2003 3:25 pm

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

Karbon · Post by **Karbon** » Tue Jul 01, 2003 6:25 pm

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..