473,289 Members | 2,091 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Some more problems with exporting Access Table in Oracle

I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have
setup Oracle 9.2 ODBC Driver (I have not yet figured how to set
Microsoft's Oracle ODBC driver).

I am exporting a table from Access to Oracle and I get following error:

ODBC Call Failed:
ORA-12571: TNS Packet Failure Error

I see table and its indexes created in Oracle. However, there are no
rows populated.

I see there are CLOB columns created in Oracle Table (Memo of Access is
mapped to CLOB). Could CLOB be an issue?
How does one troubleshoot an error like this.

Thanks.

Prem

Nov 13 '05 #1
3 4031

pr**********@hotmail.com wrote:
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have
setup Oracle 9.2 ODBC Driver (I have not yet figured how to set
Microsoft's Oracle ODBC driver).

I am exporting a table from Access to Oracle and I get following error:
ODBC Call Failed:
ORA-12571: TNS Packet Failure Error

I see table and its indexes created in Oracle. However, there are no
rows populated.

I see there are CLOB columns created in Oracle Table (Memo of Access is mapped to CLOB). Could CLOB be an issue?
How does one troubleshoot an error like this.

Thanks.

Prem


More information:

have Microsoft Access 2000 and an Oracle database created from
9.2.0.1.
I am trying to export a table from Microsoft Access 2000 to Oracle.
I get error:
ODBC -- Call failed
[Oracle][ODBC][ORA-12571]: TNS:packet writer failure [#12571).

When I look in database it creates the table and indexes successfully
but no rows are exported?

I have verified connectivity through SQLPLUS and it works fine.

Also, in the same Oracle database instance I have tried to export
serveral tables from NothWind Database and they export without
any problems. These tables do contain Memo/Clob types.
Any ideas on how to troubleshoot the problem will be greatly
appreciated.
I don't know how to troubleshoot this error?

Nov 13 '05 #2
You must setup TNS Names in Oracle to recognize the Access Table.
Alternatively, create all the initial objects (tables included) in Oracle
and then "attach" the external Oracle tables you need.
Now, during an insert, update or delete, you are working with the actual
table in question.

<pr**********@hotmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have
setup Oracle 9.2 ODBC Driver (I have not yet figured how to set
Microsoft's Oracle ODBC driver).

I am exporting a table from Access to Oracle and I get following error:

ODBC Call Failed:
ORA-12571: TNS Packet Failure Error

I see table and its indexes created in Oracle. However, there are no
rows populated.

I see there are CLOB columns created in Oracle Table (Memo of Access is
mapped to CLOB). Could CLOB be an issue?
How does one troubleshoot an error like this.

Thanks.

Prem

Nov 13 '05 #3

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:UCVDd.29733$3m6.20015@attbi_s51...
You must setup TNS Names in Oracle to recognize the Access Table.
Alternatively, create all the initial objects (tables included) in Oracle
and then "attach" the external Oracle tables you need.
Now, during an insert, update or delete, you are working with the actual
table in question.


Chuck, this guy multi posted his question. He has already received a number
of replies in another newsgroup.
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Markku Uttula | last post by:
I think I'm doing something wrong. I'm able to connect to Oracle just fine, execute queries and all, but I'm having serious problems with the speed :( For example, the following PHP-script on my...
0
by: HARI OM | last post by:
I would like to EXPORT the DATABASE INSTANCE Named "GATES" and execute following: ----------------------------------------------------------- ../exp Username: system Password: **** Export File:...
1
by: steve | last post by:
hi, during a full export of my export of a (Release 9.2.0.4.0 - Production ) database i'm getting the following: I have been thru metalink, and can find nothing that is exactly the same, even...
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
2
by: neptune | last post by:
I currently link a table to an Oracle db. Anytime I open a query based off it, I have to input username & password. Is there a way to do this automatically? I'd prefer to use linked tables,...
0
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because...
5
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because...
1
by: palani12kumar | last post by:
Hi everybody. I'm in trouble in exporting a table from the Access to Oracle. I've created a table in Access and inserted nearly 20 records in that. Then i tried to move that into Oracle using the...
2
by: jim | last post by:
I have an access 2003 database and i was having a few problems with it- for instance every time i tried a compact and repair, access would crash out - I tried exporting each table to a new database...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.