FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> 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@msticket 
> and select * from dual@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.

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