Re: ODBC
- From: Kevin Powick <kpowick@xxxxxxxxx>
- Date: Thu, 18 Dec 2008 19:16:03 -0800 (PST)
On Dec 18, 7:26 pm, "Chris A. Kusmierz" <ckusmi...@xxxxxxxxxxx> wrote:
I have a downstream system which needs to update some PICK files from a MS
Access application. How can I access and update PICK files from VBA? I tried
to setup an ODBC Data Source
You can easily connect your D3/NT system to "downstream" systems via
the D3ODBC provider and VBA. I wouldn't used D3's ODBC provider to do
actual ODBC/SQL data transfers, but rather use it to call subroutines
on the D3 box to provide the data you require to your VBA-enabled
application.
You'll need the D3ODBC client library files on your workstation and
add it to the "References" section of your VB/VBA application. You'll
also need the ODBC driver set up correctly. In addition to allowing
you to Call subroutines, there are a bunch of helper functions that
allow you to deal with D3 dynamic arrays within VBA (insert, replace,
delete, locate, etc).
It is a powerful combination that gives you a very nice way to move
and work with data between systems.
I am unsure of the parameters needed to
setup the connection. Namely, what user names and passwords map to the
equivilants in PICK?
The driver configuration is pretty straight forward. The User ID/Pass
Account ID/Pass are the same as if you were logging on via a
terminal. Once an application connects to D3 via the ODBC dirver,
you'll see that user logged on (LISTU) as defined by the driver set-
up.
The only part that might seem odd is:
Host = server name
Port = 1603 (usually)
Virtual Machine = server name
--
Kevin Powick
.
- References:
- ODBC
- From: Chris A. Kusmierz
- ODBC
- Prev by Date: Re: Broke my heart
- Next by Date: Re: What problems are people in the MV world trying to solve
- Previous by thread: ODBC
- Next by thread: Re: ODBC
- Index(es):
Relevant Pages
|
