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
2
votes
3 answers

Pervasive dval stores dates as integer in days from 01/01/0001. I need a function to convert it for sql server

I need help. Pervasive DB stored dates in days. For example 719311 would be the amount of days from 01/01/0001 to May 28 1970. So May 28 1970 is the date represented in pervasive when looking at 719311.
developeranymous
  • 21
  • 1
2
votes
2 answers

What is meant by Distributed Systems AND Pervasive Middleware and Services

What is meant by 1) Distributed Systems 2) Pervasive Middleware and Services. What technologies are involved, and what programming languages might be used for them ( as they are included in the program structure of a postgraduate course )?
Adil Bhatty
  • 17,190
  • 34
  • 81
  • 118
2
votes
1 answer

ETL - Pervasive to SQL Server

I am a SQL Server developer and I have been asked to write some stored procedures to be used to connect a database (Pervasive) to the website. I was completely unfamiliar with Pervasive before this was asked of me, so I though the best thing to do…
c.j.smith
  • 23
  • 2
2
votes
4 answers

Query returning nothing

My query is as follows: Select h.ord_no from sales_history_header h INNER JOIN sales_history_detail d ON d.NUMBER = h.NUMBER WHERE d.COMMENTS LIKE '%3838CS%' And I get no results as shown here : But I should get results because : I ran the…
user1200540
2
votes
1 answer

How does pervasive map xml data?

I need to map xml data using pervasive map designer. I will be mapped into txt file. I always get error "Since multiple source record exist, no records will be written". Are there any solution to solve it ? thank you
putra
  • 154
  • 1
  • 9
2
votes
1 answer

Connect a Pervasive DB using OLE DB

We have a existing closed source third party application using a Pervasive PSQL database. For Example the PSQL are located in the directory c:\test and have names like holiday.dat, offers.dat and so on. I want to read and if possible write to these…
martl
2
votes
1 answer

ISQL command result in: can't open lib 'odbcci.so' with unixODBC and Pervasive Client on Ubuntu Linux

I can't figure it out how to connect to a Pervasive DB on a Windows Server machine from an Ubuntu Linux 64bit via ODBC. I installed unixodbc, then 32bit Pervasive Client 11sp2 from here and after moving the tar content to /usr/local/psql and…
Marteo
  • 64
  • 1
  • 7
2
votes
2 answers

Pervasive ODBC connection from Linux Ubuntu 64bit - DSNADD not found

I'm trying to connect to Pervasive via ODBC from an Ubuntu 64bit server. I did the following things: Installed unixodbc with apt-get command. Downloaded the Pervasive SQL 64bit Client 11.20 from the Pervasive site (don't know if this is the correct…
Marteo
  • 64
  • 1
  • 7
2
votes
1 answer

Recreate ddf files from data files (Pervasive SQL)

I inherited a project that uses a pervasiveSQL database over the btrieve-Interface. Over time there has been some copying around of the data files. As it seems btrieve does not really need the ddf files; it is happy with the data files alone, so the…
FrankB
  • 349
  • 4
  • 10
1
vote
1 answer

Case statement in Pervasive 8

I want to use a case statement in Pervasive as it lacks support for Coalesce as well. But it seems like Pervasive 8 also lacks support for Case statements. So i wanted to check if there is an alternate solution to my problem. SELECT top 100…
Arto Uusikangas
  • 1,889
  • 5
  • 20
  • 33
1
vote
0 answers

Client Timberline Office Integration from a .NET Web Application

I have an ASP.NET application where I need to push data from the ASP.NET application into the client's Timberline Office database at the users request. I need to do this by connecting to the client's Pervasive ODBC Driver to insert data into the…
Todd Samuelson
  • 11
  • 3
1
vote
2 answers

Reverse Engineering Pervasive Database?

I have a pervasive db which was originally 8x and now I am able to access it using 11x Pervasive. However, I need to get the ERD of that database through reverse engineering. Any suggestions? I have read that Toad DM version 2 had some support for…
Adnan Bhatti
  • 3,410
  • 4
  • 25
  • 38
1
vote
1 answer

Pervasive 8.x how to access? Where to find

I am working on some data conversion. I asked for files in csv format but client didn't know how to convert and instead handed me a folder with bunch of *.btr files and FIELD.DDF, FILE.DDF, INDEX.DDF and USER.DDF. My question is how to access them…
Adnan Bhatti
  • 3,410
  • 4
  • 25
  • 38
1
vote
1 answer

DSN-Less Query to a Pervasive DB via Access 2007?

See Edit 3 for latest developments: Backstory: I tried looking, and I hate to ask such a newbish question but here goes. I've recently gotten a hold of a database that apparently connects (or used to) connect to a Pervasive Database. Before the…
A.D.
  • 31
  • 6
1
vote
1 answer

Using ADO code to add a UDF to Pervasive database

I have a CREATE FUNCTION statement in a text file. I need to add this function to a Pervasive database (v13 minimum) at runtime using ADO and the OLEDB provider. I could use ODBC if that is what it takes. I have set up an ADOCommand object and an…
MarkW
  • 61
  • 7
1 2
3
…
19 20