OraFAQ Forum: Open Database Interfaces » -2147467259 : Data type is not supported

Members

Help

Home

Home » Developer & Programmer » Open Database Interfaces » -2147467259 : Data type is not supported (Oracle 11g, Windows Vista)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

-2147467259 : Data type is not supported [message #413637]

Thu, 16 July 2009 18:41

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

Report message to a moderator

Re: -2147467259 : Data type is not supported [message #413638 is a reply to message #413637]

Thu, 16 July 2009 18:56

BlackSwan
Messages: 3358
Registered: January 2009

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

Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

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

Report message to a moderator

Re: -2147467259 : Data type is not supported [message #413776 is a reply to message #413638]

Fri, 17 July 2009 11:22

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