Once you start installation process, is was OK to install only the "Interactive SQL" and "SAP ASE ODBC Driver" items from the Custom installation menu. Use the " Get free trial" button to obtain the installation package. For our purposes, it is OK to use the evaluation version of ASE (as Sybase and its drivers are now under the ASE product). Because Sybase is now owned by SAP systems, you need to have an account at SAP, which is a paid service. The first thing you have to do is install a Sybase driver on the operating system from which you will connect to the Sybase database. This DSN is what I pass to the MSDASQL driver in my SQL Server instance. I have a Sybase driver on my operating system, and from it I create a System DSN. Note: my OS and MSSQL configuration is 64-bit. MicThe osoft OLE DB Provider for ODBC Drivers ( in other words in your MSSQL SSMS Object explorer/Server Objects/Linked servers/Providers).The ODBC driver for Sybase (something like SYBDRVODB64DLL) - for 圆4 bit OS.After a long time spent testing ideas, I found a simple solution.
It was a neverending story to search up tips and ideas and put them together. Yesterday I spent a lot of time with quite a simple problem: how to connect to a Sybase database server from SQL Server.
0 kommentar(er)
