Skip to Content.
Sympa Menu

freetds - RE: [freetds] Sybase ASA 8

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Björn Lantz <bjorn.lantz AT twoguysandadog.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Sybase ASA 8
  • Date: Sat, 15 Mar 2003 12:28:50 +0100

Hi James (and all other gurus),

Here it is (tdsdump attached).

In windows 2000 it works fine with Sybases own ASA 8 ODBC driver. There
I supply server name, user name, password, database, and network
(tcp/ip) parameters.

Win32 ODBC config that works :
Server name : 'SIL'
Database name :'sil01'
user name : 'dba'
password : 'sql'
Network tcp/ip : 'host=192.168.1.1;port=2638'

In freetds I do not know where to set the server name (seems to be
needed in the negotiation with the server [i guess]), and, as far as I
can see in the tdsdump) the database name does not get transmitted
either, which renders the error from the server.

Really appreciate your help.
/Björn Lantz

odbc.ini :

[sil01]
Driver = /usr/lib/libtdsodbc.so
Description = Test
Servername = SIL
#Server = 192.168.1.1
#Port = 2638
#TDS_Version = 5.0
Database = sil01
Trace = Yes
FetchBufferSize = 99

freetds.conf :
[global]
tds version = 7.0
initial block size = 512
swap broken dates = no
swap broken money = no
try server login = yes
try domain login = no
; nt domain = WORKGROUP
cross domain login = no
dump file = /tmp/freetds.log
debug level = 99
; timeout = 10;
; connect timeout = 10;

[SIL]
host = 192.168.1.1
port = 2638
tds version = 5.0
text size = 2048

./configure \
--build=i386-redhat-linux \
--prefix=/usr \
--exec-prefix=/usr \
--bindir=/usr/bin \
--sbindir=/usr/sbin \
--sysconfdir=/etc \
--datadir=/usr/share \
--includedir=/usr/include \
--libdir=/usr/lib \
--libexecdir=/usr/libexec \
--localstatedir=/var \
--sharedstatedir=/usr/com \
--mandir=/usr/share/man \
--infodir=/usr/share/info \
--prefix=/usr \
--with-config-file-path=/etc \
--with-exec-dir=/usr/bin \
--with-unixodbc=/usr \
--includedir=/usr/include \
--oldincludedir=/usr/include \
--with-tdsver=7.0 \
--enable-threadsafe

Finally I am using unixODBC 2.2.4.

/Björn

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> Lowden, James K
> Sent: den 14 mars 2003 17:38
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Sybase ASA 8
>
>
> > From: Björn Lantz [mailto:bjorn.lantz AT twoguysandadog.com]
> > Sent: March 14, 2003 7:32 AM
> >
> > Unfortunatelly naming the freetds.conf file entry the same as the
> > database name did not change the behaviour in any way. In the
> > first sent
> > packet in the dump file I can see the password twice. Is
> this correct,
> > or is it the database name that should be there instead in
> one of the
> > occurences?
>
> I'm pretty sure that's normal. Please post the output of TDSDUMP and
> TDSDUMP (unadulterated, if you can). I'd like to look at it
> more closely.
> It's better if you send an attachment, so it doesn't wrap.
>
> Odd. So far, everyone who's tried to use ASA has succeeded IIRC.
>
> --jkl
>
>
> The information contained in this transmission may contain
> privileged and
> confidential information and is intended only for the use of
> the person(s)
> named above. If you are not the intended recipient, or an
> employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this
> communication is
> strictly prohibited. If you are not the intended recipient,
> please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account
> orders and/or
> instructions by e-mail, and therefore will not be responsible
> for carrying
> out such orders and/or instructions.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



Archive powered by MHonArc 2.6.24.

Top of Page