Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > comp.databases.pick > #2216

Re: UPS Worldship

Show all headers | View raw

On Jan 27, 11:55 am, Specific <domp...@gmail.com> wrote:
> On Jan 27, 10:01 am, sh <sham...@prupipe.com> wrote:
>
>
>
> > On 1/25/2011 11:31 AM, Specific wrote:
>
> > > I've created a Keyed Import to bring in shipment information from our
> > > D3 database.  It works great, however, after a few days I've noticed
> > > that the user associated with worldship is logged on 3+ ports.  A
> > > wheres on the user shows that the last command executed was exit for
> > > all the lines.
>
> > > Does worldship normally take so many lines or am is worldship not
> > > closing the connections properly?
>
> > How are you feeding the D3 data into WorldShip? I do so via a VB
> > (actually VB6) program using RPC that feeds the data into my own .mdb
> > which is then imported into WorldShip.
>
> > Tony's answer is necessary, but I have also found that D3 doesn't always
> > logoff the first time you issue a Logoff command. So I do it twice, and
> > that seems to work. I do the following:
>
> > Private Sub Logoff()
> >      Call D3VME.brLogoff
> >      On Error Resume Next
> >      Call D3VME.brLogoff
> >      Call D3Domain.brCloseVirtualMachine(D3VME)
> >      Call D3Env.brCloseDomain(D3Domain)
> >      Set D3VME = Nothing
> >      Set D3Domain = Nothing
> >      Set D3Env = Nothing
> > End Sub
>
> > Hope this helps.
>
> > Sholom
>
> We created a view table for orders in d3 and use Worldship's key
> mapping to import via ODBC.  The tigerlogic C27 ODBC driver was
> installed on the worldship computer, and we created a system odbc data
> source that connects to the server.  The person running shipments
> simply types in the invoice number and it will grab all the shipment
> information for them.

I tired to  turn DCD-ON manually (although its already in the user
item) for the port and this is what I get back:
:dcd-on 256
dcd: Cannot reprogram '00030100'. [-001] Undetermined error

Back to comp.databases.pick | Previous | Next | Find similar

Thread

Re: UPS Worldship Specific <dompier@gmail.com> - 2011-01-27 11:39 -0800

csiph-web