FreeTDS Development Group

[Jeff Fisher <JFisher AT Emery-Waterhouse.com>]

HSODBC - Oracle's way of talking with another database through odbc. -- Your
second choice was correct.  I'll check our version and let you know.

Thanks.

-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
Sent: Monday, April 05, 2004 3:28 PM
To: FreeTDS Development Group
Subject: RE: [freetds] General Error in nvITrans_BeginT - rc = -1


> From: Jeff Fisher [mailto:JFisher AT Emery-Waterhouse.com]
> Sent: April 5, 2004 2:56 PM
> 
> We've installed freetds successfully and can connect to the sql server
> database using isql.  However, while trying to connect 
> through Oracle's
> HSODBC service we get the following error:
>  
> [9013]General error in nvITrans_BeginT - rc = -1
> Please refer to the log file for details

Would you mind updating an old man about just what it is that "Oracle's
HSODBC service" does?  Is it a TDS gateway to Oracular servers?  The FreeTDS
driver communicates with a pseudo-TDS host that converts the TDS stream into
something Oracle understands?  

Or is is the other way around: the Oracle database (or its minion) uses ODBC
to talk to "foreign" databases, in this case via the FreeTDS ODBC driver?
I'm placing my bet here.  

Either way, there are two categories of error:

1.  The client requires a feature in ODBC that FreeTDS (what version, btw?)
doesn't support.  In the best case, that will be evident in the TDSDUMP log.


2.  The pseudo-host, if extant, does some unusual TDS thing.  That surely
would be in the TDSDUMP log.  

Finally, there's James's Best Guess:  You're using 0.62.1 or older, and are
stepping on the SQLTran bug fixed in 0.62.2.  Details are in the README.
Pick up something newer in our current directory on ibiblio and call me in
the morning.  

HTH.  

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


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