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
0 answers

How can I make pandas.read_sql_query ignore the datetime datatype of a column in the source database?

The error that I get is "ValueError: month must be in 1..12" I know that there is "weird" data in that column and I want pandas to treat it as text or ignore the rows with errors and populate the df with the remainder. (Not a big deal but would be…
RobD
  • 1,695
  • 2
  • 24
  • 49
1
vote
1 answer

Pervasive PSQL 10 Database to MS SQL Server?

I want to migrate a Btrieve Database to Microsoft SQL Server 2008 R2. I already have done the step of migration to Pervasive PSQL 10 Workstation (x86), which offers an ODBC / OLE DB driver. (It seems Microsof doesn't offer any solution to import…
DiableNoir
  • 644
  • 1
  • 8
  • 20
1
vote
1 answer

How can I connect to pervasive database in ruby on rails?

I have installed Pervasive V10 server x86 and odbc gem. Whenever I make a request to fetch data from the database, I get the following error "IM003 (160) Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL)…
james simbi
  • 26
  • 5
1
vote
1 answer

How to install Pervasive Direct Access components in Delphi-XE7

I have been trying for two days to install Pervasive PDAC components. I do everything according to Actian instructions. After selecting the required .bpl files, I keep on getting a message that the specified module could not be found. I have tried…
Gerhard
  • 71
  • 1
  • 12
1
vote
1 answer

Is it possible to accessing Pervasive sql database via spring boot?

it's possible to accessing Pervasive sql database via spring boot
Omar Thaljeni
  • 11
  • 1
  • 3
1
vote
1 answer

PSQL can't add value to parameters

I'm trying to wirte a PSQL query that somewhat easily readable, so I want to use the PsqlCommand.Parameters.AddWithValue() function, but I have some problem with that... Here is my code: PsqlConnection connection = new…
Martin Serdült
  • 111
  • 9
1
vote
1 answer

Password Changer using VAccess

Hey I am working on a password changer. User logs in ( successfully), loads a global var with user initials, then launch a password expired form. I try and use those initials on the password expired form to retrieve user info from…
Jose
  • 13
  • 2
1
vote
1 answer

sql replace function that matches whole words

I wish to replace some text within a field, so i have the following statement: UPDATE INVENTORY SET INV_DESCRIPTION = REPLACE(INV_DESCRIPTION, '5 ml', '5ml (1/6oz)') The problem lies in the fact that this statement will replace strings such as '5…
seb
  • 151
  • 1
  • 4
  • 7
1
vote
3 answers

optimizing SQL UPDATE with LIKE

I have tried running the following UPDATE on a table with about 25k rows and its been running for over 24hours and it has not completed. I only need to run this UPDATE once so time is not too much of an issue, but anything that long is just not…
seb
  • 151
  • 1
  • 4
  • 7
1
vote
2 answers

What am I doing wrong in this select query with left join and filters?

With Actian PSQL v13: I'm attempting to join two tables and filter the result set by a few criteria. One table is customer sales history. The other table associates customers to buying groups. Not all customers are in a buying group, so I'm doing a…
AJK
  • 67
  • 1
  • 2
  • 7
1
vote
1 answer

How to restore a Pervasive Db backup?

I need to ask one of our customers for a db backup of their Pervasive DB. I went through the online material available in this area and surprisingly, there is very little information available. Appreciate any help in this area. Mainly I have two…
Thilok Gunawardena
  • 924
  • 5
  • 22
  • 44
1
vote
1 answer

RunTime Error 380 - Specified Fieldname not found in object

I am running a VB6 application with a Pervasive V9.5 Database. I am receiving a RunTime Error 380 - Specified Fieldname not found in object when only 2 of my users are trying to log in. Rest of the office is fine...Does anyone have any idea what the…
Jose Quervo
  • 33
  • 1
  • 4
1
vote
0 answers

How to read dates in Pervasive SQL?

I'm working with a client who is using a Pervasive SQL database, and trying to understand how their database is structured. The problem is that my client isn't aware of how the database was setup, and had been relying separate vendor who created the…
Cheeku Jee
  • 159
  • 2
  • 9
1
vote
1 answer

Does Pervasive Database have a Scheduler?

Does the Pervasive Control Center (PCC) provide a scheduler? I want to run a sql statement on a schedule. Does Pervasive database offer any type of built-in scheduler, where I can add a statement and specify when it should recur?
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
1
vote
1 answer

Pervasive PSQL Control Centre / Currency data type

Having issues updating a Pervasive PSQL table using Pervasive Control Centre and wonder if anyone can point me in the right direction. I'm struggling to update a field in the table whose type is '254-VB Currency'. Sample query: Update TABLE set…
Doug
  • 13
  • 3
1 2 3
…
19 20