Applies To:
  • CitectSCADA 5.xx

I have installed a new copy of Citect while logged into Windows as an administrator. When I log in as a user, I cannot run the Citect Explorer and get a Citect Explorer error:

ODBC return code: -1
Error description: Data source name not found and no default driver specified

How can I fix this?


The Citect installation adds an ODBC Data Source Name (DSN) in Windows. Citect Explorer needs this DSN to access any project database files. There are two types of DSNs: System and User. User DSNs are only available to the currently logged in user, while System DSNs are available for any user on that PC.

A normal Citect installation will add a System DSN, however in some Windows configurations, a User DSN may be added and then other users cannot run Citect. This problem can also occur if the user that installed Citect was logged into a domain and then changes domain or to a workgroup.

The solution is to either re-install Citect while logged on as the current user or to edit Windows ODBC.

To edit ODBC, open the Windows Control Panel and open the ODBC applet. Under System DSN, select Add and then select Microsoft dBase Driver. In the configuration dialog box for this driver add "Citect_Dbf" as the data source name and make sure that the version is "dBase IV". Click OK to save. Close the ODBC control panel and you should now be able to run the Citect Explorer.

See also Knowledge Base Article Q3183