Search found 10 matches

by petlin
Sun Jun 17, 2007 1:31 am
Forum: Tricks 'n' Tips
Topic: Finally, an ADO connection
Replies: 10
Views: 5622

Example by Kiffi

Hi Kiffi,
I didn't mean to offend. I tried using the code as you had it for the Northwind DB and it didn't quite work, so I had to modify it. Anyway, you definitely get the credit for the basic approach. I'm just glad someone figured out a way to incorporate ADO into PB. I fought with this for 3 ...
by petlin
Sat Jun 16, 2007 3:27 am
Forum: Tricks 'n' Tips
Topic: Finally, an ADO connection
Replies: 10
Views: 5622

constants

Hi Netmaestro,
Those constants you provided come with the Disphelper that one needs to download. but thanks for thinking about it.
by petlin
Sat Jun 16, 2007 1:34 am
Forum: Tricks 'n' Tips
Topic: Finally, an ADO connection
Replies: 10
Views: 5622

Finally, an ADO connection

Hi Guys,
Let me pass along some code that now allows me to connect to any data strore (using ADO - ActiveX Data Objects). With help from you folks I discovered PureDishelper v.1.5. After modifying the example and installing their library I was abl to connect to Northwind.mdb (and Access database ...
by petlin
Sun Jun 10, 2007 10:21 pm
Forum: Coding Questions
Topic: Still fighting with MDB_Lib
Replies: 5
Views: 1264

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 ...
by petlin
Sun Jun 10, 2007 3:13 pm
Forum: Coding Questions
Topic: Still fighting with MDB_Lib
Replies: 5
Views: 1264

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 ...
by petlin
Sun Jun 10, 2007 3:05 am
Forum: Coding Questions
Topic: Still fighting with MDB_Lib
Replies: 5
Views: 1264

Still fighting with MDB_Lib

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 ...
by petlin
Thu Jun 07, 2007 1:26 am
Forum: Coding Questions
Topic: MDB_Lib??
Replies: 3
Views: 903

MDB_Lib??

Hi folks,
Everybody is raving about Paul's MDB_Lib and I too would like to use it but it ain't working. I unzipped it, copied the mdb_Lib into the folder
C:\Program Files\PureBasic\PureLibraries\UserLibraries. I restarted PB but can't open the lib to see the list of functions (using openlibrary and ...
by petlin
Sun Jun 03, 2007 1:11 am
Forum: Coding Questions
Topic: Access database connection
Replies: 2
Views: 734

Access database connection

Hi folks,
Could some of you help out this newbie to PB? I'm trying to connect to an Access database using:

#db
OpenDatabase(#db, "C:\sampledb\Northwind.mdb",,)

This gets me an syntax error message.
The answer to this and any other helpful thoughts would be appreciated.
Thanx, Pete
by petlin
Tue May 08, 2007 3:42 am
Forum: General Discussion
Topic: good books?
Replies: 5
Views: 1596

good books?

Hi folks,
I'm an experienced Access programmer but new to PB. Any suggestions as to a book or 2 that I can get that will lessen my learning curve?
by petlin
Thu Apr 19, 2007 2:22 am
Forum: Feature Requests and Wishlists
Topic: ADO ?
Replies: 0
Views: 1009

ADO ?

Hi folks,

Access programmers use ADO (ActiveX Data Objects) to connect and communicate with Access and SQL databases efficiently. Is this (or can this be) incorporated into PB? If so, How??