FreeTDS provides the transport to connect to Sybase and MS SQL Server databases. SQSH (pronounced "squish") is a utility for accessing these databases similar to the ISQL utility. BONE is required for this to work.
I can report that i have used BeOS to connect to the following databases using FreeTDS and SQSH:
- MS SQL Server 7 on a Windows 2000 server
- MS SQL Server 2000 on a Windows 2000 server
- Sybase ASE 11.03 on a Sun Solaris 2.51 Server
- Sybase ASE 11.9.2 on a Solaris 2.7 Server
- Sybase ASE 12.0 on a Solaris 2.7 Server
- Sybase ASE 11.9.2 on a Mandrake Linux Server.
Simply download the package below and install it. There is a readme in /boot/home/freetds after you run the package install. More info can be had here.
I have provided a Sybase database server, userid and password for you to test this over the internet. Details are in the readme file mentioned above. I am pleased to say that many people have tested connecting to my Sybase database server over the internet and it works fine.
FreeTDS supports the older DBlib and Sybases' CTlib as well as having it's own API. There is a mailing list over at the FreeTDS site and a good FAQ. There is also a FreeTDS JDBC driver available as well.
This version of FreeTDS and SQSH have been extensively tested on BeOS and is known to work fine. I have written a BeOS GUI proof of concept app which i will release when it is looking nice ;-)
This GUI connects to a Sybase or MS SQL Server database and maintains a persistent connection allowing you to execute SQL queries and get results back. It is linked against libtds.
SQSH is a commandline utility which also does this, which is why i bundled it.
Please note that i didn't write FreeTDS or SQSH; i merely brought them to BeOS.
Please email me any bugs.
Thanks to Zathros for hosting this binary!
Visit his site: http://www.3rd-rock.net/