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 Dr...
Hi All,
I have managed to use the Pervasive 32 bit ODBC driver to connect to
my Btrieve 6.15 files with a lot of hard work.
The issue I am experiencing is if I connect through MS Exc...
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 conne...
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 idea...
I am trying to connect to a PSQL via ODBC
My server is Windows 2000 running PSQLV8.0
i am using a php script.
but when i try to connect to my database using the odbc_connect() function (my ...
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 Pro...
I want to query the tables for peachtree with a tool like SQL management studio, but PeachTree uses a Pervasive Database. Is there a tool where I can create views and write complex SQL?
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...
have pervasive 8.6 on a win2k server machine. I need to use excel to extract data from the database. Excel is loaded on a workstation running winxp pro....
I was going to use a system dsn a...
Hi
I have i Pervasive table that is in DOS-format. Now building a program in VB 6. For a while the tables data need to stay in DOS-format.
1) Auto Translate=True in the connection string...
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 ...
Hi,
I have a new client, who we have migrated to Terminal Server 2003. The old POS program (SellWise) is a DOS based, Btrieve 5.10n db. Access is extremely slow and each instance of ntvdm...
Hey I have a Btrieve DB version 5.0 that I need to export records into a text file. I know that I could just use the butil utiltiy and export the DB to a CSV file, but I do not need all the r...
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 objective here is to be able to report on "live" data using Crystal Reports XI. The database (if you will) is located on our LAN on SERVER1. It is structured in Pervasive SQL v9.5 and bo...
Hi everyone,
This probably sounds very simple and stupid, but I really have a problem here.
I have a few stations running legacy application that uses Btrieve 6.15. They are set up to r...
I work for a company that has given me a big under taking and I need some help in getting started. I have about 50 Manufacturing locations. The program that run the plants was written in Qui...
I want to select an entire column that is the same as my variable. I was given this solution, whihc works, but not for Pervasive SQL, any thoughts?
Hello!
I wish to know how to access my tables in .Dat (BTrieve) with Delphi.
Dont just tell me to go to Pervasive.com.
I Wish to know what exatly do i need to have instaled on my computer...
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 l...
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 bei...
Hi,
I am installing pervasive 8.6 (workgroup). When I try to change and save some configuration settings for server and client in the control center for pervasive I get an error. "Unable to...
I want to open and edit a .BTR ( btrieve ) file using VB6. I know the structure of the file and also i have DDF files. I just want to brows data in the first step and change some data in some ...
Variables in stored procedures
If I try to use dateadd like this I get an error is there a way to avoid this?
DECLARE :SPAN INTEGER;
SET :SPAN = 10;
Select DATEADD(day,:SPAN,curdate(...
I have installed Pervasive SQL version 8.60.192.30 and the installition goes through just fine. when it comes time to test the relational and transactional test they fail. Now this is testing ...
