Re: [gnome-db] Help with FreeTDS libgda provider

[Holger Thon <holger thon gnome-db org>]

Hi,

On Wed, Jan 08, 2003 at 11:48:13AM -0500, Zachariah Mully wrote:
> On Tue, 2003-01-07 at 20:29, Rodrigo Moya wrote:
> 
> > you will get better error messages if you try to connect with mergeant.
> > 


sorry for the delay. Please start with this DSN:

    HOST=prince-tds

TDS protocol version is split into major and minor 
version, so another correct dsn would be:

    HOST=prince-tds;TDS_MAJVER=7;TDS_MINVER=0

Next try would be enabling mixed authentication or even
standard authentication on sql server. Windows NT authentication
has been added in 0.60, but it's somewhat - well - experimental.

If you are still unable to connect, please turn on
dumping tds packages in your freetds.conf, add to
your [prince-tds] section e.g.:

    dump file = /tmp/freetds.dump
    debug level = 10

If you send a dump, please check your password and
change the hex representation to e.g. 78 78 78 78 and
ascii representation to xxxx, then.

> 
> Like this error message from Mergeant?
> 
> "Establishing connection failed."

This means that connecting via tds_connect() failed. 
So either the physical network link could not be 
established or the server did not like the parameters 
it received (wrong password/parameter).

Unfortunately this happens in a state when the connection
structure for the error callbacks is not setup entirely,
that's why you don't get more information. :-(

Ciao
Holger