Solved

Using delphi accessing database

Posted on 2004-09-21
3
155 Views
Last Modified: 2010-04-05
Hi everyone!

Does anyone here knows how to use ODBC with Delphi? Can anyone show me some source code examples? Im using delphi 3.0 (I guess this doen't matter with the version). In addition, does delphi also can access the ".dbf" file created by CLIPPER?

Thanks in advance
0
Comment
Question by:girlswants_me
3 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 12120105
>Does anyone here knows how to use ODBC with Delphi?
usual u can use BDE or ADO to access a database through ODBC

>In addition, does delphi also can access the ".dbf" file created by CLIPPER?
yes, but only the tables, no clipper-coding and no clipper dependend indexes

meikl ;-)


0
 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 125 total points
ID: 12122266
Delphi 3 doesn't have any default ADO support thus you need to use the BDE instead. The BDE for version 3 might not be able to handle the latest Clipper (DBase) databases correctly, though. However, you have an ODBC driver for Clipper, I assume. Therefore, you could connect from your application to the BDE, then to ODBC and finally to Clipper. The ODBC driver would have to handle all quirks.

A simple example? Drop a TDatabase component on your form. In Delphi 3 you can then double-click on it, I guess, to open a dialog to set up the database connection. You will have to set up the BDE correctly and also have ODBC correctly set up. It's not easy, though. And way too long ago for me to remember how it worked, exactly. Am using ADO for several years now, whenever I need database access.
0
 

Author Comment

by:girlswants_me
ID: 12176856
Thanks a lot
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi Mdi application Child forms get behind control 7 213
find a node in VST 2 68
Delphi: ForceDirectory plain function 7 32
DBGrid or StringGrid ? 6 89
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question