A long time ago in a company far, far away :-), I set up UPS WorldShip
to use an A97 query to provide up-to-date shipping label addresses
using a Data Source Name (DSN) created via the ODBC Administrator.
Now the shipping department at a different company that uses my
BillOfLading database would like to be able to have the main form
populate fields using the addresses that are stored locally within UPS
WorldShip. The business addresses from tblAccounts had to be adjusted
for things like loading docks, and the new information, including
multiple shipping addresses, was simply added as required to UPS
WorldShip. The shipping department has also grown accustomed to using
the UPS Worldship interface. It seems unnecessary to move all the
WorldShip data into an Access backend. So using Access to pull the
data from UPS WorldShip is where I'm headed. The recommendation in the
UPS WorldShip possibly out-of-date help file is again to use an ODBC
DSN. Is it possible to set up a DSN-less connection to the UPS
WorldShip data instead? The shipping department uses a single computer
for UPS WorldShip so a solution that uses any version of Access would
work since only a single upgrade would be required. Plus, for a single
computer, even using the ODBC DSN isn't that bad of an option if
necessary. I wanted to see if anyone here has done it before
contacting UPS.
James A. Fortune 6 5307
What type of database does UPS use?
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
<ji********@com pumarc.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. . A long time ago in a company far, far away :-), I set up UPS WorldShip to use an A97 query to provide up-to-date shipping label addresses using a Data Source Name (DSN) created via the ODBC Administrator. Now the shipping department at a different company that uses my BillOfLading database would like to be able to have the main form populate fields using the addresses that are stored locally within UPS WorldShip. The business addresses from tblAccounts had to be adjusted for things like loading docks, and the new information, including multiple shipping addresses, was simply added as required to UPS WorldShip. The shipping department has also grown accustomed to using the UPS Worldship interface. It seems unnecessary to move all the WorldShip data into an Access backend. So using Access to pull the data from UPS WorldShip is where I'm headed. The recommendation in the UPS WorldShip possibly out-of-date help file is again to use an ODBC DSN. Is it possible to set up a DSN-less connection to the UPS WorldShip data instead? The shipping department uses a single computer for UPS WorldShip so a solution that uses any version of Access would work since only a single upgrade would be required. Plus, for a single computer, even using the ODBC DSN isn't that bad of an option if necessary. I wanted to see if anyone here has done it before contacting UPS.
James A. Fortune
Douglas J. Steele wrote: What type of database does UPS use?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
Thanks Doug,
That was the right question. I found some .CSV files and some A2K mdb
files in the WorldShip folders. I'll poke around until I find the
address info and just link to the CSV file or Access table, after
upgrading the A97 version if the addresses are found in an A2K table.
James A. Fortune
The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format,
and it is in this file that all address information is stored. It will not
be possible for you to extract the address data from upsdb.mdb into your A97
format database, either directly or by DSN/DSN-less connection. You will
need to upgrade your A97 database to A2K.
<ji********@com pumarc.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . Douglas J. Steele wrote: What type of database does UPS use?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
Thanks Doug,
That was the right question. I found some .CSV files and some A2K mdb files in the WorldShip folders. I'll poke around until I find the address info and just link to the CSV file or Access table, after upgrading the A97 version if the addresses are found in an A2K table.
James A. Fortune
ByteMyzer wrote: The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format, and it is in this file that all address information is stored. It will not be possible for you to extract the address data from upsdb.mdb into your A97 format database, either directly or by DSN/DSN-less connection. You will need to upgrade your A97 database to A2K.
How about this idea: Back up the entire WorldShip directory first,
copy the A2K upsdb.mdb file across the network to a machine with A2K,
export the file as Tab delimited back across the network as upsdb.csv,
then import into A97 to replace the A2K upsdb.mdb file in the WorldShip
directory with an equivalent A97 upsdb.mdb.
Has anyone ever tried anything like this?
James A. Fortune
ByteMyzer wrote: The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format,
That file may be the main backend, but it didn't seem to have the
addresses I'm searching for. I'll keep looking.
James A. Fortune
I don't know if I had the right upsdb.mdb before but I found the
addresses I need in an upsdb.mdb file. The table name was something
like calPkgAgent. Thanks.
James A. Fortune This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Leader |
last post by:
HI All,
I created a SQL Server DSN using Windows ODBC Data Source
Administrator. While creating the DSN, it asked me about
authentication process in reply to which I selected "With SQL Server
authentication using a login ID and password entered by the user." and
then gave my SQL Server login ID and password. After following the
regular...
|
by: kakaz |
last post by:
Hi All there!
I am quite new in MS SQL administration so let me explain how it work
on Your instances of SQL Servers.
We have several DTS packages on our server, all of them managed on
some station which have seriously hardvare problem. So we wolud like
to catch two problems at one time and decided to develop systematic
way of DTS...
|
by: McCool |
last post by:
How can I get the deployment project to setup a DSN pointing to an Access DB
after installation takes place?
Also, is there a way to kick off a vbs script after installation takes place
through the deployment project?
TIA
Brian
|
by: emily |
last post by:
Perhaps this has already been answered. If so, I apologize. I'm a
newbie at this stuff. I have a DTS package to import some Visual
Foxpro data. Yes, I said Visual Foxpro. :) The DTS package works
beautifully when I rightclick on the package and choose "execute." And
it works beautifully when I run dtsrun.... at the DOS prompt. But it...
|
by: Dan |
last post by:
Hi I have recently converted an Access 97 database to 2003. Most of
the change went fine with no problems but every now and then my DSN
connections to my back-end SQL-database fail and it does not allow me
to add new records to the table anymore. I have to delete the tables
and re-link them to get it working again. Does anyone know why this...
| |
by: Zlatko Matiæ |
last post by:
Hi!
What happens with linked tables if they were linked using File DSN, when I
copy the Access file on some other PC without File DSN ?
What is the difference between DSN on linked tables and pass-through queries
? Why I can change DSN for pass-through query and can't change it for linked
table, in Properties dialog box ?
Zlatko
|
by: Steve Sweales |
last post by:
I'm trying to find some code on how to create a DSN using C# and
SQLConfigDataSource.
Can anybody help me please, before I tear my hair out!!
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|
by: Niks |
last post by:
Hi,
I need to connect to SQL server Database using a System DSN. Can
anyone tell me how to connect to SQL Server using DSN in ASP.NET
(VB.Net). Using a Try Catch block.
Does anyone know how to create a "filename.DSN" file. I know how to
create a system DSN, but my N/W admin has asked me to create a DSN
file to send him. which would be a...
|
by: senthildb2 |
last post by:
Hi there,
I want to create DSN for DB2 database through my VB application.
I have installed DB2 v8.2 with FixPack6.0 ESE.
(The actual version shown in Control Center is DB2 V8.1.13.193)
The problem is that VB application crashes without reporting any error. DSN is not getting created.
But I am able to create DSN through Control Panel.
...
|
by: bytesbytes |
last post by:
Hi,
Im using VB6.0, Crystal report 10 and MSaccess Database. I was using Crystal report 6 and later upgraded to CR10. In VB6 i used DSN like
.Connect = "DSN=DBName" & ";UID=admin;PWD=;"
Now in CR10 i have created reports without using DSN in VB. Can any help how to use DSN in VB6.0 with CR10 or is there any method so that i no need to use DSN...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |