SQL Related Articles: 10 steps to implement Firebird in your application 2004-04-01 -- Pratik Patel Newsgroups: softvelocity.clarion.databasedrivers
assumptions:
1. FB server is installed (but not running)
2. FB ODBC driver installed
3. you have created a FDB
4. you have created a ODBC DSN
5. you have a clarion app & dct pointing to this FDB
Steps to embed FB...
1. REMOVE your ODBC DSN
2. download & unzip
http://prdownloads.sourceforge.net/firebird/Firebird-1.5.0.4290_embed_win32.zip?download
to a TEMPORARY folder
3. COPY fbembed.dll into your application folder and RENAME to fbClient.dll
4. COPY following files to your application folder...
ib_util.dll
firebird.conf
firebird.msg
5. open up your DCT and change the Owner for every table to !glo:Owner
6. open up your APP and add a global field glo:Owner string(254)
7. import the attached dbConnect.txa
8. edit dbConnect() and makes changes as need (dbName=, UID=, PWD=)
9. execute dbConnect() procedure ANYWHERE in your Main() BEFORE opening
files
10. compile and run
You can download the dbConnect.txa from http://www.icetips.com/ftp/clarion/dbconnect.zip
regards,
-pratik
Printed May 5, 2024, 1:57 pm This article has been viewed/printed 35118 times. Google search has resulted in 109 hits on this article since January 25, 2004. |