Groups | Search | Server Info | Login | Register
Groups > comp.databases.pick > #2248
| 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 <shamada@prupipe.com> |
| 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 | <cf7223ef-26e0-4ed9-8b74-074005d9f784@i22g2000prd.googlegroups.com> <Vt-dnYkCLZNEOdzQnZ2dnUVZ_t2dnZ2d@earthlink.com> <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 | <vKCdnSpvBY_4d9zQnZ2dnUVZ_jOdnZ2d@earthlink.com> (permalink) |
| 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 |
Show key headers only | View raw
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?
Back to comp.databases.pick | Previous | Next — Next in thread | Find similar
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