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!

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

Search results for query: *

  1. trims30

    Status 3103 and 3014 with UAC ON

    Customer has PSQL9 Workgroup and has been running fine till the other day when they turned on UAC. Now getting 3103 and 3014 errors. Also they're running database engine as service. Data is on share drive with no pervasive components. Tried copying a data file to a workstation c: drive and...
  2. trims30

    SQL Update/Insert Reserved Words

    Using MS Access database - tried "BY" - no luck - [BY] and [DATE] will work. Thanks for pointing me in right direction. Lee
  3. trims30

    SQL Update/Insert Reserved Words

    Having a problem with UPDATE and INSERT command. Have database with fields named ID, Serial, By, Date SQL Update Command: UPDATE Transactions SET Serial="1234",By="Lee",Date="11/01/2009" WHERE ID=2101 Command fails due to improper syntax. Traced it to fields "BY" and "DATE" If I modify...
  4. trims30

    Arrays with SQL

    I have a database with 40 fields and am working in ASP.NET. is it possible to do a non-query UPDATE or INSERT of the database transferring the entire array as opposed to using field names and values? Any examples would be helpful
  5. trims30

    Visual Web Developer IDE Question

    See Image below... No Reference Node appears
  6. trims30

    Visual Web Developer IDE Question

    Jason: Tried it in VS just now. Created new ASP Website Project and again, there is no References Node in Solution Explorer. Went through process of adding a reference and nothing changes in Solution Explorer. I'm lost. Lee
  7. trims30

    Visual Web Developer IDE Question

    Jason: My problem is that there is no Reference Node shown in the Solution Explorer. How do I add the Reference Node to my project? Lee
  8. trims30

    Visual Web Developer IDE Question

    I'm new to this tool - When starting a new project how do we add references to external components? I right click on project in Solution Explorer and I find Add Reference. I select it then see a list of .NET components. I then select the components I want and click OK. This does nothing as...
  9. trims30

    PSQL9 WorkGroup Status 161

    Customer has two workstations running our application and has approx 10 files open. Ran License Admin on one workstation and see 5 user limit but no indication of any activity ie; open files=0, license in use =0, threads=0 Customer says no ~pvsw~.loc file in shared folder on server. Based upon...
  10. trims30

    PSQL9 WorkGroup Status 161

    Our Customer at a major University reports he's getting Status 161 "User Count Exceeded" when running more than three workstations in our application. We have verified User Count in License Admin on all workstations is set to 5. Database is located on shared drive on a computer/server...
  11. trims30

    PSQL8 and Btrieve 6.15 file compatibility

    Our customer is using two workstations in a peer-peer network. One has PSQL8 and the other is Btrieve 6.15. If the PSQL8 workstation "creates" a database file the 6.15 machine cannot read it - "not a btrieve file" In PSQL8 is there a setting to create files in pre 8.x format similar to option...
  12. trims30

    Error 26 - Number of Keys

    Found problem to be Page Size. Didn't realize that with smaller page size we were only allowed 24 index segments. Increased page size to 2048 and now I can have 54 index segments and create works correctly. Thanks for the help. Lee
  13. trims30

    Error 26 - Number of Keys

    More Info - I do have one file that has Seven (7) indexes and a total of 33 segments that I am able to create using same code. On the offending file, if I drop the last two indexes I am able to create file. Error does not appear to be in my data structures. Lee
  14. trims30

    Error 26 - Number of Keys

    Help! - Using Btrieve 6.15 and Getting Error 26 on executing Btrieve function 14 "Create" I use the same code for all of my files and everyone works except the one file with a large number of indexes and segments. File causing trouble has 6 indexes with a total of 31 segments. My data...
  15. trims30

    How to Determine Data File Version

    I know that Btrieve 6.15 files are upward compatible with PSQL-8 and if created by 6.15 they can be read and written by both systems. If a file was created by PSQL-8 then 6.15 cannot open it. A Customer sent me a file that I can't open on 6.15 - I get error "Not a Btrieve File". In looking at...
  16. trims30

    DDF Builder Limitations

    I solved the problem by building a new set of ddf's and importing all file definitions. Ended up with a 456K field.ddf and its working OK. I've been using the same DDF's for years and have always added or removed files but never rebuilt ddfs from scratch since 1995. There may have been an...
  17. trims30

    DDF Builder Limitations

    I don't have a problem in building files... problem seems to be size limit on field.ddf Mine is 511K and can't make it any larger without crashing. Is there a limit on file size for field.ddf?
  18. trims30

    DDF Builder Limitations

    Currently have ddf's for btrieve 6.15 created with an old copy of Smithware DDF Builder. Have never had a problem using this utility till today. I was editing some fields (20 of them) in one data file changing field formats from 2 to 4 decimal places. When I closed the definition editor and...
  19. trims30

    Pervasive SQL Config problem?

    mirthiel: I've been told that all workstations are using PSQL. That's the first thing I thought of. We distribute the 6.15 library but customer has installed PSQL. It is possible that customer reinstalled our software and overwrote some of the PSQL routines of same name as Btrieve 6.15...
  20. trims30

    Pervasive SQL Config problem?

    We are the developers of TRIMS, a program distributed with Btrieve 6.15 workstation engine. One of our customers is using it with Pervasive SQL 8 WorkGroup Edition and is experiencing problems with one workstation. Please read problem description below. Anyone have an idea as to what's...

Part and Inventory Search

Back
Top