[freetds] Re: FreeTDS Digest, Vol 16, Issue 28

Thompson, Bill D (London) bill_d_thompson at ml.com
Tue May 25 04:25:14 EDT 2004


hany,

I've also written something similar which remains unpublished.
My version does Sybase -> MSSQL, MSSQL -> Sybase, ORACLE -> Sybase , ORACLE
-> MSSQL
I have to link in to some proprietory libraries for ORACLE, and use their C
pre-compiler.
I suppose you have the same issues with DB2.

Maybe there's some mileage in this though...

Bill

> -----Original Message-----
> From:	hany heggy [SMTP:hany.hegy at etelvaz.com]
> Sent:	24 May 2004 17:37
> To:	freetds at lists.ibiblio.org
> Subject:	[freetds] Re: FreeTDS Digest, Vol 16, Issue 28
> 
>   i installed freeTDS 0.61.3 and it works fine even if there is
> communication error thanks for yr help
> 
>   by the way  this program is a database replicator  that can copy/move
> data
> from any (DB2/MYSQL/MSSQL ) to any (DB2/MYSQL/MSSQL)
>   and i spend 3 months devolping this program , i fu have any idea how i
> can
> make it GPLor make a link at freeTDS site to download it  would be fine
> 
> 
> 
> 
>   Regards,
>   Hany Heggy
>   Senior Systems Engineer
>   GDMC, Media Production City, 6th October City, Egypt
>   Mobile: +20-101717563
>   ----- Original Message ----- 
>   From: <freetds-request at lists.ibiblio.org>
>   To: <freetds at lists.ibiblio.org>
>   Sent: Sunday, May 23, 2004 6:05 PM
>   Subject: FreeTDS Digest, Vol 16, Issue 28
> 
> 
>   > Send FreeTDS mailing list submissions to
>   > freetds at lists.ibiblio.org
>   >
>   > To subscribe or unsubscribe via the World Wide Web, visit
>   > http://lists.ibiblio.org/mailman/listinfo/freetds
>   > or, via email, send a message with subject or body 'help' to
>   > freetds-request at lists.ibiblio.org
>   >
>   > You can reach the person managing the list at
>   > freetds-owner at lists.ibiblio.org
>   >
>   > When replying, please edit your Subject line so it is more specific
>   > than "Re: Contents of FreeTDS digest..."
>   >
>   >
>   > Today's Topics:
>   >
>   >    1. Re: Problem with Building (Frediano Ziglio)
>   >    2. Re: FreeTDS hang (Frediano Ziglio)
>   >    3. Re: FreeTDS hang (James K. Lowden)
>   >
>   >
>   > ----------------------------------------------------------------------
>   >
>   > Message: 1
>   > Date: Sat, 22 May 2004 19:42:22 +0200
>   > From: Frediano Ziglio <freddyz77 at tin.it>
>   > Subject: Re: [freetds] Problem with Building
>   > To: FreeTDS Development Group <freetds at lists.ibiblio.org>
>   > Message-ID: <1085247742.5922.2.camel at freddy>
>   > Content-Type: text/plain
>   >
>   > Il ven, 2004-05-21 alle 02:29, Nguyen, Joe ha scritto:
>   > > Hi, I have a problem installing this on my sparc5 64 bit running one
> Suse
>   > > 7.3.
>   > >
>   > >
>   > >
>   > > I ran "./configure" and it completed, but when I try to "make" it, I
> get the
>   > > following error:
>   > >
>   > >
>   > >
>   > >
>   > >
>   > > ..........
>   > >
>   > > : .libs/libtds_objects.a
>   > >
>   > > ar cru .libs/libtds_objects.a
>   > >
>   > > ranlib .libs/libtds_objects.a
>   > >
>   > > creating libtds_objects.la
>   > >
>   > > (cd .libs && rm -f libtds_objects.la && ln -s ../libtds_objects.la
>   > > libtds_objects.la)
>   > >
>   > > /bin/sh ../../libtool --mode=link gcc  -g -O2   -o libtds.la -rpath
>   > > /usr/local/lib -version-info 3:0:0  libtds_objects.la  -liconv
>   > > ../replacements/libreplacements.la
>   > >
>   > > ../../libtool: test: -: integer expression expected
>   > >
>   >
>   > :(
>   >
>   > I had similar problem. It seems that at some point configure break
>   > libtool script... The solution is to use development tools (automake,
>   > autoconf) and call "sh autogen.sh" instead of configure.
>   > Did you configure two times or issued a make clean and then rebuild
>   > again ?
>   >
>   > freddy77
>   >
>   >
>   >
>   >
>   > ------------------------------
>   >
>   > Message: 2
>   > Date: Sat, 22 May 2004 19:45:39 +0200
>   > From: Frediano Ziglio <freddyz77 at tin.it>
>   > Subject: Re: [freetds] FreeTDS hang
>   > To: FreeTDS Development Group <freetds at lists.ibiblio.org>
>   > Message-ID: <1085247939.5922.6.camel at freddy>
>   > Content-Type: text/plain
>   >
>   > Il sab, 2004-05-22 alle 12:36, Hany Heggy ha scritto:
>   > >   Hi,
>   > >
>   > >   I am writing a program to copy data from 10 MSSQL server  to one
> central DB2 server using unixODBC 2.2.8, FreeTDS 0.62.1 and DB2 8.1.5 ODBC
> under RHEL AS 3.0
>   > >
>   > >   The program is multi threaded and each thread connect to certain
> MSSQL server, it works fine until one of the sever is unreachable ( i
> cannot
> ping it from Linux command line) at this point i get an error from FreeTDS
> :
>   > >    server 192.122.122.12   connect time out
>   > >
>   > >   at this point the program freeze and all threads freeze totally
>   > >
>   > >   and ideas ?
>   > >
>   >
>   > Do you get error or it just hangs inside ODBC?
>   > I would try to enable logging and remove network wire just to test...
>   >
>   > freddy77
>   >
>   >
>   >
>   >
>   > ------------------------------
>   >
>   > Message: 3
>   > Date: Sat, 22 May 2004 16:25:17 -0400
>   > From: "James K. Lowden" <jklowden at schemamania.org>
>   > Subject: Re: [freetds] FreeTDS hang
>   > To: FreeTDS Development Group <freetds at lists.ibiblio.org>
>   > Message-ID: <20040522162517.4ba00df6.jklowden at schemamania.org>
>   > Content-Type: text/plain; charset=US-ASCII
>   >
>   > On Sat, 22 May 2004, Frediano Ziglio <freddyz77 at tin.it> wrote:
>   > > Il sab, 2004-05-22 alle 12:36, Hany Heggy ha scritto:
>   > > >
>   > > >   The program is multi threaded and each thread connect to certain
>   > > >   MSSQL server, it works fine until one of the sever is
> unreachable
> (
>   > > >   i cannot ping it from Linux command line) at this point i get an
>   > > >   error from FreeTDS :
>   > > >    server 192.122.122.12   connect time out
>   > > >
>   > > >   at this point the program freeze and all threads freeze totally
>   > >
>   > > Do you get error or it just hangs inside ODBC?
>   > > I would try to enable logging and remove network wire just to
> test...
>   >
>   > If you do this, remember that every connection initializes the log
> file
>   > unless
>   >
>   > dump file append = yes
>   >
>   > is in your freetds.conf.  Another workaround is to set TDSDUMP=stderr.
>   >
>   > Nothing springs to mind, unfortunately.  I would run the application
> under
>   > gdb and, when it hangs, find out where.
>   >
>   > I would like to know, though:  What advantage is to be found in a
>   > multi-threaded design?  It seems to me that one process per
> simultaneous
>   > connection would be much safer, and that Linux is rich in IPC choices.
>   >
>   > --jkl
>   >
>   >
>   > ------------------------------
>   >
>   > _______________________________________________
>   > FreeTDS mailing list
>   > FreeTDS at lists.ibiblio.org
>   > http://lists.ibiblio.org/mailman/listinfo/freetds
>   >
>   >
>   > End of FreeTDS Digest, Vol 16, Issue 28
>   > ***************************************
>   >
>   >
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
     <http://www.ml.com/email_terms/>

==============================================================================




More information about the FreeTDS mailing list