Creating an ODBC Data Source on Windows
You may only create a data source on a computer that has the ODBC driver for 602SQL installed. The data source is NOT automatically created when installing 602SQL.
A data source in 602SQL is connected to a specific scheme (application). If you want to access more schemes, create more data sources.
It is recommended that the 602SQL scheme names that are being accessed using the ODBC interface, and names of the accessed tables and columns do not contain non-alphanumeric or national characters. Some programs cannot work with these characters.
Data Source Types
There are three types of data sources in Windows:
- A System data source is designated with a name described in the registry and accessible for all users of the specified computer (System DSN).
- A User data source is designated with a name described in the registry and accessible only for a single user of the specified computer (User DSN).
- A File data source is designated with a name and stored in a file that is accessed by the path to this file (File DSN).
The name of the system or user data source may have a maximum of 32 characters. The ODBC specification has no further requirements, but some client programs cannot work with names that contain non-alphanumeric characters. These data sources exist and are only visible on the computer they were created.
A file data source has one major advantage, if the file is stored on a network drive, it will be accessible to all computers on the network. You do not need to create the data source separately on each computer.
Manual Creation of the Data Source from the 602SQL Client
- Select the application (schema) that should be the data source in Control Panel.
- Select Create ODBC Data Source action from the popup menu.
- Select the source type (the system type or user type) in a new dialog and enter the data source name.
Creating a Data Source from the ODBC Control Panel
- Run the ODBC (or ODBC Data Source) shortcut from the Windows control panel
- Select the tab for System, User or File data sources and press the Add button.
- Choose the 602SQL x.x Driver from the driver selection and press Finish.
- Fill in the information about the data source in the dialog window. Choose the data source name, the server name and application name to correspond with the data that is to be made accessible. If you omit the application name, you must specify it each time you connect to this data source.
- The server name is usually selected from registered SQL servers offered at this computer; if the server is not registered and it should not be registered, it is possible to enter into the editable combo box instead of a name the IP address and port of the remote computer where the 602SQL server is running (in the TCP/IP mode).