Subject Re: oddc drivers From <rich@autotraker.com> <<rich@autotraker.com>> Date Sun, 24 Nov 2019 16:17:22 -0500 Newsgroups dbase.getting-started 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.... > >