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.... > > >