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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 02:54:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.