RE: Failing to connect from Redhat Linux to MS SQL Server

Hi,

Please see comments below...

> -----Original Message-----
> From: freetds-bounces@xxxxxxxxxxxxxxxxx
> [mailto:freetds-bounces@xxxxxxxxxxxxxxxxx]On Behalf Of FTL Africa
> Sent: 18 November 2003 06:58
> To: freetds@xxxxxxxxxxxxxxxxx
> Subject: [freetds] Failing to connect from Redhat Linux to MS 
> SQL Server
> 
> 
> Greetings
> 
> I am developing a Windows application, which reads from a 
> Linux database.
> Having failed to connect to the Linux server I realized I had 
> to install
> ODBC which I did. I installed unixodbc2.2.1 and the 
> postgresql driver. On
> trying to test the installation I was having 
> SQL_INVALID_HANDLE errors which
> I suspected came from wrong input handles. The connection 
> tests were failing
> as well.
> On the window application I started to get an error message 
> like the one on
> the attached document
> 
> If I try to create a data source using ODBC32 in the Control Panel the
> SQLState for the first message is HY000
> As a result I had to investigate on TDS . Apparently the 

TDS is the name of the protocol used to communicate with Sybase/MSSQL Servers ( 
Tagged Data Stream). I don't quite see why you felt you needed FreeTDS as it is 
a client library to allow unix clients to connect to Sybase or MSSQL servers 
without having to resort to the commercial Sybase driver which is only 
available for Solaris/Linux.

To talk to a PostgreSQL server you should only need the PostgreSQL ODBC driver 
which is available from 
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

If you are developing in VB.Net or C# then you may be better off using the .Net 
Data Provider for PostgreSQL from 
http://gborg.postgresql.org/project/npgsql/projdisplay.php


Therefore I would say that no in your application you do not need FreeeTDS......

Thanks

Phil

....................................................
CONFIDENTIALITY NOTICE:
This Email is confidential and may also be privileged. If you are not the 
intended recipient, please notify the sender (Phil@xxxxxxxxxxxxxxxx) 
IMMEDIATELY; you should not copy the email or use it for any purpose or 
disclose its contents to any other person.

GENERAL STATEMENT:
Any statements made, or intentions expressed in this communication may not 
necessarily reflect the view of the Company. Be advised that no content herein 
may be held binding upon the Company or any associated company unless confirmed 
by the issuance of a formal contractual document or Purchase Order.
Any Prices quoted are valid for ONE Business day only.  Calls to LAN Systems 
may be recorded for quality assurance and training purposes.

If you would like any information on the products and services offered by Lan 
Systems, please visit our web site http://www.lansystems.co.uk

E&OE