FreeTDS Development Group

[lsunley AT mb.sympatico.ca]

In <3778FAB3D61A7A40833F1CB3B8C173AA02A3F76F AT AC2KAMA0107.ac.lp.acml.com>,
on 11/08/04 
   at 03:52 PM, "Lowden, James K" <LowdenJK AT bernstein.com> said:

>> From: Gene Dymarskiy
>> Sent: Monday, November 08, 2004 10:49 AM
>> 
>> > The correct server name can be obtained from the odbc.ini 
>> > file by specifying the keys "server"' and "address". 
>> > "address" is used to determine the host name/ip address of 
>> > the database server and "server" is used as the name sent off 
>> > with the login packet.
>> 
>> I can confirm that this works. Do not define "Servername" in odbc.ini
>> 
>> Instead specify Server, Address and Port keys. If you do not specify
>> "port" key it defaults to 4000. 
>> 
>> Sample odbc.ini entry
>> 
>> [ASA7]
>> Description     = ASA Sybase
>> Driver          = /usr/local/lib/libtdsodbc.so
>> Server          = [ASA server name]
>> Address =       [IP address of the ASA server]
>> Port    =        2638
>> Trace               = Yes
>> TraceFile           = /tmp/odbc_sql.log
>> 
>> This is much better than using DSQUERY. For one you can specify
>> connections to multiple ASA servers ;)

>Ugh.  OK, it works.  That's about the best that can be said for it, not
>that that's nothing.  I mean, to pass a database name, we have to give up
>minor features like DNS-lookup of the server's address.  :-/

The "Address" key can also be a name that resolves to the IP address. The
code uses the value passed by the key as the argument for tds_lookup_host
that will resolve the IP address for a  name.


>Expect this to change one day.  When you upgrade, check the README.  At
>least, there'll be an attribute in the DSN or freetds.conf entry that
>supports a default database name.  Maybe maybe, we'll add 'DatabaseName'
>as a connection string attribute, like (AIUI) Sybase does.  (cf.
>http://manuals.sybase.com/onlinebooks/group-sas/awg0703e/dbrfen7/@ebt-li
>nk;pt=5012;uf=0?target=0;window=new;showtoc=true;book=dbrfen7 ).

There is a key in ODBC.INI for the database. It is "Database"

Works for me

>They also mention that if no database name is indicated, you'll be
>connected to the Master database by default.  Is there such thing in ASA? 
>If so, that should be our default, too.  As far as we know, non-ASA
>servers ignore this field, so we could set it to 'master' by default all
>the time, not just for ASA servers.  

>--jkl

Lorne

-- 
-----------------------------------------------------------
lsunley AT mb.sympatico.ca
-----------------------------------------------------------