Search:

Type: Posts; User: Jim Mulenos

Page 1 of 14 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    360

    Re: mySQL driver options

    Thank you Marcia, I'll look for that WAY helpful (and thank you Mike). btw Marcia, your Synergy 2019 video on moving to mySQL rocked! We are moving headlong from Pervasive 11.3 on an AWS EC2...
  2. 19.1 SQL Conversion Wizard - mySQL version option

    In the DF 19.1 SQL Conversion Wizard might there be a way/method/option to set the converted MySQL revision level? The converted file appears to end up at revision 5.7.x. I'm curious if the Wizard...
  3. Replies
    0
    Views
    80

    19.1 client install error

    This customer has been running Dataflex 19.0 on AWS in 30+ Windows server 2016 workspaces for some time w/no problem.

    Time to move up: Install & registration of Dataflex 19.1.56.138 client in...
  4. Re: Dataflex 19.2 Client Install /m option

    Thanks for “the subject fix” Stephen. And the pointer Mat. Two comments:

    (1) I saw this new install doc and nowhere in lots of doc searching did I find that the old /m option is now obsolete,...
  5. Re: Dataflex 19.2 Client Install /m option

    did I get your attention?
    oops - I meant Dataflex 19.1 in the subject!
  6. Dataflex 19.1 Client Install /m option

    We can't seem to get this to work in a Windows10 Pro shortcut or commandline:

    "C:\Users\Admin\Desktop\DataFlex 2019 Client 19.1.56.138.exe" /m=DataFlexClient.cfg

    The /m option is recognized in...
  7. Connectivity Kit 6.3 mySQL-E performance

    We are about to choose between the Mertech mySQL (native) driver and this new DataAccess CK mySQL-E (odbc) driver to connect to AWS Aurora. The Mertech site claims that ODBC is slow. Performance is...
  8. Replies
    3
    Views
    360

    mySQL driver options

    Do I have it right that the only two ways to access a mySQL back-end from VDF19 are:
    - Dataflex ODBC driver, or,
    - Mertech native mySQL driver?

    It's decision time. Our next move, right now, is...
  9. Replies
    4
    Views
    426

    Re: 1 workspace w/2 sets of INT files

    Exactly, PITA. We’ve been solving that with separate classes of SQL code and using a global property to call the appropriate methods. With that I believe that pointing to separate folders of INT...
  10. Replies
    4
    Views
    426

    1 workspace w/2 sets of INT files

    Currently on Vdf 19 using native drivers and Pervasive 11.3 in back.
    Moving soon to Vdf 19 using Mertech drivers and MySQL in back.
    Too much work keeping multiple workspaces parallel as we test...
  11. Replies
    21
    Views
    870

    Re: Best way in DF to Zip files?

    7-Zip has worked perfectly with BTR files for years for us - about 10 Gig every night
  12. Replies
    29
    Views
    3,410

    Re: MS Word Automation.

    We have been using the VDF (now ver 19) with the MS Word COM object, and Word 2007 for years to produce (literally) thousands of pages of legal documents per day, all from an unattended vdf-based...
  13. Replies
    18
    Views
    1,076

    Re: Error 12289

    The OLD W3ODBCCI.DLL PERVASIVE ODBC INTERFACE was 11.30.51.00 dated 1/8/2013
    The current W3ODBCCI.DLL PERVASIVE ODBC INTERFACE is 11.31.70.00 dated 5/27/2016

    The program is INSERTING records from...
  14. Replies
    18
    Views
    1,076

    Re: Error 12289

    I just spent a few days dealing with ODBC drivers and Error 12289 and here's what I found out that may help others with this. In this case we are INSERTing records from about 2000 separate Pervasive...
  15. Re: Use SQL to copy records to non-identical database

    Thanks for your assistance. Here's some code that may help the next developer that wants to do this. Doing this relational has turned a 10+ hour (formerly transactional) process into about 90...
  16. Re: Use SQL to copy records to non-identical database

    Michael & Martin, I agree this is the solution, thank you. I was looking for some way (like LOOPing with FIELDINDEX) to not have to hard code (up to 148) selected field names.
  17. Use SQL to copy records to non-identical database

    PervasiveSQL 11.3 and VDF19

    OLD.BTR has 120 fields
    NEW.BTR is exact same filedef as OLD except there is a pre-pended new field 1 totaling 121 fields
    Task is to copy all records from OLD to NEW,...
  18. Replies
    3
    Views
    288

    Re: Sqlstmtattrib_rowcount

    Dang it, did I just find the answer?

    Send SQLExecDirect of hStatement ("select COUNT(*) from " + sFile + " where MASTER_CLIENT=" + (String(piMasterClient(Self))) )
    Get SQLFetch of...
  19. Replies
    3
    Views
    288

    Sqlstmtattrib_rowcount

    I've read a lot of related forum posts, and, with VDF19 and Pervasive 11.3 the iClientRecordCount in the following code still comes back as -1

    Send SQLExecDirect of hStatement ("select count(*)...
  20. Re: FIND LT: DAW Pervasive vs Mertech MySQL driver

    Thanks all. I'm not hearing consistency and I'm still looking for the deeper understanding: On a simple numeric 1-segment unique numeric index...... after [F5] clear with the focus on the indexed...
  21. FIND LT: DAW Pervasive vs Mertech MySQL driver

    We've been working with the great people at Mertech for a few months in a desire to move a VDF19 application back-end from Pervasive to MySQL using the Mertech MySQL driver. The conversion works...
  22. DF_FILE_RECORD_LENGTH returning incorrect value

    We have a Pervasive 11.3 BTR file that clearly shows on the Parameters tab that both the RECORD LENGTH and RecLen Used is 2960. The DEF file newly created agrees. However Get_Attribute...
  23. Replies
    18
    Views
    1,102

    Re: Does the file exist?

    So there's LOTS of ways to check if a file exists. I'm curious: What's the BEST way?
    Most efficient...
    Fastest...
    Least resource usage....
    etc...
  24. Replies
    1
    Views
    295

    Vertical ScrollBar object

    When I browse the object tree of a LIST object (I know, obsolete!) I do not see the VERTICAL SCROLLBAR listed as an object. When I trace clicking on this it appears to to list as get_object_id...
  25. Replies
    15
    Views
    982

    Re: Pervasive Standard Compression

    Stephen and Sam, I also totally agree..... that rebuilding files will always decrease physical file size. My suggestion is that when designating Pervasive file format in DBB that the Compression...
Results 1 to 25 of 347
Page 1 of 14 1 2 3 4