Groups | Search | Server Info | Login | Register

Groups > comp.databases.pick > #2265

Re: UPS Worldship

Show all headers | View raw

On Jan 27, 2:57 pm, sh <sham...@prupipe.com> wrote:
> On 1/27/2011 1:55 PM, Specific 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'm not sure the D3 ODBC driver was/is totally reliable. IIRC, there
> were lots of problems with it. Has it been "refreshed" lately by TL?

I use the same driver on a web server to pull information from the
database (thousands of requests per day), and I never see it holding
up lines.  You're lucky if you can even catch a glimpse of it on at
all.

Looking at the lines in "wheres" shows px.resume and tcl1, does that
mean that it could be stuck in shell?

Back to comp.databases.pick | Previous | Next — Previous in thread | Find similar

Thread

Re: UPS Worldship sh <shamada@prupipe.com> - 2011-01-27 16:57 -0500
  Re: UPS Worldship Specific <dompier@gmail.com> - 2011-01-27 14:30 -0800

csiph-web