Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link 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
Today is May 5, 2024, 10:36 am This article has been viewed 35118 times. Google search has resulted in 109 hits on this article since January 25, 2004.
|
|