How to conenct Ms-Sql server from Unix box.

Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql server from Unix by using Sybase isql utility but it seems with new version of Sql-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server from unix machine.
Thanks,
-Uttam
Are you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam