Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Loading data into Progress OpenEdge Database

Loading data into Progress OpenEdge Database 10 years 1 month ago #615

  • AlexF
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
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

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

Re:Loading data into Progress OpenEdge Database 10 years 1 month ago #617

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
Try setting \"use widechar tick box\" for Progress ODBC Connection
Mike

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

Re:Loading data into Progress OpenEdge Database 1 year 2 months ago #17645

worked perfect, thank you
await the license requirements
thank you

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

Loading data into Progress OpenEdge Database 1 year 2 months ago #17650

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

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

  • Page:
  • 1

We have 148 guests and no members online