How to access Sybase ASE16 with ODBC?
I have a SAP System 7.4 running under LinuX Suse and Sybase ASE 16. My developers need to access Sybase using OBDC, these external database runs under Windows and it´s SQL Express. I think the way to go is using unixODBC, but I don´t know how to set it. unixODBC is already install, but I´m not sure if I need an additional library or how to set it.
My problem is solved. The solution was to install the unixODBC and the driver for SQL server for Linux directly from Microsoft. Make sure to fix any possible error when you run the SQL driver...
If it is installed correctly, you can test executing something like this:
sqlcmd -S<IP> -U<user> -P<password> <---This is the info for the SQL Server you want to connect.
1> select @@version