Top Solutions

I am working with the ERP system Syteline (v.6.01) which uses a Progress database.  Is there a way to export the data of a given table, say the Customer table, to a csv file?  If so, what is the code to do so?  Will the csv file cotain the field...

The Pervasive web site is no help.  I think I downloaded ver 9.11.63.00 from a Microsoft site a long time ago but have lost the instructions.  Thanks

I use Odbc to run a query against a progress database. Here is the connection string:
Provider=SQLOLEDB;DRIVER=Progress OpenEdge 10.1A driver; HOST=hostName;PORT=XXXX;DB=dbName;UID=XXX;PWD=XXX;

This works fine on my PC. But when I deploy to...

I am trying to install Pervasive PSQL 10.10 client drivers on to a windows 2008 x64 server. The install completes with no issues, however there are no ODBC drivers installed. Also the Pervasive "Control Center" isn't installed either. I tried...

am getting a btrieve error of 3103 everytime I try to start my database program. can anyone tell me what the problem is and how to solve it?

I am also getting error 3012 on several of my other stations. Can you help?

Matt

Where can I find a online tutorial with example of PROGRESS 4GL?
I need a very simple tutorial to teach me the following
if then else, case, loops, how to connect database....retrieve records, etc.
anyone know?
thanks!

Hi,

Below is the output of my PVSW.log file which I have obtained from System32 directory. The network is setup with pervasive / betrieve workgroup v8.6. All users log files are the same. I have WINS setup on the Windows Server 2003 Server and...

When I attempt to Refresh data in Crystal Reports 11 Pro I get the following error after entering in my Parameter fields, and entering my vaild username and password for accessing my database:

Failed to retrieve data from the database....

What is the syntax for a multi-dimensional array.

Here's a single dimensional array in Progress 4GL

Define Variable MyTopHeavyArray As Integer Extent 3 Initial [36, 24, 34] NoUndo.

Display MyArray[1].  /* shows 36 */

Thanks.

I need to find out where can download the btrieve odbc driver for windows for free so that i can access btrieve data from ms access, which i don want to install the btrieve/pervasive database program. i need to do so cause i have btrieve data in...

Hello,
I have an SQL database that connects to a Progress database using linked servers with a DSN.  The DSN uses datadirect drivers.  When in SQL, I query Progress and I get the data just fine if I use the credentials of sysprogress user. ...

I need to retrieve data from a Pervasive/Btrieve database on a remote webserver from an ASP page.

Pervasive client 9.5 is installed on the server where the ASP page is located.

My connection...

Set myRecordSet =...

I have a customer that can run a btrieve application fine from any workstation and even from the server.  But when he tries to run it remotely throught terminal services he gets a status 3014

Status 3014
The MicroKernel router could not...

I'm trying to copy a progress database to another server
On the old server i've made a backup using the commando: "probkup online mdrspro mdrspro.BCK"
It generates a .BCK file of aprox 4GB.

Then I've copied the backup to the new server's...

Hi,

I've been searching various sites and have come upon various solutions to connect to Oracle from ASP. But, unfortunately none of them work and all i am left behind is frustration. I have provided all the versions of drivers used, various...

We use an applications called TAS.  It uses Btrieve and we have used Pervasive SQL v8 SP1 as a transactional server engine for some time on a Netware 5 server.  We've recently moved this to a Windows 2003 Server, and now notice that ntdbsmgr.exe...

I am trying to run the below query in progress database, but keep getting an systax error :column not found,.. all of the culmns are there in DB.. I think the progress db doesn;t like a derived table ( join)... How can I fix this problem?
...

I need to reach in and look at data in Worldship..

I'm using Btrieve 6.15 Microkernel database engine from a c++ program and have a local network.
Pc used as server has Windows XP
Clients has Windows 7
The problem is that when trying to connect from Windows 7 PC nothing happens. (PC hangs...

i have a 3rd party application that uses pervasive database. One of the files in the database is growing way tooo much with all the data that needs to be in there, and apparently now has 3 extension files.
tableName.^01
tableName.^02...

I am working as an IT consultant and one of my clients is using (circa 1998) Yardi v3.2 application that sits on a Microkernel v6.15 Client/Server database with 3 client licenses.  Several months ago the Win2k server died and was replaced with a...

Hi,

We have an old PROGRESS V9.1b database.
I like to  start it in single user mode as follows : (I don't remeber if this is correct, also I don't find many documentation about PRO) :
PRO /dir//database/DATABASSENAME

but I receive...

Hi there.

I have a client that has an old DOS Btrieve database with several .dat files named customer.dat, etc. I am looking for some kind of utility to convert these .dat files into something usable, such as a csv file. Any suggestions would...

Hi Experts,
I have Cognos 8.4 on a Windows 2003 machine. It is using SQL server as a backend database. I need to install Cognos version 10 on a new Windows machine and using SQL server database. There are several users that have created reports...

Does anyone know, where I can download Butil.exe or Butil.nlm that works for Btrieve 5.10a version - Novell Netware ?

I already tried Butil5 and Butil7 from www.goldstarsoftware.com/download.asp
but it doesn't work.

Any Idea ?

Thx You...

I am completely new to databases beyond Microsoft Access. Learning how to use SQL is still a project for when I have time in the future. :|

I have a database, containing quite a few tables, all in .BTR format. I can get Pervasive.SQL 2000i to...

Hello Experts,
    I am developing a website for a company that uses Pervasive Progression for their main operating program.  I need to get a dump of the data, but I do not know Pervasive Progression or how to deal with .btr files.  I have...

Hi,

I'm trying to write a console application in VB.net that will query an openedge 10.1b database and return the results (yeah, I could use the Progress tools but I wanna do other stuff with the data independent of the openedge server - this...

Hi

Is there a way to group records by a field within a table within a 4gl query?

e.g. I have two tables, with a 1 to many relationship - there is a unique identifier, but table 1 contains 1 line per identifier and table 2 contains several...

The network concerned has 2 ethernet connected PC's running XP  and Windows Server 2003 with the domain 'K9'.
One of the PC's can use TASbooks but the other cannot.
Tas was installed incorrectly and has now been corrected, however one of the...

Hi all,

I am trying to url encode a url string where one of the values contains a a single quote.  Because of this, it causes a problem when the url is requested in the browser.  I tried replacing the quote with a ' but it still wont...

I have a file called CUSTOMER.BTR that is corrupt (as reported by software Business Vision 32). I would like to get this file working again, with as little missing data as possible.

Following other forum postings I've seen with...

We are currently exporting our old DB developed in a Dataflex fro DataAcces Corp to SQL 2005 (see pic for atcual version info).  We need the ODBC to verify contents of the database prior exporting to SQL (we know we can export all to ASCII & then...

Hi Everyone,
I have a question on loading data from an IXF file into a DB table(s).
The IXF is a backup from one DB and contains several years worth of data from a source. I want to load only the "new" records to the target, ones where a...

I need an ODBC driver for a btrieve database, I only have the .DAT files, and need to convert them to MSSQL server (I use the MSDE2000). But first I want to access the data, and for that I need an driver, and some instructions how to set it up....

I'm having a nasty time trying to find string function sounterparts in 4gl, such are left, right, mid and instr,

Can someone direct me to a good 4GL string function resource?

Hi I am Using pervasive 8.6 workgroup on Windows 2003 server.

When accessing the pervasive monitor utility and selecting active users, I get the error message "Insufficient rights to get or set information". I have tried using the connect...

My company is trying to run some reports against Positouch data.  The data appears in an INDATA.DB file (from what I can tell) and Positouch claims to be fully odbc compliant (don't we wish!), but I'm stuck trying to just access the data in the...

We are developing an application that uses Progress (I know, not my choice) databases on Windows 2003 server. Currently, we have the application up and running in a test environment.
We are in the process of moving it to another windows 2003...

Hi,
I have an application whihc uses Pervasive SQL as a backend.
Is there any tool for Pervasive similar to Microsoft's Profiler for MS SQL server?
i would like to monitor the queries being executed behind the application?
can this be...

I have been tasked with accessing data from Peachtree and importing it into either Access or SQL server.  I am not sure what options are available to me or even what database Peachtree uses (I believe it is Peachtree).  CN anyone tell me if...

I removed cyrstal report 7.0 and now i am trying to install it on my PC
and it is giving me the following error.
While registering OLE Servers, Setup had a problem with Reg.dat, Shell.dll or disk space

I need to install this program since I...

im looking for DSN-Less .NET Connection String for btrieve,

provided with:
file path: C:\home\pronto\data\ogawadata
to table : eg. SOR5DLYS0 and SOR5DSP2

below doesnt seem to work with error:
data source name not found and no default...

We have a custom designed Microsoft Access database that uses ODBC links to a Btrieve database and it worked up until yesterday when we had some problems with some of the tables.  We shut down the Btrieve database and repaired the tables, then...

I am using Pervasive.SQL engine to read data from a lytec database. I have found that there is a "Master" user id that is suppose to have no password unless security is turned on. Apparantly this was turned on as it now asks me for a password....

I am trying to access a progress database using Crystal REports 11 and when I design a report and try to run it it tells me that it failed to retrieve data from the database"

What is the SQL command to list all tables in a database?
What is the SQL command to list all columns in a table?

how can i open .mdf files( SQL server files) and access the data. I  downloaded MSDE software but unable to install it says Strict username and psaaword required . were should i look for that. Are there any other solutions.

I'm very new to 4GL in Progress OpenEdge 10.1 very familiar with SQL92. My question is this. Is there a IN condition within a WHERE clause in 4GL?

I want to convert the following SQL statement into 4GL:
SELECT jc_job.kco, jc_job_num,...

Hi,

I have old version of Btrieve Database - Novell Netware.

how to convert dat files into csv format. What we need is csv format with the first row is field names.

sample file :
http://rapidshare.com/files/261447336/FF4BBKD.DAT.html
...

Even though i specify a port number in my ODBC connection string to a Progress database, I can see that that the actual port# that is used in the TCP connection is different. Can anyone please explain why this is so?

For example, int the...

I am new to informix 4gl technology. Will i get get any learning materials and programming guides to start with coding in Informix 4gl?

Using Btrieve Classes for .NET v2, I'm able to open tables and step through them in different index orders, but only from the start. When I use GetEqual or GetGreaterOrEqual I can only step a dozen records forwards before it hangs the thread so...

I recently did an update to a class that connected to Pervasive databases via ODBC and OLEDB
ODBC is what  we have been using for years. I recently added OLEDB which I discovered is not compatible 100% with Pervasive versions below 8. A fair...

Can anyone tell me what the following errors mean? From my Pervasive server log.
I have (hopefully) repaired the table, but I would like to ensure this doesn't happen again if possible.

03-11-2004 10:07:03 NTMKDE          0000007A...

We are getting 3 error boxes when opening a 1992 yardi database program file on windows XP.
1: Error: file not open. op: close, file pmuser.dat
2: Error: file not open. op: get equal, file pmuser.dat
3. error: lock error. op: open, file...

ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS
ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr...

How do I export a range if invoices from a DacEasy Version 10 Database.

DacEasy Version 10 uses Btrieve but does not provide ddfs. I created ddfs myself and tried to use pervasive's ODBC Driver but that sometimes fails with "Number Out Of...

A client has CYMA accounting that uses a Pervasive DB engine. On one computer they are getting an error 161 (maximum user count exceeded), but I can install the software on other boxes without issue. I can also uninstall and re-install on this...

Hello all,

I have an Access 2k db that uses a Pervasive (SQL V8 SP1) connection to an accounting package.  The tables from the accounting application contain invoice transactions with lots of histroy records.  I now get the following error...

I have an app running in Pervasive 10 where I know the layout and don't need or want DDF'S. Can these files be read using PHP? This would be for Web development.

I am looking for the syntax to convert a Julian date to Calendar date in Crystal Reports using a calculated field or other utilities available in Crystal

how do i check for a null value using 4GL in a select sql statement

Dear Experts,

I am looking for the help with the folloing structure of XML. The program can read a string for the following example XML and load the data into two Progress 4GL database tables.  

I am looking for a program sample which can...

i'm running progress 9 on rhel 5.0.

Where do i configure that tools accessing the progress database (jdbc / odbc openlink) from outside the server only have a read only connection to the progress database.

I need to update a Syteline (Progress version 6) ERP system from a vb.net windows app. I have created a dsn using the merant driver. When I try to update the progress table, the  command builder is only creating the insert/update statements for 2...

when ever I am trying to connect through odbc connector system accept the user and password and it is connecting.

When I am trying to connect from my application it throw the error message
08s01 [pervasive software][ODBC Interface]...

i am currently using Epicor Vista/Vantage, on a OpenEdge 10.1B Progress Database. I am trying move data from the current form im looking at, to another form with the same fields. Lets say i have pulled up the "Jobhed" table and the field...

I have a PSQL database with dates stored as :YMMDD which I am looking to convert to YYYY-MM-DD using PHP. I have done so using the code attached, but has obvious issues with the year, can anyone advise me in the right direction?

I am trying to create an Engine DSN in Pervasive 9.50.077.002
THe DSN was created in the ODBC administratior Originallty
THe Engines are running as services
when I open the PCC and browse to the
Engines\ServerName\Database\Database name
i...

I need to create a ODBC for my application in runtime, it has to check if the odbc exists if not create one.
Frontend: Delphi
Backend : Progress V9 Database
Connected via ODBC.

I have attached the screen shot for the Progress ODBC...

Experts,

The goal of this project is to move all the data from a Progress database to SQL2005  to work with the Mapping software that we develop recently sold to a client. The client's progress database version is: 9.1D

After much research...

Hello,
I am trying to use the wbmanage.exe with btrieve 6.15
When I try and open a file I get an error that says Microkernel or btrieve requester is inactive.
Could someone give me any ideas as to why this is happening. I am new to btrieve.
...

I have sql server linked with Pervasive V8.6 and when i run query in query analyzer it gives me this error.

Error converting data type DBTYPE_DBDATE to datetime.

select field one, Cast(field two as varchar(50)) from Openquery(sql,'select...

I need to connect to Progress Dbase using MS access for generating reports.  The progress dBase is on HP UX unix box and I would be using Access 2002 or if better Access 2000.  I do not need to change info in any of the dbase just read only...

I need help getting a Btrieve database to operate.

I am moving a business managment database program named Therapist Helper from Win XP x32 to Win 7 x64.  The program uses Btrieve.    This is a very old legacy application for this medical...

Peachtree 2007, reading the data files

The data files are in Btrieve/Pervasive format. Sage provides the DDF files. When I try to connect to them with ODBC, I am challenged with a Userid/password challenge. No know documentation on what these...

I need to install datadirect 4.20 32bit openedge SQL v10.0B drivers to connect to my progress database (ERP Package) from client computers.
Is there a free version of the drivers available which i can use???

I am trying to run a MS Access query on a linked table. On one of the fields I need to have a "empty" criteria that the user must specify when running the query. When I link the table and run the query I get an ODBC--call failed message. If I...

I am working with the ERP system Syteline (v.6.01) which uses a Progress database.  Available to me is the Data Administration tool where I can dump the contents of a given table into a space delimited file.  However, the headings are not...

I am trying to create an ODBC DSN using the Pervasive ODBC Engine Interface.  After entering the database name (see question below), the data file locations and dictionary locations, I click OK and receive this error.  I am logged on to the...

Hello everyone,

I have a progress database version 8.2C on an AIX 4.3 server. I want to update the AIX server to 5.3 but i dunno if progress 8.2C  is compatible with the updated AIX. Does anyone know how to fin out if it is compatible or not?...

I am trying to use an SQL stored procedure in my report (Crystal Reports 8.5), but I am not sure how exactly to do it. I have created a stored procedure in my database (Pervasive SQL 8 SP3), I have attached it. Basically, it should return only...

Hi everyone,

I've got this pervasive sql installation here - I've never used pervasive SQL, though I'm fairly experienced with other database products. Anyway, this database is about 5 years old, and for legal reasons, someone has decided that...

hello,
Please your best advice on Progress 4GL database.
We do not have any experience on it
All we know is our customers is willing to get out of it after like almost 10 years of working.
So it would be interesting if you can give us a light...

I'm new to btrieve and have no working knowledge of this, so I'm hoping someone here can help me try to figure out how to export data from a btrieve file (.btr) to a .txt file or some format like that. I have heard that I should use BUTIL...

we have a novell netware 4.11 server , running btrieve.nlm on it . we have been using diskless nodes or win 98 nodes as clients. Our main application has been developed  on magic ver 5.7 ( ms dos version). It has been running fine. When we...

We have a new System Called Epicor in which I am trying to do a calculation but can not get the syntax correct.  I was hoping some here could help me get this worked out.  I am getting a syntax error.   What I want to do is check the field...

I need to change the path of the Xf$Loc in the Xf$Name file executing a SQL statement.  (I'm using Pervasive PSQL.)  I keep getting a Btrieve #51 error - stating something like Data Record Manager owner name is invalid.  (I set the owner to...

Max point question for something that's probably simple, but outside my wheelhouse:

Our enterprise gobbled up a smaller competitor.  Within that competitor is an old SBS server that's running some payroll software called Vantage (from a...

Hi,

i have a question, i want to select ALL dates between two dates in Pervasive v10 SQL.

for example. my table with dates (dd/MM/yyyy) looks like this:

10/11/2009
11/11/2009
13/11/2009
14/11/2009

as you can see, the 12/11/2009 is...

Hi,

Suppose I have a PROGRESS table which I connect to via ODBC with the following values:

Reference   Name   Value
123   Smith   300
123   Smith   600
999  Jones   500
999 Jones 435
111 Brown  500

And I wanted to return a column...

I got the backend of a program that I have to update the software bu have to import the old data. I use Mysql in my software and need to export the Psql data to mysql format.

A client of ours uses Lytec 2005 software, we recently upgraded two of their computers from Windows 2000 to WIndows 7 X64. I can install the software fine, and even have migrated the data from the Lytec folder on the root, to the new computers...

I have a query I have built using 3 tables.  The query builder also allows for calculated fields.  What I am trying to do is add a calculated field to number the records returned.  Simply I am looking for 1,2,3,4,5 etc  This is unique for me as I...

We have one system which uses Btrieve database. The system is unusable and has .BTR files and some other DDF files but does not have FILE.DDF, FIELD.DDF and INDEX.DDF. following is the list of available .DDF files.

091192.  DDF
BANK507.DDF...

Greetings:
I have the following SQL Code that I would like 4GL code for.  I cannot execute this querry against Progress with SQL-92 so I would like to do it with 4GL Code instead.
Any help is appreciated.
PCI

UPDATE "PUB"."PartPlant"
SET...

Hi,

We are using Pervasive V8 and can't seem to open up any of the databases. We are getting "Connection to the database ... failed" with the following detailed description...

[Pervasive][ODBC Client Interface][Client LNA]Connection attempt...