Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: ODBC Configuration

30 May 2012   #1

Windows 7
ODBC Configuration

Background: We run this program at work called "Surgisource", it is a medical billing program of sorts. Most of our computers here run Windows XP 32bit and the software runs without fail. We have aproximately 10 Windows 7 machines of which only a few are running Surgisource. Of these few only 2 are x64. Of these 2, Surgisource runs perfectly fine on one, and has issues on the other. Since in all likelihood no one will understand the nature of the software discussed here I will speak in generalities; one user is trying to generate reports and gets a "534" error on 2 of these specific reports when she adjusts the date renge beyond one month. I called Surgisource and they don't support x64 (the software is x32) but they seemed absolutely certain that the error had to do with the ODBC configuration. I am fully aware that there is a 32bit ODBC config utility which is what I used.

Now for my question: Does the ODBC config "embed" itself somewhere on Windows 7 outside of the actual config utility? Like somewhere in the registry, or in an .ini file?

At this point I suspect the problem has something to do with the ODBC config not correcting itself (upon being altered via the utility) at the location/file where the actual ODBC info is written. Here is my evidence:

In order for this software to work you have to have the ODBC configured because the data source is located on a server and by default the software does not know where this is. It is critical and the program simply will not run without this configuration. This brings us to Windows 7 x64.

I did the initial ODBC configuration through the x32 config utility located in System32 and the program ran like it was supposed to. As I looked further there was one option that I didn't set correctly; Use ANSI nulls, paddings and warnings must be unchecked for the program to work completely. You will be able to log in otherwise, and access most of the program, but the errors reported by this user are indicative of this option not being unchecked.

My Windows XP x32 had the same problem and when I unchecked the Use ANSI nulls, paddings and warnings, the prgram begun to function completely and there were no more issues. However, when I did the same for the W7 x64 machine, it still had the same issues. After much thought, I went ahead and deleted the entire ODBC entry and the program still ran! This tells me that the software is looking somewhere else for the ODBC settings, possibly the initial settings, and anything done thereafter was not accounted for and thus the software continued to malfunction.

Does this make any sense? Again, this program can not run without the ODBC configured so if I delete the entry it should fail at the point of logging in.

Other notes:
I made the changes with admin rights.
Tried running software in compatibility mode.
Tried running program as admin.
I did a reinstall of the surgisource program.

Any Windows 7 x64 ODBC experts able to shed some light on this? Thanks!

My System SpecsSystem Spec
30 May 2012   #2


Man, I loathe wrestling with ODBC sources (hello IBM DB2). You say one of the x64 machines runs fine, while the problem is only present on the other one?

You could root arount the registry and compare their settings to see if there's any difference. Apply standard registry editing precautions here (make backups, don't touch anything you don't understand, etc).

Main system DSN info should be in HKLM\Software\Wow6432Node\ODBC\ODBC.INI
ODBC driver info should be in HKLM\Software\Wow6432Node\ODBC\ODBCINST.INI
Some 32-bit driver info may be in HKLM\Software\ODBC\ODBCINST.INI
User DSN info should be in HKCU\Software\ODBC\ODBC.INI

You could also fire up Process Monitor (a free download app now owned by Microsoft) and check the registry access records for C:\Windows\SysWOW64\odbcad32.exe (the ODBC Data Source Administrator), to find out what registry keys to search for DSN info. This is something of a last resort though, the info you need should be in the keys above.

Compare the settings in the working installation with the settings in the one where it's not working and see.
My System SpecsSystem Spec

 ODBC Configuration

Thread Tools

Similar help and support threads
Thread Forum
Uninstalling VB6.0 and ODBC-32bit.
Hello! Some time ago I installed VisualBasic 6.0 to work on a school project and after finishing It I decided to uninstall VB6.0, but I still have ODBC 32bit in Control Panel and it's not on the "Add/Remove" program list. I also uninstalled the ODBC data registry keys but to no avail. Any tips?...
ODBC Setup Problem
I have Win 7 Ultimate 64 bit. I have the following problem.. when I try to install an ODBC connection (*mdb), Data sources ODBC > SYSTEM DSN > ADD > (here only sql server is listd, not .mdb) and also I get the following fault message: "The Microsoft Access Driver (.mdb) ODBC driver could...
Microsoft Office
ODBC cannot connect to localhost
On a Win7Pro-32 system running in XP mode, I'm trying to use ODBC (v5.1.9) to connect to a MySQL db on localhost. Interestingly, when using a username with remote host privileges I am able to connect to a remote db - this tells me ODBC is installed and working properly. Yet when I try to connect...
could the odbc be used to tell windows how to surf the internet safely? to look for scripts in media/images/controls that could be malicious or cause unwanted or unintended behavior of hardware?
ODBC Setup Problem
I am sorry if this has been asked previously. I have Win 7 Ultimate 64 bit, which is an upgrade from Vista Business 64 bit. I have the following problem when trying to install an ODBC connection (*mdb). When I run odbcad32.exe, from the SysWOW64 directory, and try to install the 32 bit MS Access...
Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 22:18.
Twitter Facebook Google+