Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Pervasivite

  1. Pervasivite

    [Pervasive][ODBC Client Interface] Driver unable to load translate DLL

    First, you should check to see if your installation is patched up to SP3 and SP4 level on both the client and the server. You are definitely using Pervasive.SQL 2000, but maybe not the latest version. Then you need to do a consistency check against the database you are tring to query and see...
  2. Pervasivite

    accessing Btrieve files (*btr)

    You have to use a Btrieve or Pervasive.SQL engine to read the data out of the files unless you want to write an engine yourself in VB to read the files (and for that you would need the file structure). Btrieve 4.0 was a DOS only engine and as such it's probably a very bad idea to use it from VB...
  3. Pervasivite

    Update table using a secind table

    Yes, you are using Pervasive.SQL 7 which requires Scalable SQL Syntax. The current product Pervasive.SQL 2000i uses native ODBC syntax which is a bit different. You can get the docs for Scalable SQL from the Pervasive Web site, www.pervasive.com, and find out how to convert the statement to the...
  4. Pervasivite

    btrieve field overflow

    It is likely that the Excel file is not a native Excel file, but is linked to data in a Btrieve or Pervasive database engine. That Btrieve file and the engine are probably the native database behind whatever application created the data in the first place. Find out what application generated the...
  5. Pervasivite

    I want to attach btrieve table in access 2000? any idea....

    In order to attache a Btrieve table, you must have good DDFs or you will have to create DDFs yourself which can be a very difficult task. It is easiest to get the DDFs from the application vendor since they are the ones who created the data layout of the tables and know it best. You should then...
  6. Pervasivite

    P.SQL field level security issues

    Crystal Reports also provides column level security via "Infoviews" so you should be able to do it at the Crystal level, and at the SQL level with groups, users, and views. Regards, Pervasivite
  7. Pervasivite

    Create DSN, Tables

    Ric, you should go to the Pervasive Developer Center and join to get a copy of the latest SDK. It has samples for all of this. You can also use Pervasive's DevTalk forum to get samples from PVSW staff. Regards, Pervasivite
  8. Pervasivite

    App launches slowly

    Pervasive.SQL 7, and indeed any software that Pervasive has ever released does not have messages that need to be upgraded. I have often had MS software, Win2K specifically, tell me that an udpate was needed, but you should be able to turn that functionality off. I don't see why that would cause...
  9. Pervasivite

    What are the most common problems with Pervasive Betrieve (pre SQL)

    As Gil said there is lots of information on Pervasive.com, but I'm really curious why you only want problems? Are you working for a competitor? Will you post the paper as a FAQ here when you get a rough draft? The main problems with it are: 1) Conflicts with multiple versions of Btrieve or...
  10. Pervasivite

    Reading Btrieve files

    It's unlikely that the .idx files are Btrieve, though it is possible to make index only files, it's not a common approach since Btrieve files usually contain all their own indexes. Yes, you can access the files without DDFs, however, none of the non-indexed fields will be defined, so you have...
  11. Pervasivite

    Btrieve field level security issues

    If you lock the users out with an owner name (except for access through the application) and then set up users and groups via SQL security, you can then only allow users access to certain views of the data thus excluding the fields that you don't want them to see. If the data designed by the...
  12. Pervasivite

    DDFs do not reveal all data files/fields

    There are several 3rd party tools, each of which has problems, however, the tools that Pervasive typically uses are Butil.exe and the 32-bit Function Executor. Any tool reading the data files directly will only get the data type for the indexed fields. All the other fields you have to guess at...
  13. Pervasivite

    Read-only status on tables opened with Foxpro

    We found something like this with Access which also uses the JET engine and it opens two handles to the file, one in read/write mode and one in read-only. This is a property of the application telling our engine how to open the file and we see it most often when developers are trying to updating...
  14. Pervasivite

    pervasive sql2000 old dos apps

    Your old Btrieve DOS application should interface directly with Pervasive.SQL to get access to the data, so you don't need to edit the registry. Take a look at the Docs and check our the BtrBox95 for NT. That should also work under XP. You can also check the Pervasive Web site for their...
  15. Pervasivite

    Filter by Date problem

    First off where are you running this query? Are you sure that TNXDTE_72 is stored in datd format and not timestamp or some other way? What kind of data type is TNXDTE_72? Also are you sure there records where both conditions are met? You could also have bad DDFs. You can try similar queries...
See more

Part and Inventory Search

Back
Top