Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    7

    Unanswered: UPS worldship and unidata

    Has anyone been able to get ups online worldship to import/export data from a unidata database using odbc? I'm on a win2k client. I can get worldship to see the tables in an odbc source that I have setup but when I try the import I get ODBC error 00000. I've tried putting this through UPS but they haven't been too helpful yet.

    Thanks in advance for any help...

    - Rob

  2. #2
    Join Date
    Jul 2002
    Posts
    7

    Cool I got the import working

    In case anyone else runs into this problem (as UPS tech support was very unhelpful), I got the address import working (I'm working on the export now).

    We have sql server running so I created a linked server in sql server (ibm u2connect had an article on this) using the unioledb driver. I then created a view in sql server to point to that linked server (SELECT * FROM MYSERVER...CUSTNF_NF) . I then had to create an ODBC source to sql server and when I was in UPS worldship, I created a map off of the view and it worked. I imported about 15k records in a batch import.

    - Rob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •