Skip to Content.
Sympa Menu

freetds - RE: [freetds] Sybase ASA 7, unixODBC problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: lsunley AT mb.sympatico.ca
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Sybase ASA 7, unixODBC problem
  • Date: Mon, 08 Nov 2004 18:12:33 -0500

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
-----------------------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page