Prev: Oracle Designer: Connect string
Next: im004 oracle odbc error with unprivileged users
From: MParenteau on 2 Aug 2006 15:14
I have migrated an application from a windows 32bit platform to Oracle 10Gr2
on a 64bit platform (Windows 2003 server) and am having problems with values
returned from the ODBC interface. All numeric values are returned as 0.
Any ideas what the problem might be?

The platform is a 64bit EMT Windows 2003 server with SP1.
The odbc driver is SQORA32.DLL version 10.02.00.01 dated 9/30/2005.
The program accessing Oracle via the ODBC handler runs directly on the
Windows 2003 server. Stepping through the code gets me to a SQLFetch
statement and the data returned has a length of 1 and it is always "0".
I might add the using the native OCI interface returns the correct values. I
need both interfaces to work to support various customers.

Additionally, this is a common handler for ODBC and when I use the SQL
Server Native ODBC driver to a SQL Database, I get back correct values.

Mike
Unisys



From: Sybrand Bakker on 2 Aug 2006 15:28
On Wed, 2 Aug 2006 14:14:02 -0500, "MParenteau"
<michael.parenteau(a)unisys.com> wrote:

>The odbc driver is SQORA32.DLL version 10.02.00.01 dated 9/30/2005.

This looks like a *32* bit driver to me.

--
Sybrand Bakker, Senior Oracle DBA
From: MParenteau on 3 Aug 2006 16:43
Yes, it looks like a 32 bit driver to me as well. That's what gets
installed with the 64bit Oracle 10Gr2. I don't seem to be able to find any
SQORA64 references anywhere - including Oracles own site. I guess I'll have
to post the problem with metalink and see what they have to say.

What is even stranger, is when I use a 32 bit driver on a 32bit windows
platform and reference this Oracle, all of the data comes back correctly.

Mike

"Sybrand Bakker" <postbus(a)sybrandb.demon.nl> wrote in message
news:o5v1d2dsuo673lvtr1eas0biqetradmfke(a)4ax.com...
> On Wed, 2 Aug 2006 14:14:02 -0500, "MParenteau"
> <michael.parenteau(a)unisys.com> wrote:
>
>>The odbc driver is SQORA32.DLL version 10.02.00.01 dated 9/30/2005.
>
> This looks like a *32* bit driver to me.
>
> --
> Sybrand Bakker, Senior Oracle DBA


 | 
Pages: 1
Prev: Oracle Designer: Connect string
Next: im004 oracle odbc error with unprivileged users