Failed to export and import data via "Teradata OleLoad"

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Failed to export and import data via...

Rate Topic

Display Mode

Topic Options

Author

Message

winnie

Posted 8/28/2008 12:40:24 AM

Forum Newbie

Group: Forum Members
Last Login: 8/28/2008 11:08:04 PM
Posts: 8, Visits: 39

Hi everyone,

Could you tell what's wrong with my Teradata server.
I got following error when i want to do import/export data from another Teradata server to my current Teradata server via "Teradata OleLoad"

error message:
Cannot open rowset from command because:[NCR][ODBC Teradata Dirver]Syntax error: Blank name in quotation marks

Following is my hosts file setting on the Teradata server:
127.0.0.1 l ocalhost
10.195.226.5 ASTDcop1
10.193.26.10 TerDcop1
10.193.26.10 TerminalServerName
10.195.226.5 SourceServerName

Could you please help me check what's wrong with my hosts file?

Thanks
Winnie

Post #12760

sudhansu

Posted 10/8/2008 1:36:34 AM

Forum Newbie

Group: Forum Members
Last Login: 10/8/2008 1:30:19 AM
Posts: 1, Visits: 1

There is nothing wrong in the Database/Utility.

The procedure for import/Export operation using OleLoad is:
1) select source and make successful connection.
2) select the desired source table.
3) Then select destination database.

Hope you will not get the same error message again.

--Sudhansu

Post #13073

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 11:45pm