Oracle Data Type not supported

Question

Oracle Data Type not supported

uanu

SSC-Addicted

Points: 439
More actions
October 10, 2002 at 3:42 pm

#173554

I am trying to import a table into SQLSERVER2000 from Oracle.
One of the field in that table has a data type "CLOB". Because of which I am getting the following error message
"Error Source:Microsoft OLEDB Provider for Oracle
Error Description:Unspecified Error
Oracle error occured,but error message could not be retrieved from oracle.
Data type is not supported.
Context: Error calling OpenRowset on the provider."

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

You will need to change instead to using the Oracle OLEDB provider instead. Microsoft quit making updates to the MS version and thus some datatypes are not supported by the OLEDB driver itself.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

uanu SSC-Addicted Points: 439 More actions · Answer 2

Thanks! for the reply.

But how do I change to ORACLE OLEDB provider?

Can you please specify step by step process to change to ORACLE OLEDB Provider?

Thanks,

uanu SSC-Addicted Points: 439 More actions · Answer 3

Thanks! for the reply.

But how do I change to ORACLE OLEDB provider?

Can you please specify step by step process to change to ORACLE OLEDB Provider?

Thanks,

uanu SSC-Addicted Points: 439 More actions · Answer 4

I selected "Other Data Source" in Data Source pull down menu and then in User/System DSN I pointed to existing System DSN that points to the data source (Driver is Oracle ODBC driver) Actually I am getting an error

"Error at source for row number 1"

Antares686 SSC Guru Points: 125444 More actions · Answer 5

Don't knwo for sure and cannot trouble shoot today but may still contain something unsupported, try the connection the SQL PLUS and see if you get the data or an error. If the error occurrs in SQL PLUS you may need to update the ORACLE client. If not then try utilizing the OLEDB Provider for ORACLE, I believe is the way it lists, you may need to do a client update to add that item to your current install.

If you need help with the install, I remember posting the details on this in the forums previously. Try to find, if not let me know and when I have a chance I will take a look.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)