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.
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.