Connect HP-UX Itanium to SQL Server
Use the SQL Server ODBC driver to connect HP-UX Itanium to SQL Server 7—2019.
- 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.