| T O P I C R E V I E W |
| kcharney |
Posted - 02/28/2005 : 11:16:37
If I use the 9.02.00 Oracle ODBC drivers all my connects are fine - namely transfering of BLOB data.
As soon as I upgrade to the 9.02.05x drivers all my BLOB data fails.
Is there any not about this - apperently this driver adds a new Numeric setting to the ODBC panel.
Is there a recommended setting or patch that I can implement.
Any help would greatly be appreciated.
Client is XP with 9i client installed.
Server is Unix with 9i server installed.
Kurt
Flying by the seat of my pants always gives me a wedgie... |
| 6 L A T E S T R E P L I E S (Newest First) |
| askDDBC |
Posted - 03/02/2005 : 20:36:34
My bias is always to go with the latest version of the driver. While there is always the possibility that patchsets are going to introduce some sort of regression, the driver generally gets more stable over time.
Whether you go with the 9.2 or 10.1 series of drivers depends upon which version of the Oracle client you will be installing on the client machines. That, in turn, will generally depend upon what database versions you have in the organization. If all your databases are 9i or 10g, I would generally go with the 10g client. If you have a mix of earlier databases, I would probably stick to the 9.2 client.
askDDBC |
| kcharney |
Posted - 03/02/2005 : 16:23:13
Thanks.
That helps.
I have installed 9.2.0.54 and that driver works great in the exact same scenario.
We are going to be standardizing our next release on a set of drivers. Which would you recommend as the most stable for 9.2 and 10g respectively.
9.2.0.63 or 65 or other?
10.0.1.3 or other?...
Thanks so much for your help.
Kurt
Flying by the seat of my pants always gives me a wedgie... |
| askDDBC |
Posted - 03/02/2005 : 08:16:43
Are you passing the LOB's to a stored procedure? Or are you inserting them directly in the table? There were some bugs fixed in the 9.2.0.6.3 and 9.2.0.6.4 versions of the Oracle ODBC driver relating to passing more than 32k of data to and from stored procedures.
Are you getting any errors other than the ORA-00932 inconsistent data types error? It is certainly possible that the fix for Bug 3385352 in the 9.2.0.6 Oracle ODBC driver could be related to your problem.
The fastest approach will probably be to test the application with the latest Oracle ODBC driver (9.2.0.6.5 if you have the 9.2 Oracle client). If BLOB's work, you have pretty solid evidence that you can use to modify the environment standard. If you need to determine exactly which bug you are affected by, you would probably need to work with Oracle Support, which is probably going to be rather time-consuming.
askDDBC |
| kcharney |
Posted - 03/01/2005 : 15:56:47
I have noticed that the 9.2.6.0 driver has fixed a fix for the Error: inconsistent data types. This is something that we were experiencing.
Any ideas...
Flying by the seat of my pants always gives me a wedgie... |
| kcharney |
Posted - 02/28/2005 : 14:11:42
It occurs on the Select statement as well as the INsert statement.
When we use the Microsoft driver - all is well.
If we use the 9.02.00.00 client install all is well.
If we save using the Oracle 9.02.00.5x then it saves corrupted info.
If we query with it - it returns corrupted data.
Is this a known issue with this driver?
We have tried numerous configuration issues and narrowed it down to this driver.
The client has this as a Common Environment Standard - but if there is some documentation that this is an issue that has been experienend elsewhere and a newer driver like 63 fixes it - I believe I will be able to get them to update.
Thanks,
Kurt
Flying by the seat of my pants always gives me a wedgie... |
| askDDBC |
Posted - 02/28/2005 : 14:06:09
What error do you get when working with BLOB's and what are you doing at the time (i.e. INSERT, UPDATE, DELETE or SELECT)? If you know the specific ODBC command that is failing (or the specific ADO/ DAO/ RDO/ etc. call) that would be useful as well.
askDDBC |
