bypassing /etc/freetds.conf or interfaces file

Brian Bruns camber at ais.org
Thu Dec 13 10:54:51 EST 2001



Ok, the non-portable (as in don't expect this to work on OpenClient or 
MS's stuff), is:

Compile FreeTDS with the desired version using the --with-tdsver=x.x 
configure flag.  I'll assume this is for MS SQL, so let's say it's 7.0 for 
arguments sake.

Now do everything like normal but use the DNS name of the host on which 
the database lives as the server name.  As long as the SQL Server is 
listening on prot 1433, this will work.

If you are using Sybase or MS SQL is not on 1433 put in a call like this:

tds_set_port(con->tds_login, 4000);

just prior to calling ct_connect() where con is the pointer returned from 
ct_con_alloc() and 4000 is the port number the server is listening at.

If you also need for some reason to change the TDS protocol version have a 
look at tds_set_version() also in src/tds/login.c and make a similiar call 
to it.

Changing the port number can also be done at runtime by using the TDSPORT 
environment variable.  Legal values are 4.2, 5.0, and 7.0.

Brian 

On Tue, 11 Dec 2001, David Nahman wrote:

> I'm using the ctlib interface (ct_connect, etc).
> 
> thanks,
> david
> 
> > It is possible, which API are you using?
> > 
> > Brian
> > 
> >
> 
> ---
> You are currently subscribed to freetds as: [camber at ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 






More information about the FreeTDS mailing list