SQL Server ODBC Driver Configuration

From RadiWiki
Revision as of 13:12, 9 February 2011 by Joro (talk | contribs)
Jump to navigation Jump to search

The SQL Server ODBC Driver Configuration dialog allows you to configure the details of an ODBC connection to a MSSQL database. This dialog is not part of RadiMation®, but it is provided by Microsoft.

SQL Server ODBC Driver1.png

ScreenElementDescription.svg Data Source Name An unique name that uniquely identifies the Data Source from the other available Data Sources.
ScreenElementDescription.svg Description Any additional information regarding the Data Source
ScreenElementDescription.svg TCP/IP Server The name (or IP address) of the MySQL server, to which a connection should be made
ScreenElementDescription.svg Port The port-number to which the which the connection should be made. By default this is port-number 3306
ScreenElementDescription.svg User The name of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Password The password of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Database The name of the MySQL database that should be connected to
ScreenElementDescription.svg Test Will perform a connection test to the specified MySQL server and Database
ScreenElementDescription.svg Details >> Will show additional configuration details for the MySQL connection. Your MySQL database administrator can help you with setting this details.

SQL Server ODBC Driver2.png

ScreenElementDescription.svg Data Source Name An unique name that uniquely identifies the Data Source from the other available Data Sources.
ScreenElementDescription.svg Description Any additional information regarding the Data Source
ScreenElementDescription.svg TCP/IP Server The name (or IP address) of the MySQL server, to which a connection should be made
ScreenElementDescription.svg Port The port-number to which the which the connection should be made. By default this is port-number 3306
ScreenElementDescription.svg User The name of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Password The password of the MySQL user that should be used to connect to the MySQL Server
ScreenElementDescription.svg Database The name of the MySQL database that should be connected to
ScreenElementDescription.svg Test Will perform a connection test to the specified MySQL server and Database
ScreenElementDescription.svg Details >> Will show additional configuration details for the MySQL connection. Your MySQL database administrator can help you with setting this details.

Once the MSSQL ODBC Data Source connection is correctly configured, the configuration of the customer database in RadiMation® can be performed.