Opto 22

43044 Business Park Drive, Temecula, CA 92590 USA
Local & outside the USA:(951) 695-3000
Toll-Free within the USA:(800) 321-6786
Fax: (951) 695-3095
Email: sales@opto22.com
 
KB83183
OptoDataLink doesn't work with DSN (Data Source Name)
Revision:  2.0
Published:  4/24/2015
Applies To
OptoDataLink
Versions
Versions affected:  
Versions R9.4d and earlier
Problem is fixed in version:  
R9.5a

SYMPTOMS

DSN names may not appear in list even if they are configured. Selecting a DSN still not work in ODL Runtime.

RESOLUTION

Opto 22 has resolved this issue.

Additional Information:

Once you have upgraded to OptoDataLink R9.4e, follow these guidelines:

  • Make sure to add a DSN to the SYSTEM tab in the ODBC Data Sources dialog.
  • The DSN must be for a 32-bit ODBC connector.
  • The DSN name can now be anything, but it must contain the database type. For example, a MySQL DSN can be called "MySQL System DSN", or a SQL Server DSN can be called "My SQL Server System DSN". Both are fine as long as the database type (MySQL, SQL Server) are in the names.
  • OptoDataLink Configurator will ignore the "product type" when selecting the DSN radio button. For example, if using a MySQL DSN, it doesn't matter if the product dropdown says "MySQL 3.51" or "MySQL 5.1". All that matters is that the DSN is set up correctly.
  • When using the DSN, no username or password needs to be entered in OptoDataLink Configurator.

Relevant Downloads
No relevant downloads have been specified.
Questions? Contact Opto 22 Product Support.
Phone: 800-835-6786 or 951-695-3080
Email: support@opto22.com

DISCLAIMER

This Opto 22 Knowledge Base ('OptoKB') article is intended to provide general technical information on a particular subject or subjects and is not an exhaustive treatment of such subjects. Accordingly, the information in this OptoKB article is not intended to constitute application, design, software, or other professional engineering advice or services. Opto 22 may modify the OptoKB articles at any time. Before making any decision or taking any action which might affect your equipment, you should consult a qualified professional.

OPTO 22 DOES NOT WARRANT THE COMPLETENESS, TIMELINESS, OR ACCURACY OF THE DATA CONTAINED IN THIS OPTOKB ARTICLE AND MAY MAKE CHANGES THERETO AT ANY TIME AT ITS SOLE DISCRETION WITHOUT NOTICE. FURTHER, ALL INFORMATION CONVEYED HEREBY IS PROVIDED TO USERS 'AS IS.' IN NO EVENT SHALL OPTO 22 BE LIABLE FOR ANY DAMAGES OF ANY KIND INCLUDING DIRECT, INDIRECT INCIDENTAL, CONSEQUENTIAL, LOSS PROFIT, OR DAMAGE, EVEN IF OPTO 22 HAS BEEN ADVISED ON THE POSSIBILITY OF SUCH DAMAGES.

OPTO 22 DISCLAIMS ALL WARRANTIES WHETHER EXPRESSED OR IMPLIED WITH RESPECT TO THE INFORMATION (INCLUDING HARDWARE, SOFTWARE, AND/OR FIRMWARE) PROVIDED HEREBY, INCLUDING THE IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTIBILITY, AND NON-INFRINGEMENT. Note that certain jurisdictions do not sanction the exclusion of implied warranties: thus, this disclaimer may not apply to you.

Copyright © 2017 Opto 22. All rights reserved.

My.Opto22

All Opto22

Request Information
  • FREE Product Brochure
  • Product Demonstration
  • PreSales Engineering Assistance

Opto 22 Product Support

Opto 22 Product Support is FREE Monday through Friday 7 a.m. to 5 p.m. Pacific Time

Product Support Numbers:

Local: (951) 695-3080
Toll-Free: (800) 835-6786
Fax: (951) 695-3017
support@opto22.com

Products

None

Downloads

None

Documents

None