SQL Server ODBC Driver Configuration: Difference between revisions

From RadiWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:
[[File:SQL_Server_ODBC_Driver1.png]]
[[File:SQL_Server_ODBC_Driver1.png]]


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


[[File:SQL_Server_ODBC_Driver2.png]]
[[File:SQL_Server_ODBC_Driver2.png]]


{{ScreenElementDescription|Data Source Name|An unique name that uniquely identifies the Data Source from the other available Data Sources.}}
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}
{{ScreenElementDescription|Description|Any additional information regarding the Data Source}}
{{ScreenElementDescription|SQL Server Authentication|Select this option to use a SQL Server specific username and password to connect to the MSSQL server.}}
{{ScreenElementDescription|TCP/IP Server|The name (or IP address) of the MySQL server, to which a connection should be made}}
{{ScreenElementDescription|Client Configuration...|Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.}}
{{ScreenElementDescription|Port|The port-number to which the which the connection should be made. By default this is port-number 3306}}
{{ScreenElementDescription|Login ID|The name of the MSSQL user that should be used to connect to the MSSQL Server}}
{{ScreenElementDescription|User|The name of the MySQL user that should be used to connect to the MySQL Server}}
{{ScreenElementDescription|Password|The password of the MSSQL user that should be used to connect to the MSSQL Server}}
{{ScreenElementDescription|Password|The password of the MySQL user that should be used to connect to the MySQL Server}}
{{ScreenElementDescription|Database|The name of the MySQL database that should be connected to}}
{{ScreenElementDescription|Test|Will perform a connection test to the specified MySQL server and Database}}
{{ScreenElementDescription|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.  
Once the MSSQL ODBC Data Source connection is correctly configured, the configuration of the [[customer database]] in {{RadiMation}} can be performed.  

Revision as of 13:16, 9 February 2011

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 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 Server The name (or IP address) of the MSSQL server, to which a connection should be made

details.}}

SQL Server ODBC Driver2.png

ScreenElementDescription.svg Windows NT Authentication Select this option to use the credential of the logged in user to connect to the MSSQL server.
ScreenElementDescription.svg SQL Server Authentication Select this option to use a SQL Server specific username and password to connect to the MSSQL server.
ScreenElementDescription.svg Client Configuration... Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.
ScreenElementDescription.svg Login ID The name of the MSSQL user that should be used to connect to the MSSQL Server
ScreenElementDescription.svg Password The password of the MSSQL user that should be used to connect to the MSSQL Server

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