spacerspacer
Free help: USER GUIDE
Home > Support > FAQ/Tech Index > Connecting to C&P using a Windows 64-bit OS
 Search:   


Connecting to C&P via ODBC using a Windows 64-bit OS



Applies to:

[x] C&P Classic
[x] C&P Pro X
[x] Job Tracker
[x] My C&P!



SUMMARY: If you're connecting to C&P using a 64-bit Windows OS, this tech note will help you set up your DSN connection using the 32-bit ODBC drivers provided in your Windows Operating System. Applies to users of Microsoft SQL Server or SQL Server Express.



THE CLIENTS & PROFITS HELPDESK DOES NOT PROVIDE SUPPORT FOR SERVER SETUP. Installing and configuring your server hardware and operating system can be technical, so you should have access to a computer expert or database administrator who is familiar with networking and server operating systems.


Clients & Profits is a 32-bit application. Because of this, it cannot fuction properly when using 64-bit drivers, which are used by default by 64-bit operating systems. To get around this issue, when you are connecting to a Clients & Profits database via ODBC on a 64-bit OS such as Vista x64, Windows 7 x64, Windows 2008 Server x64 or Windows Server 2003 x64, you must setup your DSN connection using the 32-bit ODBC drivers provided in your Windows Operating System.

By default windows will use the 64-bit odbc drivers, which can be found here:
Control Panel > System and Security > Administrative Tools



Double-clicking on the Data Sources (ODBC) panel will display the 64-bit ODBC drivers information.



You will need to use 32-bit odbc drivers, which can be found here:
C:\Windows\SysWOW64\odbcad32



You can see the difference by looking at the drivers table of the odbc manager.



In the 64-bit version of your Windows OS, you will only see the SQLServer driver. In the 32-bit version you will see a full list of odbc drivers.



For subscribers: VIDEOS } FAQs/TECH NOTES } LEARN
     Sign up for Clients & Profits news:
     © Clients & Profits, Inc. w e  l o v e  a d v e r t i s i n g