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
1
vote
2 answers

Connecting to old Pervasive DB with JDBC

I'm trying to write a small program for CRUD operations against an old Pervasive 9 database, but as soon as I try to get a connection with Drivermanager.getConnection it throws "java.io.IOException: LNA session closed" I've read THAT post but…
elwis
  • 1,395
  • 2
  • 20
  • 34
1
vote
1 answer

How to reference a table in a Sub-Sub Query

I have the following tables: Bradford_Score_Bands BandNo InclusiveScore ------------------------ 1 0 2 150 3 500 Bradford_Scores ClockNo Dated Score -------------------------------- 2 30/10/14 …
Matt Wilko
  • 26,994
  • 10
  • 93
  • 143
1
vote
2 answers

Pervasive & Linux

I'm interested in quering a Pervasive DB server running on a Windows platform from Linux. Would anyone happen to know if this is possible, what's required and what resources there are for me to read up on it? Thanks!
Alexander Trauzzi
  • 7,277
  • 13
  • 68
  • 112
1
vote
0 answers

Netbeans 8 Java creating new entities classes from database - no primary key

I'm using netbeans 8 on Win7 64 to connect to a pervasive db (db of which I'm not the admin). I'm running into errors when trying to generate the JPA layer through the entity classes from the database, for each table it renders: 'no primary key'.…
peiznohekee
  • 11
  • 4
1
vote
3 answers

Pervasive SQL with WHERE - matching spaces

Our accounting application is using Pervasive SQL 10. I need to fetch data of products from it. Problem is that the "name" column has fixed length of 12 and the application is filling the rest with spaces. So every time I use my PHP script to fetch…
InToSSH
  • 160
  • 2
  • 10
1
vote
1 answer

LibreOffice Base subform displays unrelated records

I would like help solving a problem with a LibreOffice Base subform. I think the subform should be displaying only the records that are related to the record displayed in the parent form. But the subform is actually displaying every record in its…
MetaEd
  • 3,753
  • 1
  • 28
  • 30
1
vote
1 answer

Reading a Date field from Pervasive database causes crash

I am trying to read some data from a Pervasive database (through a C# Console app I wrote) and whenever I reach a row that contains information on a particular date column, the program throws an exception. I managed to identify the problematic…
Icarus
  • 63,293
  • 14
  • 100
  • 115
1
vote
3 answers

Pervasive and Tango?

We are currnetly looking at redeveloping an Interanet application that was created it would appear with Pervasive SQL and Tango (it usues TAF fiels so this is out assumption). Looking at the Pervasive website I cannot even find any references for…
schooner
  • 3,047
  • 8
  • 30
  • 39
1
vote
1 answer

Betrieve access to data without DDF

I would need help to access data from Betrieve files. Persasive ODBC driver need a DDF file that define the "schema" for each table, my problem is that DDF file not exist. The QBasic code that I should migrate to C#, make a substring functions and…
Nicolas Dominguez
  • 11
  • 1
1
vote
4 answers

Paging in Pervasive SQL

How to do paging in Pervasive SQL (version 9.1)? I need to do something similar like: //MySQL SELECT foo FROM table LIMIT 10, 10 But I can't find a way to define offset.
Vertigo
  • 2,714
  • 1
  • 22
  • 24
1
vote
1 answer

Pervasive SQL Driver

UPDATE: should be on serverfault as suggested. New post here: https://serverfault.com/questions/451220/psql-64bit-driver-error I am having a hard time getting PHP to connect with ODBC using a Pervasive SQL driver. I have an Ubuntu Server 12.04 and…
Alexander Holsgrove
  • 1,795
  • 3
  • 25
  • 54
1
vote
1 answer

Creating connectors using Pervasive Connectors

Can any one please help me to over come my issue, i am searching how to create a connectors in pervasive from 1week, i am unable to find the solution, atleast step to move on, i followed the predefined link…
Navyah
  • 1,660
  • 10
  • 33
  • 58
0
votes
1 answer

Select Database Names in Pervasive SQL 9

I have been searching all over and i cant seem to find a solution. I want to query the Pervasive engine to see how many and what are the names of the databases hosted on the Pervasive engine. my actual purpose for doing this is to create an DSN-Less…
Jason Loki Smith
  • 428
  • 3
  • 12
0
votes
1 answer

How to sum two calculated rows together

Using Pervasive SQL. I have a query w/ results below. However, N00 and S00 are the same person. so, instead of a separate line I need the "actual" values from N00 and S00 to be totaled together in one row. I have been trying to come up with a sub…
SkylarPurifoy
  • 11
  • 5
0
votes
1 answer

Dealing With Pervasive 13's Ridgid StartUp Dependencies

How can I delay the start up of a windows service until internet accessibility is verified? Pervasive 13 has two registered windows services that start each time you reboot the server. If dns happens to not be available, at the time that these…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
1 2 3
…
19 20