Subject Re: oddc drivers
From Charlie <tm@tc.com>
Date Sun, 24 Nov 2019 17:11:29 -0500
Newsgroups dbase.getting-started

Hi Rich.. Yes it is 32 bid and level 7.  By install the bde are you referring to bde administrator?  I have that but am fuzzy on how I use it is that is what you are talking about.

Thanks...

<rich@autotraker.com> Wrote:

> If the BDE is installed and you are using the 32-bit ODBC, the regular
> "Microsoft dBASE Driver (*.dbf)" will read level 7 tables.
> We do it all the time. I have several 3rd party vendors that need access to
> our level 7 tables via ODBC.
> I just install the BDE and setup the ODBC and it works fine. The 32-bit
> Microsoft ODBC driver will use the BDE to read level 7 tables as long as it
> can find idapi.dll
> I can open my level 7 tables in Open Office and several other applications
> using ODBC the same way.
>
> If you create level 5 tables and as long as you stick to the rules for level
> 5 and don't modify the tables from within dBASE, they will stay level 5 even
> if you have your BDE set for level 7.
> I have a couple level 5 tables I use on a regular basis for export for a
> couple vendors who can't handle level 7 tables and as long as I only
> read/write data to them they remain level 5.
> There is also a couple utilities in the dUFLP that will copy/convert level 7
> tables to level 5.
>
> The nice thing about dBASE is there are plenty of workarounds.
> Rich...
>
>
>
> "Charlie"  wrote in message news:CkiDBXvoVHA.2332@ip-AC1E04A7...
>
> Hi Rich.. Thanks very much for your info.  I had changed the dbf levels to 7
> which if I read correctly won't allow me to do this.  No big deal though!
>
> Thanks again!!
>
> rich@autotraker.com> Wrote:
>
> > If I remember correctly, its been some years since I looked at it but the
> > FedEx ship manager can read/write to any ODBC file source.
> > You just need to tell the FedEx ship manager the DSN name and I think the
> > table name.
> > It all depends on if the FedEx program is 32-bit or 64-bit. (I don't
> > recall
> > which it was.)
> > If itís a 32-bit program you go to the 32-bit ODBC manager and point that
> > to
> > your database.
> > You should be able to test if it works from dBASE.
> > Same if itís a 64-bit program only you will not be able to test it from
> > dBASE since dBASE is only 32-bit.
> > In both cases you want to use the "Microsoft dBASE Driver (*.dbf)" driver.
> > The driver may not be installed by default depending on your OS and if its
> > 32-bit or 64-bit.
> > That's about the extent of help I can be. I started doing the integration
> > but never finished. it was just more work than I wanted to do for the few
> > shipments we made per month.
> > I'm sure there are others here with more knowledge about setting up ODBC
> > for
> > dbf tables.
> > Rich....
> >
> >
> >
> >
> > "Charlie"  wrote in message news:M#1D93joVHA.1880@ip-AC1E04A7...
> >
> > Hi.. I am using dbase11 and it should connect in 32bit.  Basically the
> > fedex
> > tech guy was trying to set it up so we could sync with their tracking
> > numbers directly in my dbase forms.  Not sure if this is possible.  But
> > the
> > tech mentioned I have to configure somehow so that I can see the .dbf
> > files
> > on my computer through oddc.  Possibly I heard him wrong but I thought he
> > said oddc??
> >
> > This is not essential.  I guess I am more curious about it than anything.
> >
> > Thanks!!
> >
> > <rich@autotraker.com> Wrote:
> >
> > > I use just the standard driver
> > > "Microsoft dBASE Driver (*.dbf)"
> > > It will handle up to a level 5 dbf tables.
> > > There is no ODBC driver for level 7 that I know of.
> > > However if you use the level 5 driver and have the BDE installed, it can
> > > read/write level 7 tables
> > > You didn't mention what "just didn't work". I haven't had any luck with
> > > 64-bit drivers if that's what you are working with.
> > > Rich...
> > >
> > >
> > >
> > > "Charlie"  wrote in message news:aTce7SXoVHA.2332@ip-AC1E04A7...
> > >
> > > Hi.... I am trying to get the windows oddc drivers set up for dbase.
> > > When
> > > trying to configure all that showed up on microsoft was III to IV which
> > > didn't work.  I have no idea what I am talking about here as this came
> > > up
> > > out of the blue trying to hook up directly through a fed-ex program.
> > > Does
> > > anyone have any ideas on this, or where I can get the correct info?
> > > Thanks
> > > much....
> > >