Home » Open Source » Programming Interfaces » -2147467259 : Data type is not supported (Oracle 11g, Windows Vista)
-2147467259 : Data type is not supported [message #413637] Thu, 16 July 2009 18:41 Go to next message
yakshasa
Messages: 3
Registered: July 2009
Junior Member
Can't figure what is wrong with this statement.

Run from VB6 program code using ADO it is getting "-2147467259 : Data type is not supported", but it returns rows when cut and pasted into Oracle SQL Developer.

Do you have any suggestions?

SELECT * FROM TableHISTLoanPayments WHERE
sv_LoanNumber = 'ORACLE03' AND
sv_CoNumber = '01'

ORDER BY si_RecordID
Re: -2147467259 : Data type is not supported [message #413638 is a reply to message #413637] Thu, 16 July 2009 18:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC TableHISTLoanPayments

or post DDL to make TableHISTLoanPayments
in other words what are columns & datatypes that make up this table?

I suspect this is an ADO error & not an Oracle problem

[Updated on: Thu, 16 July 2009 18:56]

Report message to a moderator

Re: -2147467259 : Data type is not supported [message #413657 is a reply to message #413637] Thu, 16 July 2009 23:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your code but before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals) to both server and client as well as ADO driver and version.

Regards
Michel
Re: -2147467259 : Data type is not supported [message #413776 is a reply to message #413638] Fri, 17 July 2009 11:22 Go to previous messageGo to next message
yakshasa
Messages: 3
Registered: July 2009
Junior Member
These are the 3 pertinent column descriptions:

SI_RECORDID NOT NULL NUMBER(11)
SV_CONUMBER NOT NULL VARCHAR2(2 CHAR)
SV_LOANNUMBER NOT NULL VARCHAR2(8 CHAR)

Oracle 11g, OS = Vista, Provider=MSDAORA.1

[Updated on: Fri, 17 July 2009 11:26]

Report message to a moderator

Re: -2147467259 : Data type is not supported [message #413780 is a reply to message #413776] Fri, 17 July 2009 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Insufficient data to compute.

Regards
Michel
Re: -2147467259 : Data type is not supported [message #413852 is a reply to message #413780] Fri, 17 July 2009 17:07 Go to previous messageGo to next message
yakshasa
Messages: 3
Registered: July 2009
Junior Member
Thanks everyone for you input Smile

Turns out the Solution was to switch to the native Oraoledb.oracle provider instead of MSDAORA.
Re: -2147467259 : Data type is not supported [message #413886 is a reply to message #413852] Sat, 18 July 2009 01:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: Oracle Lite 10g c# and ODBC
Next Topic: Unable to connect DB through Perl
Goto Forum:
  


Current Time: Fri Mar 29 01:04:36 CDT 2024