WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
How do I create a 32-bit ODBC DSN on a 64-bit operating system?
Article Details

Last Updated
30th of August, 2012

When using Custom Web Reporter (CWR), QualTrend, or WinSPC's ODBC device, you may need to create an ODBC DSN on a computer in order to tell the application how to connect to an external database.  While CWR, QualTrend, and WinSPC all function properly on a 64-bit operating system, they will require a 32-bit ODBC DSNs for some of the functionality that utilizes ODBC DSNs (as all three applications are 32-bit applications).

By default, a 64-bit operating system (such as Windows 7 64-bit) only allows a user to create 64-bit DSNs.  The exact steps to create a DSN vary slightly by operating system, but in Windows 7, DSNs are accessed from the "Data Sources (ODBC)" shortcut in the "Administrative Tools" of the Windows Control Panel. 

To create 32-bit ODBC DSNs on a 64-bit system, you will need to locate and run the 32-bit version of the "ODBC Data Source Administrator" application (provided by default in Windows).  This application can be found here (assuming a default installation of Windows):
C:\Windows\SysWOW64\odbcad32.exe

You may want to create a shortcut to this application in the Control Panel (and name it, for example "Data Sources (ODBC) (32-bit)").

Attachments
No attachments were found.
Related Articles
Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "How do I create a 32-bit ODBC DSN on a 64-bit operating system?"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 

All Content ©2010-2021 DataNet Quality Systems. All Rights Reserved.