Stack Overflow
Stack Overflow

Questions tagged [pervasive]

Pervasive PSQL is an ACID-compliant DBMS developed by Actian Corporation.

Actian Zen Embedded Database is a hybrid-NoSQL/relational database for superfast transactions and standard SQL access.

Actian Zen offers full security, encryption, management and monitoring tools, plus a host of other features.

Actian Zen Embedded database is built for environments where users don’t have the resources to manage a database.

Actian Zen enables ISVs to take advantage of new hardware architecture, OS platforms, and computing environments (64-bit, multi-core, VM, Cloud) without application changes.

Official product documenation can be found here.

Actian forum for Actian Zen can be found here.

286 questions
0
votes
1 answer

How do I listen to Pervasive Database Event from .NET

I would like to listen to changes happening on a pervasive database table using .Net... For example: I have a Client table with a column for Phone Number. I would like to know how to listen for changes to the Phone Number column for any record on…
Ian McShane
  • 340
  • 3
  • 10
0
votes
1 answer

How to connect to a pervasive database with Yii2?

I would like to make a connection to a pervasive database in Yii2. I have tried odbc, as it's installed but when I'm trying to create models with Gii I'm getting the error: Connection does not support reading schema information for 'pervasive odbc…
user2511599
  • 796
  • 1
  • 13
  • 38
0
votes
1 answer

PervasiveSQL Database dates conversion

I'm working on tables obtained from a PervasiveSQL database and I have some trouble managing dates. In some of the fields dates are recorded in the format we use in Italy, dd/mm/yyyy, but in others are recorded in a format I can't understand,…
ffusconi
  • 1
  • 3
0
votes
1 answer

BUTIL -CLONE gives invalid filename error

So I have a corrupt .btr file (filename is FINAN.BTR) that I'm trying to recover. This is possible by using the following commands: BUTIL -CLONE CORRUPT.NEW CORRUPT.BTR BUTIL -COPY CORRUPT.BTR CORRUPT.NEW REN CORRUPT.BTR CORRUPT.OLD REN CORRUPT.NEW…
Mr_BananaPants
  • 47
  • 1
  • 5
0
votes
1 answer

Pervasive Btrieve error though field exists

I want to execute the following Statement: select * from Matrix where Untersuchungsmethode='Fremdlabor' The table Matrix exists also the field Untersuchungsmethode. But I get the Error-message: select * from Matrix where…
Max Lindner
  • 171
  • 1
  • 1
  • 7
0
votes
1 answer

Pervasive SQL error: Invalid cursor state

I'm trying to INSERT a record into the Pervasive SQL using PHP PDO with ODBC, but keep getting this error: GSS Query failed: SQLSTATE[07005]: Prepared statement not a cursor-specification: 0 [PSQL][ODBC Client Interface]Invalid cursor state.…
Alex G
  • 3,048
  • 10
  • 39
  • 78
0
votes
0 answers

How to delete/update ODBC - System DNS - Database

How can I update or delete the highlighted Database in the screenshot below? I have searched the Registry and cannot find it anywhere. It is configured incorrectly and needs to be recreated or updated.
Dupdroid
  • 125
  • 2
  • 14
0
votes
1 answer

Syntax Error without details in Pervasive SQL

I am getting an error talking to a Pervasive SQL database, but without much details about what could be wrong. Do you have any advice about how I could debug where the problem is Pervasive.Data.SqlClient.Lna.k: [LNA][PSQL][SQL Engine]Syntax Error. …
Baptiste Pernet
  • 3,318
  • 22
  • 47
0
votes
1 answer

Actian PSQL/Pervasive SQL: unhex

i have some hex data in db. so i need to unhex it. something like: unhex('414243'). is there any functions or tricks to do it? i saw unhex function in actian ingres db.
Poly Deus
  • 1
  • 1
0
votes
0 answers

How to repurpose(optimize) a left join statement?

I have a query that is taking over 500 seconds to run. I managed to figure out the culprit to be my 2nd left join in the below query. When I comment out that left join, and the two columns I select from that table the query takes 3 seconds. When I…
SkylarP
  • 39
  • 1
  • 8
0
votes
1 answer

Is there a way around using column(s) in group by? Pervasive SQL

Is it possible to exclude columns from a group by clause? I have two columns (source & cause) that are a part of my select statement that have to be in the group by otherwise I get an error. My issue is that instead of one row for each Job sometimes…
SkylarP
  • 39
  • 1
  • 8
0
votes
1 answer

how to retrieve one record when multiples exist

I need help only retrieving one record per job in this dataset. There are over 900 rows in the actual result set so this is a small sample but all rows look like the below. I am already using Distinct in the query but I get more than one record for…
SkylarP
  • 39
  • 1
  • 8
0
votes
0 answers

Actian/Pervasive PSQL Zen 13.30 error 46 random ocurrences

We currently use Actian PSQL Database in our core business application for more than 10 years. In the las few days, users actions using the application, randomly trigger error 46, which is related with "permissions issues", but what really happens…
Jorge S
  • 1
0
votes
2 answers

Locating Columns that Contain a String in their Name

Other than manually traversing every table schema in the entire database, how can I produce a list of all tables that contain a field containing the string "email" in Pervasive 13? For example, in IBM DB2, I can do this with a query like…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
0
votes
1 answer

Pervasive SQL(10.3) File size exceeding 2GB resulting in a .^01 file being created

We have a database with a data file exceeding 2Gb, this resulted in a .^01 file being generated with the same file name. We now have a .DAT file and a .^01 with the same name. I have subsequently deleted the unnecessary data (old history, no longer…
Peter Hearne
  • 3
  • 1
1 2 3
…
19 20