Subject Re: oddc drivers From <rich@autotraker.com> <<rich@autotraker.com>> Date Mon, 25 Nov 2019 14:05:16 -0500 Newsgroups dbase.getting-started The BDE Administrator is just a user interface to the BDE. But yes, if you have the BDE Administrator installed, then you have the BDE installed. The BDE is what makes the difference between the "Microsoft dBASE Driver (*.dbf)"  being able to read Level 7 tables or not. On my local server I needed to give a 3rd party program the abilities to access my level 7 tables. I installed the BDE by installing the dBASE runtime then the 3rd party software was able to read my level 7 tables using ODBC. Without the BDE the ODBC driver can only read up to level 5 tables. Rich... "Charlie"  wrote in message news:0q$cfQxoVHA.1880@ip-AC1E04A7... 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.... > > >