cholman
asked on
ora-24508 exporting data from access to oracle via odbc
An export from Access 2007 to Oracle 10.2.0.4 using the Oracle ODBC driver is failing with ORA-24508: Buffer is not aligned correctly. There are no unusual datatypes in the source table. I've tried it with Oracle databases using both WE8MSWIN1252 and UTF8 character sets. Both give the same error.
Can anyone suggest a solution?
Thanks.
Can anyone suggest a solution?
Thanks.
ASKER
Oracle is actually an 11.2 db on a remote Linux RAC cluster. I've also tried a 10.2.0.3 database on the same RAC cluster. ODBC client is 10.1.0.1. I"ve tried 11.1, but can't get that to work either, but with a different error message. I don't see my problem(s) in the metalink note.
At the moment I'm trying a different path. I've set up my Oracle table as a linked table in Access, and I'm running a query to insert the Access data into the Oracle table. It works for numeric data but not for varchar2 data or date data. I'll try redefining my Oracle table and see if that fixes it.
Meanwhile, if anyone has any light to shed on the situation, I'd be most grateful. Thanks.
At the moment I'm trying a different path. I've set up my Oracle table as a linked table in Access, and I'm running a query to insert the Access data into the Oracle table. It works for numeric data but not for varchar2 data or date data. I'll try redefining my Oracle table and see if that fixes it.
Meanwhile, if anyone has any light to shed on the situation, I'd be most grateful. Thanks.
>>ODBC client is 10.1.0.1.
>>I don't see my problem(s) in the metalink note
That note references a bug in 10.1.0.1. Down at the bottom: Patch 4443765.
>> but can't get that to work either, but with a different error message.
What error message?
>>I don't see my problem(s) in the metalink note
That note references a bug in 10.1.0.1. Down at the bottom: Patch 4443765.
>> but can't get that to work either, but with a different error message.
What error message?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>My work-around is going to work.
Glad you found a solution.
You can 'Request Attention' using the link above to have your post accepted as the correct answer. I have no objection to that.
Glad you found a solution.
You can 'Request Attention' using the link above to have your post accepted as the correct answer. I have no objection to that.
ASKER
Thanks.
Can I assume the Oracle db is on a remote server and you have a client installed locally?
What version of ODBC are you using? There's a few bugs showing up on Metalink: Doc ID 392473.1.