Groups | Search | Server Info | Login | Register

Groups > comp.databases.pick > #2248

Re: UPS Worldship

Show all headers | 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

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