FreeTDS Development Group

["Phil Taylor" <Phil AT lansystems.co.uk>]

Hi,

Please see comments below...

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of FTL Africa
> Sent: 18 November 2003 06:58
> To: freetds AT lists.ibiblio.org
> 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 AT lansystems.co.uk) 
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