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

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