ExDatabase Library OpenSource

Post by **Rings** » Fri Mar 04, 2005 12:02 pm

Well, here it is.
An Addon Library for the Database Lib, designed for Windows.
Most of the ExDatabase library are released as source before(thx to ABBKlaus and myself;) ), so i have bundled and rewritten the sources to a fine small Library for easy use.
The License of the Library is OpenSource so that if any problems with new versions encounter, you can recompile the lib yourself.

Big thx goes to fanglez who wrote a nice example and even more a nice helpfile.

have fun, S.Rings

Download here
Updated

gnozal · Post by **gnozal** » Fri Mar 04, 2005 12:13 pm

Thanks !
All examples are for Access .mdb files. Is it possible to use this library to access directly to an Oracle database on a distant server (I do it through ODBC, but I have to setup the ODBC connection with the archaic ODBC control panel before)?

Post by **Fred** » Fri Mar 04, 2005 12:27 pm

Looks good

NoahPhense · Post by **NoahPhense** » Fri Mar 04, 2005 12:33 pm

Nifty.. I'll get a chance to play with it tonight..

DoubleDutch · Post by **DoubleDutch** » Fri Mar 04, 2005 2:28 pm

If you use the

CreateEmptyMDB("test.mdb")

command it will add about 60k to your program, is the included file not better packed then unpacked if needed using the unpack commands?

Otherwise, great new lib!

-Anthony

Post by **Rings** » Fri Mar 04, 2005 4:14 pm

DoubleDutch wrote:If you use the
CreateEmptyMDB("test.mdb")
command it will add about 60k to your program, is the included file not better packed then unpacked if needed using the unpack commands?

Otherwise, great new lib!

-Anthony

yes, i had think about that.

ABBKlaus · Post by **ABBKlaus** » Fri Mar 04, 2005 4:31 pm

i hope fred doesn´t change the way he stores the DB Handle

blueb · Post by **blueb** » Sat Mar 05, 2005 4:15 pm

I hope that (if Rings and ABBKlaus agree) Fred will include these functions in the next version. They add a lot of usability to PB's database functions., especially the ones that return tablenames.

Thanks fellas.

Best Regrards,
--blueb

Post by **Rings** » Sat Mar 05, 2005 8:02 pm

ABBKlaus wrote:i hope fred doesn´t change the way he stores the DB Handle

not a big deal, we can use directly complete the Api .

Blueb wrote:I hope that (if Rings and ABBKlaus agree) Fred will include these functions in the next version. They add a lot of usability to PB's database functions., especially the ones that return tablenames.

the problem seems the portability for linux/MacOs .

blueb · Post by **blueb** » Sat Mar 05, 2005 8:54 pm

Thanks Rings,

I forgot about the other systems.

I did make a sample program that uses your ExDatabase lib. Since it was made with the PBDev Visual Developer, I placed it on their web page at: http://www.hellobasic.com/cgi-bin/forum ... 66;start=0

If you have the demo (or full) version of PBDev... simply grab the code, save to your clipboard, open PBDev and paste it directly into a new project.

Thanks again,
--blueb

DLM · Post by **DLM** » Fri Apr 01, 2005 6:30 pm

I just registered PB and have only been looking at it for a couple of days, so please forgive my ignorance.

I just downloaded ExDatabase and looked at the code. I am curious, why does everyone seem to connect to a *.mdb through a DSN? Since PB can utilize the API why not use a DSNless connection? Also, the code seems to use use the empty.mdb to create a new database!? New *.mdb databases can be created with SQLConfigDataSource, so why not use that?

I don't mean to sound critical, I'm just curious.

Num3 · Post by **Num3** » Fri Apr 01, 2005 8:08 pm

That's because PB does not connect directly to the database, instead it connects to an ODBC layer (which is a standard convention to make calls to databases), and it's the ODBC layer that connects to the database.

In windows you must create a DNS that points to the desired database with a specific driver (access, sql, csv, etc...)

This happens for you to have databases also in Linux and MacOs...

I just whish Fred added sqlite has an internal database format, but kept the existing commands also, just in case it's needed for other projects...

Come to think of it... Most other connections are made directly, via DLL or TCP... oh well :roll:

If you're looking for a quick database for small / medium projects i sugest the use of the sqlite, which works under for windows and linux... (i've already seen a port for Mac somewere..)

Post by **Rings** » Sat Apr 02, 2005 10:44 am

DLM wrote:I just registered PB and have only been looking at it for a couple of days, so please forgive my ignorance.

I just downloaded ExDatabase and looked at the code. I am curious, why does everyone seem to connect to a *.mdb through a DSN? Since PB can utilize the API why not use a DSNless connection? Also, the code seems to use use the empty.mdb to create a new database!? New *.mdb databases can be created with SQLConfigDataSource, so why not use that?

I don't mean to sound critical, I'm just curious.

i have been experiemented with directyl create a empty mdb file via
odbc, but the generated files are not compatible to the one you
can create with access directly. VB mentioned that the files are corrupted . Seems like a bug in the odbc-layer for access.
So this version i included works 100%(and i do not care about the xtra stuff in it ).

DLM · Post by **DLM** » Mon Apr 04, 2005 3:17 pm

You can create any Access version you need with SQLConfigDataSource and the correct version keyword.

CREATE_DB creates a version to match the MDAC components installed on the computer. This does not always match the version of Access being used.
CREATE_DBV2 for Access 2.0
CREATE_DBV3 for Access 95 and 97
CREATE_DBV4 for Access 2000

More info at
http://support.microsoft.com/kb/126606/EN-US/

Post by **Rings** » Mon Apr 04, 2005 4:08 pm

DLM wrote:You can create any Access version you need with SQLConfigDataSource and the correct version keyword.

CREATE_DB creates a version to match the MDAC components installed on the computer. This does not always match the version of Access being used.
CREATE_DBV2 for Access 2.0
CREATE_DBV3 for Access 95 and 97
CREATE_DBV4 for Access 2000

More info at
http://support.microsoft.com/kb/126606/EN-US/

many thanks, that solved a lot now

'CREATE_DB' alone makes the corrupt mdb !
i will update the lib soon and elimate the big
include file now.