ODBC Drivers on windows 2008 x64

Posted on 2011-05-10
Last Modified: 2012-05-11
Hello experts,

i need some real help over here please, iam installing a certain dental software on a new Windows Server 2008 Std x64 R2 , problem is software isn't running after  a lot of research apparently windows server 2008 x64 DOESN'T contain ODBC drivers that are needed to have my software running,

NOTE: iam doing this process simultaneously on Two servers different companies, different installation Disks on windows 2008 r2

Any help or suggestions on how to get those drivers? specifically the software uses access and DBISAM drivers  
Question by:MLHijazi
    LVL 22

    Expert Comment

    by:Brian B (TBone2K)
    What kind of database is your software using (i.e sybase, SQL)? You would most likely need to get the ODBC drivers from the manufacturer of the database.

    Author Comment

    my software is based on SQL i believe but when installed on a windows x32 bit those are the following drivers the software automatically creates:

    dBASE Files
    Excel Files
    MS Access Database

    the software is network based, iam installing the server side now and itsn't working i get error 'runtime error 216" once i try to open it.
    LVL 1

    Expert Comment

    First check if your application is 32 or 64 bits...   if it's an old application, it's probably 32 bits...

    Windows 2008 x64 have different ODBC configurations for 32 and 64 bits applications.  For 32 bits, have a look at the following : %systemroot%\sysWOW64\odbcad32.exe (ODBC DataSource Administrator 32 bits).

    Author Comment

    the software isn't that old it's only been 4 5 years since it came out,, also i have it installed on my windows 7 x64 system and it's running smoothly n x64 and x32, except it's such a hassle .

    @antarex: what do you mean when you ask me to look into that directory what should i be doing exactly if you don't mind clarifying the solution you are suggesting
    LVL 23

    Expert Comment

    - it is likely that your application is using 32bit ODBC. when you setup the ODBC from Control Panel, you are actually setting up the 64bit ODBC driver, which the erason why you didn't see the ODBC driver needed by your application there
    - you need to setup the 32bit ODBC instead. as antarex have pointed, assuming your windows path is c:\windows. go to c:\windows\sysWOW64. you will see a file odbcad32.exe. click and setup the 32bit ODBC driver using this 32bit version of ODBC Admin. your driver should be listed there.
    LVL 1

    Accepted Solution

    Just start the executable i pointed you to : %systemroot%\sysWOW64\odbcad32.exe

    It's the control panel for 32 bits ODBC...  it's probably in this ODBC admin that you need to configure your ODBC DSN, and not in the ODBC link that you find in the global control panel of windows (only for 64 bits apps, and probably not for your 5 years old app).

    Author Comment

    @antarex,,,, thank you your solution was brilliant i found all the drivers there,,,, unfortunately my problem persists  i can't figure out why isn't this software working on the server, however as for the questoin i got my answer and for that iam thankful

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    779 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

    21 Experts available now in Live!

    Get 1:1 Help Now