November 4, 2003 at 2:40 pm
Hi All,
I am trying to export tables with data from the SQL
Server 2000 to Oracle 9i using a SQL to Oracle ODBC
driver. (Microsoft OLE DB Provider for ODBC Drivers)
I using the export option in the Enterprise manager to
do the same.
Using the export option, i was able to migrate the table with data for few tables.
The Dts package of the export wizard first creates the table in oracle and then migrates data into it.
During such an export, two tables out of 20 failed to migrate
saying that there is an EXCEPTION_ACCESS_VIOLATION
The below is the exact description of the error message that i am getting
"Need to run the object to perform this operation"
"Code excecution exception: EXCEPTION_ACCESS_VIOLATION"
and the export of the table data failed, though the
tables got created in the Oracle.
Any pointers as to why this is happening?
Thanks for your time and help,
-Sathish
November 4, 2003 at 5:59 pm
can you tell us what service pack you are on sql and windows wise and the MDAC version you are using as well. I don't know anything off the top of my head that would cause the access violation but that info would help start the search.
Wes
November 4, 2003 at 7:00 pm
Thank you for the response
The microsoft windows 2000 machine from where i am using the enterprise manager is having service pack 4 and my MDAC version number is 2.70.7713.4
Sql server is also at service pack 4
Thanks,
-Sathish
quote:
can you tell us what service pack you are on sql and windows wise and the MDAC version you are using as well. I don't know anything off the top of my head that would cause the access violation but that info would help start the search.Wes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply