In the version 9 SQL Engine Reference the description of START TRANSACTION on page 203 states the following. "Within the ODBC standard,...

Bill

02-23-2007 12:01 PM
Bill Bach

I need to convert some DDFs from version 6 to something that PSQL version 9 can read. Does anyone know of a utility (preferable free) that will do...

Bill

02-23-2007 12:42 AM
Wayne

I am trying to create the following trigger. CREATE TRIGGER paRelateLinkInsert AFTER INSERT ON paRelate FOR EACH ROW BEGIN INSERT INTO paRecLink...

Bill

02-21-2007 07:37 PM
wfreeman@analyticabiz.com

We have a customer that uses Novell Clustered servers, when trying run a conversion on the data from an older version of our software the application...

Lisa@IMC

02-20-2007 04:32 PM
Lisa@IMC

Hi, I have hundreds of NDB files, and I need a way to see whats in them? Is there a program or reader that would work?

williamdesrochers@gmail.com

02-17-2007 10:59 PM
Bill Bach

Hello, I have a pervasive 8.5 implementation that is throwing btrieve 3103 errors intermittently. It is running on a windows box and has a user...

Rob Michelis

02-16-2007 09:03 AM
Bill Bach

How is possible to get "Stat 78" within Begin transaction OP 1419?

ddion02@videotron.ca

02-11-2007 01:50 PM
Bill Bach

The following stored proc returns no results. If I remove the UNION ALL and the second SELECT it does work. What must I do to get the UNION ALL to...

Bill

02-09-2007 10:54 AM
Bill

Hi I'm using the v8 JDBC driver to access a PSQL v8.6 database. I have set up a test to see whether a connection with an isolation level...

Ben Morgan

02-09-2007 05:52 AM
Ben Morgan

hello, first my english is bad. i have write a windows application that connect via pervasive odbc 2.x to a btrieve 6.15 database, when the...

Josef Sejrek

02-07-2007 02:51 PM
Bill Bach

I'm trying to append new text on a field using the concat function. On the Set statement I use something like this: Set Field =...

datenisis

02-02-2007 06:10 PM
Bill Bach

Contract Job available for integrating Pervasive SQL 9.5 with Btrieve 6.15 and Excel. Please contact: jevonjaconi (AT) icscuttingtools (DOT) com...

jevonjaconi@gmail.com

01-31-2007 07:37 PM
Bill Bach

Hi, does anybody know how to treat empty date columns (shown as 0 in the pervasive sql.manager) when accessing them via an Ole DB driver? I always...

Matthias

01-31-2007 07:36 PM
Bill Bach

We're in the process of migrating from P.SQL V8.6 on a Netware 5.1 SP8 server using a tradational file system to P.SQL V9.5 on an OES/Netware SP2...

Guy Dawson

01-31-2007 11:28 AM
Guy Dawson

Several years ago, we purchased and had installed pervasive SQL 2000 version 7.5. We're having problems with our server and need to re- load...

brianmturk@gmail.com

01-31-2007 09:45 AM
Bill Bach

I'm trying to connect to a Pervasive 9.5 database using classic asp, and am getting error messages establishing the connection. I'm getting the same...

Mark

01-25-2007 10:51 AM
Bill Bach

Hello, I'm having a problem with PSQL version 9.50 (workgroup engine). I am trying to access a database that contains several tables. I...

eljainc@sbcglobal.net

01-19-2007 08:16 AM
Bill Bach

I am hoping that someone could point me in the direction for help with Data Junction 7.5. I am completely lost. I am trying to modify an X12 837P...

mkerrigan@ktoys.com

01-11-2007 08:07 AM
Bill Bach

Hi! We have an existing P.SQL data base (data files and DDFs) which we'd like to move to a new server. Moving the data is easy but I can't for the...

Guy Dawson

01-02-2007 01:46 PM
Bill Bach

Is there a way for me to write a batch file to run an SQL statement in a Pervasive table. Or is there a way to write a VB script to execute the SQL...

dsuellentrop@gmail.com

12-22-2006 02:55 PM
jbuttery@sqnbankingsystems.com

I have a site that seems to be having a persistant problem with the Pervasive server software just becoming uninstalled. I have checked the database...

PJ

12-21-2006 01:06 PM
Bill Bach

Hello I'm using butil 5.12. I thought save and load commands do exact reverse jobs,I mean running butil -save d1.dat t.txt butil -clone d2.dat...

mohsen_fakhari@yahoo.com

12-18-2006 09:32 PM
Bill Bach

I have been getting a series of invalid requests over the past few months. Sometimes they do not seem to matter other times they seem to...

johnaherne@rocs.co.uk

12-14-2006 04:41 PM
Bill Bach

I have designed a simple table that uses a longvarchar to store variable-length text. I have this table fully implemented using the Btrieve API. I...

news.wi.rr.com

12-14-2006 04:26 PM
Bill Bach

I have one customer that is getting an error 3112 from our application, but only when accessing a portion of the software, when looking at...

Lisa@IMC

12-14-2006 09:55 AM
Lisa@IMC

I'm using PSQL 8.7 and trying to figure out how to use the COLLATE arguement of CREATE TABLE. I need to create tables using a French ACS. According...

Greg D

12-11-2006 06:09 PM
Bill Bach

Hi, I am trying to get my program to connect to a BusinessVision database. It seems that BV uses unnamed databases. My program uses an...

lord.zoltar@gmail.com

12-11-2006 06:08 PM
Bill Bach

I should extract data on client pc (WIN2000,Pervasive.SQL 2000 SP2) from a btrieve Novell database on server (DOS system) in local network. Inside...

flavio62

12-08-2006 06:45 AM
flavio62

Hi, Do you know if Pervasive 9 SP2 workgroup with Windows VIsta works? I try to install but we have problem with relational database. Thanks.

mtn_bikers@msn.com

12-06-2006 06:18 PM
Bill Bach

I have a customer who recently migrated from Novell to windows server and upgrade to v 8.7 PSQL. Since migrating the user has one workstation that...

Lisa@IMC

12-06-2006 02:42 PM
Lisa@IMC

Are you using PSQLv9.5? Previous engines required the use of the GRANT LOGIN and REVOKE LOGIN statements for these operations. Have you...

Bill Bach

11-30-2006 01:53 PM
Bill Bach

Hi all, First, I never used either pervasive not btrieve, so some of my questions might seems stupid or at least naive - please excuse this :) I...

bzamfir@gmail.com

11-30-2006 10:23 AM
nelsonsoft

Hi! I was asked to find if it's possible to quite swifftly migrate Maximiser97 database to Access/SQL. I've read many links, newsgroups and support...

Morris

11-29-2006 02:18 PM
nelsonsoft

Hello ! Pervasive's ADO.NET driver crashes if we try to put more than 2000 bytes in a CLOB (longvarchar) field although the documentation says 2GB of...

pklauss

11-17-2006 05:40 PM
Greg D

Hi, We have a named database that was created with SQL using primary keys and foreign keys. We tried PvModifyDatabase() and although the function...

Greg D

11-17-2006 05:35 PM
Greg D

Hi, on trying to add a license update to a P.SQL 9.1 Server installation with P.SQL Data Exchange running I get the "DBU access denied" error. I...

Jens Eden

11-15-2006 09:58 AM
Jens Eden

Hello! Is it true that Btrieve fields are allways stored at maimum length in the physical Btrieve-file? We switched form fixed length types like char...

pklauss

11-15-2006 05:04 AM
Gordon

Hello Folks! How do I create a stored procedure, which returns a singel integer value? I need to use the procedure in the following way: SELECT...

k.andris@gmail.com

11-14-2006 08:34 AM
Bill Bach

New install of V8 workgroup under Win XP Pro. Access under administarator works fine. Login as the nowmal user of the workstation get File Manager...

Brian Scoffield

11-13-2006 05:38 PM
Bill Bach

As far as I can tell, in general, the pervasive engine is not that intelligent. You can put double quotes around column names to prevent conflicts...

Greg D

11-10-2006 03:22 PM
Bill Bach

(Microkernel) Invalid key number. Made some changes to a table yesterday; dropped and re-created. Tried running a cusom program that is calling...

dawn13

11-08-2006 09:00 PM
Wayne

Hi, I am using PervasiveSQL (version 8.6, I believe) with BusinessVision 7. I would like to view the BusinessVision tables in Pervasive. The problem...

lord.zoltar@gmail.com

10-26-2006 04:49 PM
lord.zoltar@gmail.com

Hi I've an old problem creating a DSN for my Btrieve files with Pervaisive 32bit ODBC Driver: Login must secceed before data source entry can be...

mohsen_fakhari@yahoo.com

10-25-2006 05:56 PM
Bill Bach

I am trying to create a crystal 9 report using a stored procedure. in pervasive 8.5 I get "access violation" when attempting to create...

Cor-dev

10-22-2006 08:33 PM
Wayne

Hi all I have Btrieve version 5.10a and not Pervasive PSQL . I want to use JCL to work with my data stored in some dat files. Is it possible?or JCL...

mohsen_fakhari@yahoo.com

10-20-2006 06:40 PM
Bill Bach

I am very new to PSQL and am working on custom code written several years in VB4 that is making calls to stored procedures. Does anyone have any...

dcoulter13

10-20-2006 06:38 PM
Bill Bach

You can pull a copy from here in the next few days... ftp://ftp2.goldstarsoftware.com/sqlexec.zip BB seetickets wrote:

Wayne

10-18-2006 09:24 AM
Bill Bach

Hi All, We are using Pervasive SQL 2000 for our ERP package, currently we are doing fresh developments in this package. We are facing a...

Samson

10-18-2006 09:22 AM
Bill Bach

Hi all I have Btrieve and not Pervasive PSQL . I want to use JCL to work with my data stored in some dat files. Is it possible?or JCL works just with...

mohsen_fakhari@yahoo.com

10-16-2006 01:56 PM
mohsen_fakhari@yahoo.com

Hi all, I am attempting to use DTO to manipulate version 7 databases. Psuedocode is like this: dtoDictionary.Open "ddf_path" I am running this on...

mehoss

10-12-2006 06:16 PM
Bill Bach