Recent content by mirtheil

I was going to ask a few questions but you've already answered them. Because the Pervasive engine still works for other clients, this seems to be related to the Flask API side of things. Here are a few questions that I still have: - Once you get the error, does it continue until you restart...

I'm reaching out to a few contacts I have from my Pervasive SQL days to see if any of them are aware of a good set of DDFs for Sage 50. If I find anything, I'll let you know. Mirtheil http://www.mirtheil.com

When using the Control Center (since v9) there have been three buttons. They are "execute into text", "execute into grid", and "execute all" (I think). In the picture below they are disabled but are the three next to the red arrow. They are enabled after you click the Execute SQL Commands...

The Actian DDF Builder is included with the Actian Zen Client / engine. It's called "Zen DDF Builder". Personally, I prefer using CREATE TABLE statements to create the tables within a database or get the DDFs from the vendor of the application. Mirtheil http://www.mirtheil.com

This suggestion is more for debugging but I would suggest checking one of the properties of the SqlClient. Maybe the UserName or Status or IP. You're right, not too many are using Python. I've used VB, C#, Delphi, and C / C++ with the DTO or DTI interfaces. I'm not as familiar with Python...

Because you aren't posting your code, I have a couple of questions: 1. Are you checking the result of the Connect? 2. Are you checking the count of SqlClients? 3. Before you Disconnect the SqlClient, are you checking that it's a valid session? 4. Have you tried the VBScript example in the docs...

The queries you've tried won't work because Pervasive doesn't support them. What is the command line you are using for the BDU. BDU must be run where the Pervasive engine is running. If you are running it on the client, you will get the "error 3392: Cannot open DBNAMES.CFG file" message. An...

As posted in another forum: This is my first attempt at it but it seems to work based on your data. I make no guarantees on performance on a larger data set. There may be other better ways too. select distinct part, description, location, t_fd.First_Date, t_fd.lowest_cost, t_ld.Last_Date...

It is very possible. I wrote a scanner about 12 years ago for the company I worked for. Unfortunately, I don't have the code. I just haven't had the time to get back to this. It looks like you're not going far enough into the WNetEnumResource list. I found a console app (at...

What problem are you having? Is the code crashing, erroring out, giving wrong results, etc.? What is your end goal? Mirtheil http://www.mirtheil.com

It's been years but I've run the PSQL engine through a VPN and don't remember any specific problems. If you load the Pervasive Control Center and run a query or Function Executor and open a data file and read several records, does it work at a normal rate? Is the EXE that's displaying the...

What have you tried? What problem are you having? What database are you using? Your statement seems wrong. It generates something like: select * from bimar WHERE bimar.fname LIKE ''*''&''VALUE''&''*'' where VALUE is the value in Edit1.Text. Your SQL would probably be better like...

What do you mean by "the problem is the table?" The DDFs are there to describe the data file. The "table" is just a logical definition of the record structure of the file. What are the indexes on the data file? You can get that information by issuing a BUTIL -STAT on the data file. It is...

What are the data types for these fields like PO_NO or Router_Type? Are there indexes on these fields? Did the DDFs for these tables come from the ERP company or somewhere else? I've seen cases where the DDFs have the wrong datatype and it can cause problems like you're seeing. Mirtheil...

If you change the query to: Select * From PO_DATA_TABLE Where PO_NO like '%12345%' Do you get the same results in all of the databases? If so, you can compare the results to determine which ones are missing and what character is left padding the PO_NO. If this is a data issue, reinstalling...