[freetds] Re: FreeTDS Digest, Vol 18, Issue 31

jun_chen at bankone.com jun_chen at bankone.com
Tue Jul 27 14:05:51 EDT 2004


freddy77,

Did you get the attached SQL log and have a chance to take a look at the 
issue?

Jun 



Jun Chen



 RE: Bug in SQLNumResultCol function? (Lowden, James K)
 

----------------------------------------------------------------------

Message: 1
Date: Fri, 23 Jul 2004 12:03:48 -0400
From: "Lowden, James K" <LowdenJK at bernstein.com>
Subject: RE: [freetds] RE: Bug in SQLNumResultCol function?
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Message-ID:
 <3778FAB3D61A7A40833F1CB3B8C173AA02A2F614 at AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain; charset="us-ascii"

> I got the attached SQL log file. 

The mailing list software stripped off your attachment.  Sorry. 

I'm trying to remove the attachment-type restriction, because now that
we accept mail only from  subscribers, it seems to me the probability of
nasty attachments is small. 

This message is a test; it has a trivial attachement.  If you can read
it, yours should be accepted too.  If not, send it to
jklowden at schemamania.org, and I'll add the mime type you're using to the
set of acceptable types. 

--jkl




> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org 
> [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of 
> jun_chen at bankone.com
> Sent: Friday, July 23, 2004 9:21 AM
> To: freetds at lists.ibiblio.org
> Subject: [freetds] RE: Bug in SQLNumResultCol function?
> 
> 
> freddy77,
> 
> I replied your email a few weeks ago. Then I went for 
> vacation. After I 
> came back from vacation, I found out the email got rejected 
> by the list because of the size of the attached log file. 
> Very sorry about that.
> 
> I did that again from the beginning by downloading freetds 
> 0.63 from 7/22 
> build.
> 
> I changed odbcinst.ini as you suggested and also added the 
> following two 
> lines to freetds.conf:
>         dump file = /tmp/freetds.log
>         debug level = 10
> 
> After I run the sql command select * from 
> "scProblem"@msticket in Oracle 
> 
> 
> 
> Oracle support verified the connection was setup correctly. I can run 
> select * from all_catalog at msticket 
> and select * from dual at msticket successfully.
> 
> Thanks.
> 
> Jun
> 
> > freddy77,
> > 
> > After I did ./configure --prefix=/usr/local/freetds
> > --with-unixodbc=/usr/local/unixODBC as you suggested with the 
> > following 
> > configuration in /etc/odbcinst.ini
> > 
> > [TDS]
> > Description     = FreeTDS v0.63
> > Driver          = /usr/local/freetds/lib/libtdsodbc.so
> > Setup           = /usr/local/freetds/lib/libtdsodbc.so
> > FileUsage       = 1
> > Trace           = Yes
> > TraceFile       = /tmp/sql.log
> > 
> 
> Section for trace settings should be ODBC, I think your 
> odbcinst.ini should be
> 
> [TDS]
> Description     = FreeTDS v0.63
> Driver          = /usr/local/freetds/lib/libtdsodbc.so
> Setup           = /usr/local/freetds/lib/libtdsodbc.so
> FileUsage       = 1
> 
> [ODBC]
> Trace           = Yes
> TraceFile       = /tmp/sql.log
> ForceTrace      = Yes
> Pooling         = No
> 
> > and /etc/odbc.ini
> > 
> > [peregrine]
> > Description     = Peregrine MS SQL Server
> > Driver          = TDS
> > Servername      = peregrine
> > Trace           = Yes
> > TraceFile       = /tmp/sql.log
> > ForceTrace      = Yes
> > Pooling         = No
> > 
> > the command isql -v peregrine <username> <password> works fine. But 
> > the database link msticket in oracle to the MS SQL server peregrine
> > still doesn't work. I run select * from "scProblem"@msticket 
> > in Oracle 
> > SQLPLUS
> > and got the error:
> > select * from "scProblem"@msticket
> >               *
> > ERROR at line 1:
> > ORA-02068: following severe error from MSTICKET
> > ORA-28511: lost RPC connection to heterogeneous remote agent 
> > using SID=%s
> > ORA-28509: unable to establish a connection to non-Oracle system
> > 
> 
> Mmmm... I don't know Oracle, are you sure connection is set ok?
> 
> > The log sql.log didn't get created. I also did export
> > TDSDUMP=/admin/home/oracle/freetds.log and the file 
> > freetds.log is empty.
> 
> It seems FreeTDS it's not trying to connect...
> 
> > I also turned on trace on the database link. Here is the trace from
> > Oracle.
> > 
> 
> It's not clear to me. Try changing odbcinst.ini as specified.
> 
> freddy77
> 
> This transmission may contain information that is privileged, 
> confidential and/or exempt from disclosure under applicable 
> law. If you are not the intended recipient, you are hereby 
> notified that any disclosure, copying, distribution, or use 
> of the information contained herein (including any reliance 
> thereon) is STRICTLY PROHIBITED. If you received this 
> transmission in error, please immediately contact the sender 
> and destroy the material in its entirety, whether in 
> electronic or hard copy format. Thank you.
> 
> 

-----------------------------------------
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.
If you, as the intended recipient of this message, the purpose of which is 
to inform and update our clients, prospects and consultants of 
developments relating to our services and products, would not like to 
receive further e-mail correspondence from the sender, please "reply" to 
the sender indicating your wishes.  In the U.S.: 1345 Avenue of the 
Americas, New York, NY 10105.

-------------- next part --------------
These types used be be accepted.  I hope all types are now accepted. 

text/plain
text/x-patch
multipart/alternative
multipart/mixed
multipart/signed
application/octet-stream
application/x-zip-compressed
application/x-gzip
application/x-gunzip

------------------------------

Message: 2
Date: Fri, 23 Jul 2004 09:45:50 -0700
From: <jonasb at alum.rpi.edu>
Subject: RE: [freetds] DBD::Sybase make errors
To: <freetds at lists.ibiblio.org>, <freetds at lists.ibiblio.org>
Message-ID: <950801c470d4$82aa19e0$0a09010a at mail2world.com>
Content-Type: text/plain;                charset="iso-8859-1"

Turns out I fixed it - I was running an old version of freeTDS so I
upgraded to the latest.
 
Thanks!
 
B

<-----Original Message----->

                                  From: Michael Peppler
Sent: 7/23/2004 2:17:06 AM
To: freetds at lists.ibiblio.org
Subject: RE: [freetds] DBD::Sybase make errors 

On Thu, 2004-07-22 at 21:39, Lowden, James K wrote: 
> > From: Michael Peppler 
> > Sent: Thursday, July 22, 2004 2:25 PM 
> > 
> > > If I try to make the DBD::Sybase module directly, I get the 
> > following 
> > > error: 
> > > 
> > > gcc -c -I/usr/local/freetds/include -DNO_THREADS 
> > > -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI 
> > > -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
-D_LARGEFILE_SOURCE 
> > > -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 
> > -mcpu=i686 
> > > -DVERSION=\"1.04\" -DXS_VERSION=\"1.04\" -fpic 
> > > "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c 
> > > dbdimp.c:3655: parse error before '*' token 
> > > dbdimp.c: In function `to_binary': 
> > > dbdimp.c:3659: `CS_BINARY' undeclared (first use in this function)
> > 
> > Hmmm - don't know why that wouldn't be defined. That 
> > particular bit of code isn't new, so FreeTDS should have it 
> > defined somewhere. 
> 
> $ grep -n CS_BINARY include/cspublic.h 
> 68:typedef unsigned char CS_BINARY; 
> 606:#define CS_BINARY_TYPE 12 
> 
> It is, and cspublic.h is #included in ctpublic.h. Is dbdimp.c somehow 
> not including ctpublic.h? 

Sure it is: 

dbdimp.c includes Sybase.h, which starts with: 



#define NEED_DBIXS_VERSION 8 

#include /* installed by the DBI module */ 

#include 
#include 

.... 

Michael 
-- 
Michael Peppler Data Migrations, Inc. 
mpeppler at peppler.org http://www.peppler.org/ 
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short 
or long term contract positions - http://www.peppler.org/resume.html 


_______________________________________________ 
FreeTDS mailing list 
FreeTDS at lists.ibiblio.org 
http://lists.ibiblio.org/mailman/listinfo/freetds 
. 
 


------------------------------

Message: 3
Date: Fri, 23 Jul 2004 16:35:53 -0400
From: "Scott Johnson" <scomps at purplewire.org>
Subject: Re: [freetds] Freepascal with FreeTDS/UnixODBC The saga
                 continues
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Message-ID: <000801c470f4$a5fc8f20$170c1818 at jupiter>
Content-Type: text/plain;                charset="iso-8859-1"

*This message was transferred with a trial version of CommuniGate(tm) Pro*
I interface with FreePascal via the 'odbcsql' unit that is included with
FreePascal.  It is intended to talk with unixODBC.  The strange thing was
that I got it all working properly on a test system (RH9) and then set it
all up over again, on a Debian system on the active network at my job. 
Then
I started getting different failures.  On the debian system I had to use
that $LINKLIB directive, but on the RH9 system I didn't.  (I copied the
entire codebase for the test application from one machine to the other)

The 'program' I'm using is a slightly modified 'testodbc.pp' example that
came with freepascal.  The only modifications originally were to specify 
the
DSN, passwords etc.

I'll be glad to share what I have with anyone that's interested.  The
ODBCsql unit for FreePascal isn't documented very well.  It only has the
function definitions, structures, types and constants listed without any
explanation of how they're called or what the return values might be 
(other
than type)


--Scott
----- Original Message ----- 
From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio at vodafone.com>
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Sent: Friday, July 23, 2004 3:57 AM
Subject: RE: [freetds] Freepascal with FreeTDS/UnixODBC The saga continues


*This message was transferred with a trial version of CommuniGate(tm) Pro*
>
> *This message was transferred with a trial version of
> CommuniGate(tm) Pro*
> Once again, more exhaustive searching solved it.  In this case, the
> assertion was tripped by freepascal.
>
> It needed {$LINKLIB "c"} as the first line of the program code   (I'm
> posting this so future folks might find it in the archives)
>
> --Scott
>
> PS.  Sorry for all the mails
>

Don't mind for all mails. However I suspect some type of memory/heap
corruption somewhere. You are the first who it's trying FreeTDS with
FreePascal and the first that had these strange problems... Linux it's a
well tested platform and FreeTDS it's tested against some memory
debugger (I test sometimes with ElectricFence, someone else use
dmalloc). There are some places to look. For example how did you
interface FreePascal with unixODBC ?? There is a module for unixODBC ?

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 18, Issue 31
***************************************





More information about the FreeTDS mailing list