Still fighting with MDB_Lib

petlin · Post by **petlin** » Sun Jun 10, 2007 3:05 am

Hi guys,
For the life of me, PB is still not recognizing MDB_Lib. Everyone says just install the lib into UserLibrarys (I assume they mean just copy it into the directory, right?). When I try: hMDB=MDB_Connect("C:\PureBasic\Projects\TestSamples\Northwind.mdb", "Northwind.mdb","",""), the error message says "The following PureLibrary is missing:Library Extension".
Appreciate all your help, guys (and gals).

netmaestro · Post by **netmaestro** » Sun Jun 10, 2007 3:44 am

Get rid of whatever you installed. Then, go to reelmedia.com and download the mdb library for PB 4. There are two, one is for 3.94 and the one you want is in the group that is released for 4.0. This may not work for the 4.10 beta, so if you want to use this lib for now you might have to stick with 4.02. He'll probably release one for 4.10 if he hasn't done so already, but probably not yet. Put the file in \PureBasic\Libraries\Userlibraries and restart the compiler, it should work without problems.

Common library problems:

Unrecognized Command: - you probably put the lib in the wrong folder or forgot to restart the compiler

Missing Library Extension: - you are probably using a library for the wrong version of PureBasic

petlin · Post by **petlin** » Sun Jun 10, 2007 3:13 pm

Thanx Maestro,
I think I found out the real problem. Yes, I did have the wrong version as you suggested but, on closer inspection in the use of Paul's functions it called for a the use of a DSN.
While DSN's are used often, they are not standard fair in a serious business application (client/server or 3-tier environment - too much of a chance of it getting erased by the admin or someone else).
Can someone point me to some database functions that don't depend on DSN's?
Thanx again

Pantcho!! · Post by **Pantcho!!** » Sun Jun 10, 2007 5:48 pm

What do you mean get erased?
You can also password protect it if you wish.

I got a database of 300MB running fine with no problems what so ever
with over 60,000 events (rows)

I don't understand what might be the problem here using this connection.

petlin · Post by **petlin** » Sun Jun 10, 2007 10:21 pm

Hi Pantcho,
I'm sure a DSN works well, but I don't see them used in serious business environments. I'm sure many out there will be willing to argue this point, but with the advent of ADO (ActiveX Data Objects) DSN's (and for that matter ODBC) is just outdated connection methodology.

Now if I can just find a way to incorporate ADO (rolled up in the MDAC - Microsoft Data Access Components) we could make PB sing and dance with all data stores (Oracle, SQLServer, etc.)

Thanx for your input

netmaestro · Post by **netmaestro** » Sun Jun 10, 2007 10:34 pm

For ADO, you can give this a try:

http://www.purebasic.fr/english/viewtopic.php?t=26744

Some examples added:
ado, flash, ie, mediaplayer, msxml, network, sapi, vbs and word