- RS232 - CPS Plus Pro Serial DAQ
- Overview
- Installation, System Requirements, and Uninstallation
- Quick Start Guide
- Using CPS Plus Pro - Serial Data Acquisition Software
- Data Filtering
- Data logging options
- Writing data to RS232 COM ports / controlling devices
- Tools: ASCII Table - Standard and Extended ASCII Table
- Troubleshooting
- Program Options
- Downloads, Ordering, and Support
- Using CPS Plus with Serial Converters
- License
Using Existing DSN connection
Using this option means that you have already created an ODBC DSN in the Windows ‘ODBC Data Source Administrator’.
If you have NOT created a DSN, you can do that using the ODBC Data Source Administrator.
- Under Windows XP, go to the Control Panel, select Administrative Tools, and click on Data Sources (ODBC).
- Vista: Search ODBC from Start Menu
- Windows7: search ODBC from Start Menu
If you are using other Windows platforms, you can usually find this item in the Control Panel.
There are a few step-by-step examples given in a topic named ODBC Connection Examples.
IMPORTANT NOTE: if you are on a 64-bit machine, __do not__ use the ODBC Window that is accessible from the control panel. Instead, go to START > RUN > C:\Windows\SysWOW64\odbcad32.exe.
Once you have created DSN in ODBC Data Source Administrator, activate CPS Plus ODBC Connection Wizard, select “Use Existing DSN” and from the drop down list, select DSN you created earlier and click on Next button.
Image: CPS Plus ODBC Connection Wizard
Click Next >>
If needed, enter username/password into UID/PWD fields and click Test Connection.
If the connection is successful, an info box from the image below will pop up. If not, you will get an error message with a detailed description of the error.
Click Next >>
At next step, you should enter table name and the name of the columns in which the data will be inserted. The way CPS will separate the data and in which columns data will be placed, is defined by data field separator value.
Enter the table name into 'TABLE_NAME' field and enter the column names into 'FIELD NAMES' field.
CPS DATA FIELD SEPARATOR field defines how CPS will split the data. In example shown in picture above we have used pound key (#) as a Data Field Separator, and first second and fifth part of separated string (FIELD1,FIELD2,FIELD3).
Placeholder variable FIELD0 holds complete read string. CPS will write value into this variable even if CPS FIELD SEPARATOR is not set.
In example in picture above we have entered table name (BARCODES) and columns' names (COMDATA and COMPORT).You can also change the SQL statement directly in SQL text box.
After you are done, click Next >>
CPS Plus will offer you to check if table you have entered exists.
Acknowledge connection details and click on Finish to activate connection.
CPS Plus will activate connection and during first data read it will construct SQL insertion statement, which will be executed on the defined database.
Note: CPS Plus will save username/password, required to connect to database, in its internal properties file. This file may be fairly easily read so it is recommended that user using this ODBC connection, have limited privileges! For example, only write privilege for table used in this connection.