Loading data into Progress OpenEdge Database

  • Posts: 1
  • Thank you received: 0

Loading data into Progress OpenEdge Database was created by AlexF

Hello.

I am trying to load data into Progress OpenEdge Database via ODBC and I am getting following Error message see the log below

Any suggestions?

Information 08/04/2009 20:17:30 Starting...
Information 08/04/2009 20:17:30 Target Table: TEST.PUB.wIMPORTER_A2B
Information 08/04/2009 20:17:30 Trasnformation Type: ADD Records
Information 08/04/2009 20:17:32 Found: 1 File(s) to read
Information 08/04/2009 20:17:32 Path: C:\Program Files\DB Software Laboratory\Demo\Text Files\
Information 08/04/2009 20:17:32 Mask: Orders.csv
Information 08/04/2009 20:17:32 Source File: C:\Program Files\DB Software Laboratory\Demo\Text Files\Orders.csv
Error 08/04/2009 20:17:32 Insert failed: HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.
Error 08/04/2009 20:17:32 Insert failed: HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.
Error 08/04/2009 20:17:32 Insert failed: HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.
Error 08/04/2009 20:17:32 Insert failed: HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.

Alex Friday
12 years 3 months ago #615

Please Log in or Create an account to join the conversation.

  • Posts: 8266
  • Karma: 33
  • Thank you received: 539

Replied by admin on topic Re:Loading data into Progress OpenEdge Database

Try setting \"use widechar tick box\" for Progress ODBC Connection
Mike
ETL Architect
12 years 3 months ago #617

Please Log in or Create an account to join the conversation.

  • Posts: 278
  • Karma: 2
  • Thank you received: 3

Replied by alanwjackson on topic Re:Loading data into Progress OpenEdge Database

worked perfect, thank you
await the license requirements
thank you
3 years 4 months ago #17645

Please Log in or Create an account to join the conversation.

  • Posts: 159
  • Thank you received: 17

Replied by Maria on topic Loading data into Progress OpenEdge Database

Hello

We would like to create a wiki article about the issue you had
Is there any chance you can post screenshots of ODBC driver settings so we can use it in wiki article

Thank you
3 years 4 months ago #17650

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies