Getting databases to talk to one another...

Posted on 2004-11-24
Last Modified: 2012-08-13
I have recently proposed to a local dentist my building for him an automatic appointment confirmation application. He's wanting to know if there's any way that I can somehow incorporate his current database into what I'm building for him.

I'm using a SQL database and he's using an application called Dentrix (

How can I get these two beasts to talk to one another?

Any suggestions?
Question by:brucegust
    LVL 4

    Expert Comment

    I would either research it at the dentist's office or call Dentrix to find out what type of database the software uses.  Unless someone here has a good understanding of the in's and out's of Dentrix, I don't think you will be able to get much help on how to link to it until you can tell us what db it uses.

    LVL 2

    Expert Comment

    If Dentrix is an OLE or ODBC compliant database you should be able to connect to it.  You do need to call Dentrix to find out what kind of driver you need to connect.  Once you set up the connection, they can talk all day long.
    LVL 16

    Accepted Solution

    odds are they use a standard database format, they just don't tell you that so you don't do what you are trying to do.  If you have access to the machine, look for "database like" files, e.g. anything ending in .dbc, .mdb, .dat.  Also looks to see what services are running.  Often a database that requires a server, like MSDE runtime, will be apparent from the services that are running.
    LVL 16

    Expert Comment

    sorry, I meant .dbf, not .dbc.  Oddly enough, .dbf is still popular.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    scoresIncreasing challenge 10 48
    wordsWithoutList  challenge 24 61
    Specific format 21 109
    array11 challenge 16 40
    A short article about a problem I had getting the GPS LocationListener working.
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now