Creating an ODBC connection

From NewHaven Software Wiki

(Difference between revisions)
Jump to: navigation, search
(Created page with '=Overview= CMS connects to its database via an [http://en.wikipedia.org/wiki/ODBC ODBC] connection. CMS creates the necessary ODBC definitions in Windows on the fly when you laun…')
Line 18: Line 18:
Before creating an ODBC connection you will need to make sure you open the 32 bit ODBC manager (It does not matter if you are on a 64 bit system you will still need to use the 32 bit manager). To do this follow the instructions in the link below:  
Before creating an ODBC connection you will need to make sure you open the 32 bit ODBC manager (It does not matter if you are on a 64 bit system you will still need to use the 32 bit manager). To do this follow the instructions in the link below:  
-
http://wiki.brodieware/wiki/index.php/64-bit_vs._32-bit_ODBC_Drivers
+
http://wiki.newhavensoftware.com/index.php/64-bit_vs._32-bit_ODBC_Drivers
=Creating the ODBC connection=
=Creating the ODBC connection=

Revision as of 20:49, 6 April 2012

Contents

Overview

CMS connects to its database via an ODBC connection. CMS creates the necessary ODBC definitions in Windows on the fly when you launch CMS. It uses information from the file CMSdb.ini in your NewHaven Software plus a number of other default settings to do this.

ODBC is also the connection method that would be used by any other application you may wish to connect to your database. Examples might include UPS Worldship, FedEx Ship Manager, Microsoft Access, Crystal Reports, Bartender (bar code printing), or one of many other applications that need access to your CMS data.

This article details the instructions for hand-creating an ODBC connection to your CMS Database.

Prepare to create your ODBC connection

  1. These instructions only pertain to creating an ODBC connection for Sybase 12. These connections only work with CMS version 8 and above.
  1. You will need the Sybase 12 ODBC driver installed on your system. If you do not have this driver you can install it by running a CMS Workstation install. To do this review the instructions in the link below:

http://wiki.brodieware/wiki/index.php/Workstation_Install

Open the correct ODBC Manager

Before creating an ODBC connection you will need to make sure you open the 32 bit ODBC manager (It does not matter if you are on a 64 bit system you will still need to use the 32 bit manager). To do this follow the instructions in the link below:

http://wiki.newhavensoftware.com/index.php/64-bit_vs._32-bit_ODBC_Drivers

Creating the ODBC connection

image:ODBC1.png

image:ODBC2.png

image:ODBC3.png

image:ODBC4.png

image:ODBC5.png

image:ODBC6.png

image:ODBC7.png

image:ODBC8.png

image:ODBC9.png


After following these instructions you now haven an active ODBC connection to your CMS database

Personal tools