Path: csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!74.125.46.80.MISMATCH!postnews.google.com!news2.google.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 27 Jan 2011 15:57:57 -0600 Date: Thu, 27 Jan 2011 16:57:57 -0500 From: sh User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7 ThunderBrowse/3.3.4 MIME-Version: 1.0 Newsgroups: comp.databases.pick Subject: Re: UPS Worldship References: <7387a459-cf32-4b11-8040-bf58415b736d@k9g2000yqi.googlegroups.com> In-Reply-To: <7387a459-cf32-4b11-8040-bf58415b736d@k9g2000yqi.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Lines: 45 X-Usenet-Provider: http://www.giganews.com NNTP-Posting-Host: 75.150.150.173 X-Trace: sv3-PvVEl/lv0evjZHrSLwKYVnbkXn5wKYP5iN4rPQYM2h3MOpT6vEDrH35Xt4y0goxQRczUPck8sxkbkVB!fyM0YvHVtxNpkU32SqGCKC0//8ZiBRvR7E55yC56AzulTvkjzRxBBLd0Js3KsJufsEcP4mZZg4so!+112F+O4pyd2jm5kmY7oU0PVjp5ggLs6jA== X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Bytes: 3198 Xref: csiph.com comp.databases.pick:2248 On 1/27/2011 1:55 PM, Specific wrote: > On Jan 27, 10:01 am, sh 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?