Home » RDBMS Server » Networking and Gateways » ODBC Connection returning all fields as string
ODBC Connection returning all fields as string [message #66401] Wed, 22 May 2002 13:38 Go to next message
Mary Clements
Messages: 1
Registered: May 2002
Junior Member
I am connecting to an Oracle database through an ODBC connection using the Oracle ODBC driver version 8.01.07.00.

Once connected and schema is established, in preparing my sql statement and result set all columns available to me are set to field type character regardless of what they are in the actual database, i.e. numeric fields in the database are available to me as only string fields.

I'm not sure if this is on the database (Oracle) end or my application that polling via ODBC (Gentran) end.

Any insight would be greatly appreciated.

-Mary
Re: ODBC Connection returning all fields as string [message #66404 is a reply to message #66401] Fri, 24 May 2002 00:31 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

I THINK PROBLEM NOT IN THE ORACLE DATABASE.PROBLEM IN YOUR APPLICATION PART.PLEASE CHECK IT OUT.

K.SREENIVASAN
Previous Topic: Re: Trouble Installing Oracle8i 8.1.6 and 8.1.7 on Windows2000
Next Topic: OMS service start problem
Goto Forum:
  


Current Time: Wed Feb 28 04:51:46 CST 2024