Path: g2news1.google.com!postnews.google.com!w17g2000yqh.googlegroups.com!not-for-mail
From: Greg Mills <Greg.Mi...@Infor.com>
Newsgroups: sybase.public.connectivity.odbc
Subject: Allocating an ODBC Descriptor Handle using SQL_HANDLE_DESC
Date: Tue, 7 Dec 2010 10:35:38 -0800 (PST)
Organization: http://groups.google.com
Lines: 26
Message-ID: <27c8382b-1e93-4546-866d-4d04fdb1cbd4@w17g2000yqh.googlegroups.com>
NNTP-Posting-Host: 207.54.56.34
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1291746938 28397 127.0.0.1 (7 Dec 2010 18:35:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Dec 2010 18:35:38 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: w17g2000yqh.googlegroups.com; posting-host=207.54.56.34; posting-account=zpDo8QoAAADSu6Blo4k1aFRI_nqKYofu
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR
 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E),gzip(gfe)

Hello,

I am attempting to migrate one of our CT-Lib based programs to use
Microsoft's Native ODBC. The server version is Adaptive Server
Enterprise 15.5. Everything appears to work fine (connections,
executing and fetching data, etc.) with the exception of creating a
connection descriptor handle using SQL_HANDLE_DESC. It gives me a
return code -2 (invalid handle?), but no diagnostic messages. I'm
doing this after opening the connection, because when I tried it prior
to opening the connection, it issued an error that the connection was
not yet open.

The driver is Adapter Server Enterprise SYBDRVODB.DLL, version
15.05.00.1022, dated 9/8/2010.

I want to set the precision and scale limits for amounts. That is the
reason for the descriptor handle. We also have a version of this
program for MS SQL, using Native ODBC, and it works without error.

Does anyone have any suggestions? I'd appreciate your input.

If you know of a location for Sybase ODBC function documentation, I'd
also appreciate that.

Thanks,
Greg