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...
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...
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
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
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...
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...
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...
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...
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
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
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...
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...
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...
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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.