Fri, 17 April 2020
Connect HP-UX Itanium to SQL Server
Easysoft have a number of options for you if you need to connect an application on the HP-UX Itanium platform to SQL Server.
If your target SQL Server instance version is 7—2016, use the SQL Server ODBC driver. This product provides a direct connection to your SQL Server machine from the HP-UX Itanium application.
If your SQL Server version is 2017 or later, you have two options:
- Use the Easysoft ODBC-ODBC Bridge with Microsoft's SQL Server ODBC driver. Install the HP-UX Itanium ODBC-ODBC Bridge client on your UNIX machine. Install the Windows ODBC-ODBC Bridge server on a machine where the Microsoft SQL Server ODBC driver is installed.
- If you have a mixture of SQL Server versions, create a linked server on the machine running the earlier version that points to the later version. For example, if you have a SQL Server 2016 and a SQL Server 2019 machine, create a linked server on the 2016 machine that points to the 2019 machine. Then use the SQL Server ODBC driver to connect to the 2016 machine and use 4 part T-SQL work with the 2019 linked server. E.g.:
select * from MyLink.MyCatalog.MySchema.MyTable
These options are also applicable if you want to connect to SQL Server from a Linux Itanium machine.