Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ODBC Memory Leak?

2 posts in Windows NT Last posting was on 1997-12-11 18:27:09.0Z
Grant Fritchey Posted on 1997-12-10 18:22:17.0Z
Message-ID: <348EDDD8.7863EE61@csiwhq.com>
Date: Wed, 10 Dec 1997 13:22:17 -0500
From: Grant Fritchey <gfritchey@csiwhq.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: ODBC Memory Leak?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 32
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5358
Article PK: 1081441

We're getting a strange problem and I was wondering if anyone else had
run into it.

We're building a client server app using VB 5.0 patch 2. We're using RDO
against Sybase SQL Server 11.0.3. We have the OpenClient version 11.1 (I
think). ODBC is System 11 version 3.0.0.

So, when setting properties for stored procs, occasionally, usually
after working for a few hours, the data types on the stored procs start
to change on their own. For instance, a procedure may require a Numeric
to retrieve records based on the key field. We'll set the
RDOParameter.Type to rdTypeNUMERIC and then use a double in VB to set
the parameter value. When the query executes however, it thinks that the
parameter is a string. Sure enough if you check the value, it is a
string. Once this starts, it doesn't seem to matter what you do, some
parameters just change their data types.

So, what is this? Do we have an incorrect version on any of our pieces?
Is there a memory leak in RDO itself? Could there be something in the
code that is causing some sort of memory leak?

Any help at all here would be appreciated.

Thanks,

Grant

------------------
Grant Fritchey
gfritchey@csiwhq.com
gbf@moviefone.com
http://www.csiwhq.com


Adalberto B Nascimento Posted on 1997-12-11 18:27:09.0Z
From: "Adalberto B Nascimento" <ticobino@opus.com.br>
References: <348EDDD8.7863EE61@csiwhq.com>
Subject: Re: ODBC Memory Leak?
Date: Thu, 11 Dec 1997 16:27:09 -0200
Lines: 49
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOle: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <yBpMDolB9GA.77@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5351
Article PK: 1081430

Hi Grant,

In past I had this problem with ODBC using with DAO, I don't use RDO. But,
To correct this problem I used to send all parameters with strings and in
the Sybase's procedure I convert it to a data type correct.
I hope this information helps you.

[]'s
Adalberto B Nascimento
ticobino@opus.com.br

Grant Fritchey wrote in message <348EDDD8.7863EE61@csiwhq.com>...
>We're getting a strange problem and I was wondering if anyone else had
>run into it.
>
>We're building a client server app using VB 5.0 patch 2. We're using RDO
>against Sybase SQL Server 11.0.3. We have the OpenClient version 11.1 (I
>think). ODBC is System 11 version 3.0.0.
>
>So, when setting properties for stored procs, occasionally, usually
>after working for a few hours, the data types on the stored procs start
>to change on their own. For instance, a procedure may require a Numeric
>to retrieve records based on the key field. We'll set the
>RDOParameter.Type to rdTypeNUMERIC and then use a double in VB to set
>the parameter value. When the query executes however, it thinks that the
>parameter is a string. Sure enough if you check the value, it is a
>string. Once this starts, it doesn't seem to matter what you do, some
>parameters just change their data types.
>
>So, what is this? Do we have an incorrect version on any of our pieces?
>Is there a memory leak in RDO itself? Could there be something in the
>code that is causing some sort of memory leak?
>
>Any help at all here would be appreciated.
>
>Thanks,
>
>Grant
>
>------------------
>Grant Fritchey
>gfritchey@csiwhq.com
>gbf@moviefone.com
>http://www.csiwhq.com
>
>