Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mirtheil

    Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent

    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...
  2. mirtheil

    DDF Builder for Actian fka Pervasive SQL

    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
  3. mirtheil

    How to Execute Create View code in Actian Zen?

    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...
  4. mirtheil

    DDF Builder for Actian fka Pervasive SQL

    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
  5. mirtheil

    Error Code 7009: Data is unavailable when using DTO

    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...
  6. mirtheil

    Error Code 7009: Data is unavailable when using DTO

    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...
  7. mirtheil

    How to read a csv file in Pervasive?

    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...
  8. mirtheil

    how to select min and max value and the date for each

    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...
  9. mirtheil

    Scan the local network

    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...
  10. mirtheil

    Scan the local network

    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
  11. mirtheil

    ERP uses PSQL DB and functions slowly via VPN

    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...
  12. mirtheil

    sql problem

    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...
  13. mirtheil

    Invisible Space In my PSQL database

    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...
  14. mirtheil

    Invisible Space In my PSQL database

    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...
  15. mirtheil

    Invisible Space In my PSQL database

    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...
  16. mirtheil

    How to use a variable as table name in a procedure

    You have to build the SQL statement and then execute it. So, you'll need something like: CREATE PROCEDURE Test(in :MyTable varchar(20)) returns (DateCreated DATE); BEGIN declare :s varchar(8000); set :s = 'select a.DateCreated from "' + :MyTable + '" a'; Exec(:s); END; Don't forget to...
  17. mirtheil

    Source control for pervasive? (git)

    If your views are stored as CREATE VIEW statements in *.SQL files, you should be able to store those in a git/github / subversion / source control system without any problem. If you want to store the actual DDFs, they are just binary file and should be easy to add to version control as well...
  18. mirtheil

    Help with IDhttp and Thread

    the source page in memo take 1 second to 2 second." -- What do you mean? How long does it take to issue a GET using Postman or another HTTP tool? For example, https://cnn.com takes 218ms (and https://cbc.ca takes 223ms) to issue the GET and get a response using Postman. How long does it...
  19. mirtheil

    Help with IDhttp and Thread

    What part is slow? How slow is slow? If it's the HTTP GET, what does Postman or some other tool for issuing an HTTP show for the time / speed? What debugging have you done? If you don't know which part is slow, you should debug line by line until you find the one that is slow. Mirtheil...
  20. mirtheil

    Help with IDhttp and Thread

    What do you mean it doesn't work? How is it failing? What debugging have you tried? What code do you currently have? Mirtheil http://www.mirtheil.com

Part and Inventory Search

Back
Top