Unable to migrate data from Access source to Oracle destination

hi
I have migrated the Access 2003 database to Oracle 10g database by Oracle work

bench.
Actually i am using the platform is Microsoft Windows Server 2003 for migaration.

and i have configured OMWB with Access Plugins in Windows sever 2003.

Basically i have converted the Access database to XML file. then the oracle table

model is created. but the data's are not migrated to oracle table.

while am migrating to oracle. It's shows the following error message.

Database Name is oracle_migrate and the Table Name is amt_subj_tbl.

Unable to migrate data from source table "amt_subj_tbl" to destination table
oracle_migrate.AMT_SUBJ_TBL : oracle_migrate.AMT_SUBJ_TBL;[Microsoft][ODBC Microsoft Access Driver]"(Unknown)" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides

Please anyone give me a Solutions as soon as Possible.

Thanks

Jan 25 '07 #1

Subscribe Post Reply

1130

by: Phil Powell | last post by:

I've read some online resources that utilize various MySQL command-line actions to migrate data from Access to MySQL. The situation is this: a...

PHP

Writing a db independent data access layer with DAAB:How?

by: sedefo | last post by:

I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer....

.NET Framework

"HOW TO MIGRATE THE MS-ACCESS TABLE TO ORACLE DATA BASE TABLES"

by: narasingarao | last post by:

Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle...

Microsoft Access / VBA

Export Access Data to Oracle

by: Andrew Arace | last post by:

I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in...

Microsoft Access / VBA

Is this a valid data structure??

by: Dan | last post by:

I'm trying to creat a data structure, that can be either a integer, double, string, or linked list. So I created the following, but don't know if...

C / C++

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr

by: bazzer | last post by:

hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i...

ASP.NET

Unable to migrate data from Access source to Oracle destination

by: phpmaet | last post by:

hi I have migrated the Access 2003 database to Oracle 10g database by Oracle workbench. Actually i am using the platform is Microsoft Windows Server...

Oracle Database

Unable to initialize OraOLEDB from SQL Server 2005 x64 to Oracle

by: Mark D Powell | last post by:

I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The developer said that he needed to use OLE to talk to Oracle so I went to Oracle and...

Microsoft SQL Server

"XML Source" (108) was unable to read the XML data.

by: wildman | last post by:

Trying to read XML files from SSIS and load into SQL Server. I tested this before and it was working before I placed in a forevery contrainer....

.NET Framework

How to Remove Duplicate Items from ComboBox in JavaFX?

by: tammygombez | last post by:

Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....

Java

Tips for Saving Money on Buying a Gaming Laptop

by: tammygombez | last post by:

Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...

Computer Hardware

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

How to minimize a tool bar that shows up when in reports

by: CD Tom | last post by:

This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...

General

how to collapse a custom toolbar in VBA

by: CD Tom | last post by:

This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General

Unable to migrate data from Access source to Oracle destination

Similar topics