Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
📖 Home Back
A ClearSCADA DSN does not appear on the "Create New Connection" dialog box on 64-bit OS within the Crystal Reports editing envrionment.
Create a 32-bit DSN using the correct tool.
The ODBC Data Source Administrator that can be accessed from the "Administative Tools" section of the Windows Control Panel creates a 64-bit DSN by default on 64-bit Operational Systems. Since Crystal Reports is a 32-bit application, it needs a 32-bit DSN to connect to ClearSCADA. It can be done using the correct application:
The 32-bit version of odbcad32.exe is located on %windir%\SysWOW64\
The 64-bit version of odbcad32.exe is located on %windir%\system32\
DSNs created by each tool are stored in different places in the registry.
In ClearSCADA 2010 R2 and earlier, a simple way to run the 32-bit ODBC Data Source Administrator is to click the "Setup" button that appears next to the definition of the Crystal Reports Data Source DSN in the Server Configuration Tool. See Global Parameters - Crystal Reports.
Crystal Reports.pngCrystal Reports.png
In ClearSCADA 2010 R3 and later this won't work as the "Setup" button will launch the 64-bit ODBC Data Source Administrator as the Crystal Reports driver is now a 64-bit application and therefore requires a 64-bit DSN.
As stated above, the 32-bit ODBC Data Source Administrator may be accessed by navigating to the SysWOW64 folder as shown in the screen shot below:
1.png1.png
Go: Home Back
Problem
A ClearSCADA DSN does not appear on the "Create New Connection" dialog box on 64-bit OS within the Crystal Reports editing envrionment.
Solution
Create a 32-bit DSN using the correct tool.
The ODBC Data Source Administrator that can be accessed from the "Administative Tools" section of the Windows Control Panel creates a 64-bit DSN by default on 64-bit Operational Systems. Since Crystal Reports is a 32-bit application, it needs a 32-bit DSN to connect to ClearSCADA. It can be done using the correct application:
The 32-bit version of odbcad32.exe is located on %windir%\SysWOW64\
The 64-bit version of odbcad32.exe is located on %windir%\system32\
DSNs created by each tool are stored in different places in the registry.
In ClearSCADA 2010 R2 and earlier, a simple way to run the 32-bit ODBC Data Source Administrator is to click the "Setup" button that appears next to the definition of the Crystal Reports Data Source DSN in the Server Configuration Tool. See Global Parameters - Crystal Reports.
Crystal Reports.pngCrystal Reports.png
In ClearSCADA 2010 R3 and later this won't work as the "Setup" button will launch the 64-bit ODBC Data Source Administrator as the Crystal Reports driver is now a 64-bit application and therefore requires a 64-bit DSN.
As stated above, the 32-bit ODBC Data Source Administrator may be accessed by navigating to the SysWOW64 folder as shown in the screen shot below:
1.png1.png
Go: Home Back
Author
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.