Installing the SQL Client Tools for Microsoft SQL Server
Windows Systems
To access an Microsoft SQL Server running on a Windows system via the BRIDGE, 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 BRIDGE supports Microsoft SQL Server on Linux systems.
Panel
borderColor
#EAA01E
bgColor
white
borderWidth
2
borderStyle
solid
To access an Microsoft SQL Server running on a Linux system via the BRIDGE, 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
Note
This is relevant only for Linux systems.
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.