Installing the SQL Client Tools for Microsoft SQL Server
...
To access an Microsoft SQL Server running on a Windows system via the E2E BridgeBRIDGE, you need no database client tools, if the Microsoft SQL Server installation is a single installation - means if only one Microsoft SQL Server is installed on that machine. However, if several instances - so called "named instances" are installed on that machine, you are not able to connect to that Microsoft SQL Server without having installed the Microsoft SQL client tools or the MDAC (Microsoft Data Access Components). The MDAC tools are included in the Microsoft SQL Server client tools but you can also download them at http://msdn.microsoft.com/data/mdac/downloads.
Linux Systems
Since Bridge 7, the E2E Bridge the BRIDGE supports Microsoft SQL Server on Linux systems.
Panel |
---|
borderColor | #7ea112#EAA01E |
---|
bgColor | white |
---|
borderWidth | 32 |
---|
borderStyle | solid |
---|
|
To access an Microsoft SQL Server running on a Linux system via the E2E BridgeBRIDGE, you need to install the Microsoft ODBC driver for SQL Server on your Linux system. Refer to the Microsoft pages for more information on that. |
Defining the Microsoft SQL Server Database Preferences on the
...
BRIDGE
Multiexcerpt include |
---|
MultiExcerptName | Database Preferences |
---|
nopanel | true |
---|
PageWithExcerpt | Installing and Configuring Database Access for DB2 |
---|
|
Select Microsoft SQL Server, enter the following parameter and click Apply.
Key | Value |
---|
MSSQLLIB
| Path to the client library (file libmsodbcsql-13.1.so.9.2 , which is part of the DBMS client installation), e.g. |
#7ea112#EAA01E | bgColor | white |
---|
borderWidth |
---|
|
|
3 | Linux: /opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2 |
|