I have a netware 3.12 system with Btrieve which only be up once or twice per year. Now the server cannot turn up due to harware failure. Can i...

Tony WONG

11-04-2004 01:02 AM
Leonard

Is it possible to rename a named database the uses referential integrity? I'm using P.SQL 8.6 Workgroup Engine on WinXP. Using PCC, I tried deleting...

Greg Doherty

11-04-2004 12:58 AM
Leonard

Fatal Error "8005: Interface not initialized" Can anyone tell me what this error means? Some clients are able to run without any problem while...

Montane

11-01-2004 03:46 PM
Bill Bach

Last week we moved to PSQL V8.1 from 2000i. Since we have had incredibly slow data access problems. This keeps flactuating from normal to abnormally...

Montane

11-01-2004 03:45 PM
Bill Bach

PSQL2000i had support for Solaris as well. This semm to be terminated in PSQL 8.x. Is this right? reagrds nmm

nmm

11-01-2004 11:27 AM
Gordon

Server Novell Netware 5.1 SP4 Pervasive.SQL 2000i 7.94 Clients Win XP Pro with 2000i clients Our set-up has been working successfully for a number...

Eoin Fitzpatrick, Dublin

10-28-2004 04:43 PM
Leonard

Hi there, I've got lots of tables in my Pervasive database. Now I want to export the data. I want to create a script-file which contains to data...

Markus Brandy

10-28-2004 02:56 PM
Bill Bach

Hi, I would say I am competant in MS SQL, ODBC and "back in the day" xbase programming. I am flumoxed however in how to set up an odbc connection...

Neil

10-28-2004 02:43 PM
Bill Bach

I have virtually next to no experience with Pervasive software, so my apologies first off for being so clueless. I'm running Pervasive.SQL 2000i SP3...

Joseph Markovich

10-28-2004 02:42 PM
Bill Bach

For those of you who have been following my problems getting OLE DB access to databases with classic security on Netware... We appear to have found...

Guy Dawson

10-28-2004 01:02 PM
Guy Dawson

Hello, can anyone tell me if this configuration is supported: PSQL 8.5 or 8.6 on a Windows 2003 Cluster Server. Any running installations out...

Thomas Jäckel

10-26-2004 06:19 PM
Markus Barth

Moving from DataFlex to SQL Server, currently on Pervasive but due to replication we are moving to SQL Server. Which is the best company for the SQL...

John

10-21-2004 06:34 AM
John

Hi Gurus! Since I could not get a answer to my last question, I will try to be more specific now. I know, that the transactional engine can use the...

Horst

10-20-2004 01:32 PM
Horst

Hello I'm new in Betrieve databases. I've got a strange database without documentation and I have to prepare data export to MSSQL. Today I've tried...

Trociu

10-19-2004 12:26 PM
Gil

Hello After completing the seek method on a recordset, is there any way of cycling through the records after the sucessful seek, until a certain...

Chris Smith

10-19-2004 10:41 AM
Chris Smith

Hello, I am developing an application for a client using Pervasive 2000i. I am using OLEDB to get at the data. I can open the data and read the...

Chris Smith

10-19-2004 07:27 AM
Chris Smith

I know of one company that has a "current" file and a "history" file (or files). When the current file gets full (actually they schedule this when...

Bill Bach

10-18-2004 11:54 PM
Leonard

Hi! We are having the following Problem in one of our applications: We are connecting over ODBC, and another application is connecting over Btrieve...

Horst

10-18-2004 11:39 AM
Horst

Here is a function that will generate the VB6 code to enable you to distribute applications without the DDFs. You must start with one set of DDFs of...

henry

10-17-2004 10:49 AM
henry

Silly me: (Corrected Email Below) Folks given all the changes over the past 10 years (when I first joined BTI) I would love to facilitate a Orkut.com...

mikedunnfivfive

10-12-2004 11:54 PM
mikedunnfivfive

Folks given all the changes over the past 10 years (when I first joined BTI) I would love to facilitate a Orkut.com Community so that we can keep in...

mikedunnfivfive

10-11-2004 10:39 PM
mikedunnfivfive

As a follow up to an earlier post, I am providing the actual vb form code that I am attempting to use. As I stated earlier, the second data control...

henry

10-11-2004 02:10 PM
dbSw Solutions, Inc.

I hope someone can assist me w/this.... I am brand new to the ActiveX component got it from installing V8 and am connecting to a V7 database. First...

henry

10-08-2004 08:10 PM
henry

can you alter views? i was using drop view then create view but i was told that there is a ALTER view command. where can i get information about...

Bre-x

10-08-2004 08:24 AM
Bill Bach

I am attempting to use the Query Plan Viewer but cannot create the query plan file. I have created an ODBC System DSN for my database and added the...

Bill

10-08-2004 08:22 AM
Bill Bach

I am having a problem getting 6 new workstations (XP Pro) SP1 Sony VAIO's to work in the Pervasive v7 enviornment. It seems like I can only get...

schrammie

10-01-2004 12:39 AM
Leonard

Hi, I'm trying to execute a Select query with a Where clause in a JSP page and I get the error listed below. From what I've been able to tell by...

RoadRunner

09-30-2004 10:27 PM
Bill

I am new to Pervasive.SQL 8 and I am trying to execute a simple two table join. When I do I get the following error. ODBC Error: SQLSTATE = 37000,...

Bill

09-30-2004 08:01 PM
Bill

Hi, We would like to migrate an existing Pervasive SQL7 database to Pervasive SQL8. We want to avoid upgrading the existing live database so the...

Paul

09-29-2004 05:36 PM
Paul

Hi A friend of mine still uses Sales Ally 1.12 This software is stone age and we want to export the information into modern client software. As far...

Pasqual

09-28-2004 07:20 PM
Bill Bach

If it is TAS boks accounting software then http://www.tassoftware.co.uk/home.asp should be able to help you, its not that old really! "Leño" <al...

Bill Bach

09-25-2004 10:54 AM
quattro

Does anyone know how to specify a specific index number when issuing the Create Index (31) Btrieve command through the API? It seems that whatever...

Jim Chaffee

09-23-2004 05:46 PM
Bill Bach

When opening Macola Progression Explorer get this error Execution error : file ‘MACOLA32.LBR\_BTR.gnt' Error code \: 114, pc=0, call=12,...

Dave S

09-21-2004 11:54 PM
Bill Bach

When I run the following update statement, the Bulkline field gets truncated on any record with the corresponding gift field. Ex: Bulkine before...

Shane Peterson

09-21-2004 11:50 PM
Bill Bach

Hi, I have recently moved a database from one server to another. I did this by simply copying the data directory onto the new server, then adding a...

ChrisM

09-17-2004 10:47 PM
Bill Bach

We are moving business premises this weekend and have got a number of new PC's. We are running 2000i on a Netware server. Should I continue to...

Eoin Fitzpatrick

09-16-2004 08:27 AM
Eoin Fitzpatrick, Dublin

hi, I have a Pervasive engine V8 running on win 2000, and try to access to that database with a Linux client with SQL. I think the only way is ODBC...

jmh

09-16-2004 03:04 AM
jmh

Hi Group, If I'm creating a new View in Pervasive SQL Control Centre (v8.6) I enter my new view as (for example) SELECT OracleCount.Id,...

ChrisM

09-10-2004 07:29 AM
ChrisM

How would I raise a number to a power in a SELECT statement computed column? I have tried the "^" and the "**" operators with no success. I...

Tim Farrar

09-10-2004 06:31 AM
Tim Farrar

I have a DDF that I can view and with which I am working in SQLScope. Is there a way to generate SQL scripts for the "CREATE TABLE", the "CREATE...

Tim Farrar

09-10-2004 06:26 AM
Tim Farrar

Just to make sure, you DID replace <input_file.DTA> with the name of your datafile, right? As in: BUTIL -SAVE FILENAME.DTA OUTPUT.UNF Also, it...

PeDe

09-09-2004 10:43 PM
Bill Bach

Hi, Can someone tell me if it is possible to create a user defined scalar function in Pervasive? eg say I wanted to write a function called MyFixIt...

ChrisM

09-09-2004 10:36 PM
Bill Bach

In Pervasive.SQL v7, I have not been able to create a VIEW that includes a CAST expression. I get Scalable SQL engine error #845. E.g., CREATE...

Tim Farrar

09-09-2004 11:56 AM
Tim Farrar

I am using Pervasive 7 and VB6.0. I am currently using the ODBC driver and Scalable SQL to run queries. Recently however we have been having...

henry

09-09-2004 10:49 AM
Gil

Hi, I installed PSQL 8.5 Workgoup on a Win2kSP4-computer (AMD XP2400+, 256MBRAM). than I install the 8.6 update. All this without any error - all...

nmm

09-08-2004 05:06 PM
nmm

Hi, I need to export data in a Btrieve 7.x data file to an ASCII text file. I do not have the DDF's, I only have the evaluation copy...

fcgdoubts

09-02-2004 12:22 PM
Gil

Hi, I am running pervasive 2000i. I have problem with this procedure create procedure del_table (in :wtable char(10)) as begin delete from...

Bre-x

08-27-2004 11:28 AM
ChrisM

Hi, I'm trying to call a Pervasive stored procedure from DotNet. Parameter in do net is declared as type...

ChrisM

08-26-2004 12:33 PM
ChrisM

Hi, I am writing an application that requires a multi-level tree structure. I'm storing the data in a table of the form ID Description ...

ChrisM

08-26-2004 10:17 AM
ChrisM

Hi, I just upgraded my development machine (WinXP Pro SP1 & VS.NET 2003) to Pervasive.SQL 8.6 (from 8.1) and installed the "Complete" 8.5 SDK....

Greg Doherty

08-25-2004 09:45 PM
Greg Doherty