Stack Overflow
Stack Overflow

Questions tagged [pervasive-sql]

Pervasive PSQL is an ACID-compliant DBMS

It is optimized for embedding in applications and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). It is also optimized for software as a service (SaaS) deployment due to a file-based architecture enabling partitioning of data for multitenancy needs.

Applications can store the data and the relationships in tables in a relational model (RDBMS) or store the data in a schema-less way with no fixed data model (key-value store).

165 questions
0
votes
4 answers

Pervasive SQL System Stored Procedure from ADO.NET error

I'm just trying to return a list of columns and their attributes through a system stored procedure. What documentation I have seems to say the below code should work, but I get "Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine…
Thomas O.
  • 161
  • 1
  • 1
  • 4
0
votes
1 answer

How do you access Pervasive SQL metadata tables?

I am looking through Pervasive and on the internet and cannot find anything. I want something similar to information_schema.columns. Does that information exist in PSQL? If so, how do I access it? Thanks for taking the time to read my post =)
Ian Best
  • 510
  • 1
  • 11
  • 23
0
votes
1 answer

Two criteria in a field to get one result

I want to get a result of two criteria on the same field as a column. The DB has two different currency records one USD and the other TRY in the same field of a table. So, I want to get a result as finding both currencies rows one by one and divide…
user1852603
0
votes
2 answers

limited odbc connections in sql server 2008 import wizard

Issue: pervasive odbc driver ((called: "Pervasive ODBC engine interface") is visible in ODBC(odbcad32.exe). However, the same odbc driver is not visible in SQL server 2008 import wizard, although I can see the same odbc driver in SQL server 2000…
user2109347
  • 69
  • 1
  • 3
0
votes
0 answers

"Data source name not found" when adding linked server

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = 'kslap208', @provider = 'MSDASQL', @datasrc =…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
0
votes
1 answer

Pervasive PSQL 10 - Update an DDF

I'm using Pervasive PSQL Server 10 and I need to update my DDF-Files, because some components have problems accessing to a database, which was created with an previous version. The DDFBuilder also says: "Scalable SQL v3.00 data dictionary files…
DiableNoir
  • 644
  • 1
  • 8
  • 20
0
votes
1 answer

connect failed with SQL-HY001

I am using Perl 5.14.2 on Ubuntu wheezy 64 bit. I am trying to connect to a Pervasive SQL server v9.5 that is installed on a windows 2008 machine. I tested the connection with isql and it works properly, I tested with the following command: isql -v…
ufk
  • 30,912
  • 70
  • 235
  • 386
-1
votes
1 answer

Row to string value in Pervasive View

I have a table as follows +----------------+----------+--------+ | purchase_order | text_seq | text | +----------------+----------+--------+ | 1001 | 1 | screw | | 1001 | 2 | m5x10 | | 1001 |…
roice
  • 1
-1
votes
2 answers

How can I eliminate the subquery from this sql query?

I have a query which should work, but it seems I am a victim of a poor database technology. I need to run the query below on a Pervasive SQL database. The manufacturer of the product using Pervasive tells me the version they are using is 10 which…
Joe Schrag
  • 855
  • 8
  • 23
-1
votes
1 answer

How to use PSQL (pervasive) OR in PHP with a variable?

This is part of my query: where workcenter = '$query' or EmployeeName like '$query' workcenter is a number and EmployeeName is a string. Users enter either a number or a name and this searches the table for either the workcenter # or the…
ProfoundHypnotic
  • 38
  • 4
-1
votes
1 answer

PHP Pervasive SQL connection

I am connecting PHP to Pervasive SQL and the connection keep resetting This connection is on Windows Server 2012 using PHP7 on Apache 2.4. I have already created a DNS connection and the test can connect to the database successfully.
Kwasi Owusu
  • 11
  • 4
-1
votes
1 answer

Pervasive SQL: Can a client send multiple SQL Statements in one Database Request?

From a client-application, is it possible to send multiple SQL statements at once to PSQ v13? I have a situation where I'd like to send both a delete statement and an insert statement in one call via ODBC. It would also be ideal if I could do this…
Lonnie Best
  • 9,936
  • 10
  • 57
  • 97
-1
votes
1 answer

Pervasive psql backup and restore

I am trying to find any free method possible to restore a backup file to Pervasive SQL tables. I have downloaded pervasive server and the backup agent . Can anyone help me thanks
Noury
  • 1
  • 1
-1
votes
1 answer

Extract Text, Removing Characters After "-"

I have a column Plans like this: Plans OXF-PL10-A OXF-PL10-C OXF-PL10-P OXF-PL10VE OXF-PL2-P OXF-PL3-P How can I just grab the text without the characters after the 2nd "-" I want my data as follows: Plans OXF-PL10 …
Daniel Li
  • 287
  • 2
  • 17
-2
votes
0 answers

SQL 3 Tables, Left Joins, and Union Performance

The company I work for has a customer table, part cross reference table, and a part pricing table. I'm trying to combine all of the information into a single view for our customer service representatives, but the query performance isn't great. …
Jeff D
  • 1
  • 3
1 2 3
…
10
11