Results 1 to 8 of 8

Thread: Setting up an ODBC Connection to Pastel 14 in Windows 10

  1. #1
    Junior Member
    Join Date
    Jun 2018
    Location
    East London
    Posts
    21
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Setting up an ODBC Connection to Pastel 14 in Windows 10

    Hi,
    Im hoping SOMEONE can assist me. Back on Pastel after an 18 year break! I'm trying to set up a connection in Windows 10 to Pastel 14 via ODBC and although I managed fine in Windows 7, i'm becoming increasingly frustrated at the difficulty in Windows 10. I find the reporting in Pastel very limiting and would like to bring specific tables and fields through into Excel for better reporting. PLEASE HELP

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    If you have the Sage Intelligence module on your Pastel V14 package, you can create customised reports in Excel, and the module automatically creates the ODBC connection when you first run a report.

    However, if you want to do it manually or if you don't have the Intelligence module, open the Pervasive Control Centre by typing in PCC in the Run field of Windows. Then click on the "New Database" link and the rest should be straightforward if you've done this before.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. Thanks given for this post:

    AnnaC (27-Jun-18)

  4. #3
    Junior Member
    Join Date
    Jun 2018
    Location
    East London
    Posts
    21
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Hi Neville, it seems that I don't have Pervasive Control Centre. I type "PCC" in the run field and it returns nothing?

  5. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Anna,

    The Pervasive Control Centre is automatically installed if Pervasive has been installed on your computer.

    In Windows 10, go to the Start menu, scroll down to Pervasive and open it and you should see a sub-menu called "Control Centre and Documentation".
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  6. #5
    Junior Member
    Join Date
    Jun 2018
    Location
    East London
    Posts
    21
    Thanks
    7
    Thanked 0 Times in 0 Posts
    I've checked but there is only a folder PERVASIVE which definitely doesn't have a control centre listed?? Befuddling!!! Where to from here? Can I download from somewhere?

  7. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Anna,

    You will need to reinstall Pervasive, this time making sure that it is a full installation, not a custom installation, and then the Pervasive Control Centre should be installed. If you need help with this, send me a direct email and we can arrange a TeamViewer session.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  8. Thanks given for this post:

    AnnaC (11-Jul-18)

  9. #7
    Junior Member
    Join Date
    Jun 2018
    Location
    East London
    Posts
    21
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Thanks Neville, i'll try that

  10. #8
    New Member
    Join Date
    May 2016
    Location
    Boksburg
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Add remove software
    find Pervasive
    Select modify
    make sure all tools are installed

    Click image for larger version. 

Name:	pervasive.jpg 
Views:	151 
Size:	42.8 KB 
ID:	8480

Similar Threads

  1. Quickbooks ODBC Connection
    By Krono9 in forum Accounting Forum
    Replies: 1
    Last Post: 13-Dec-16, 07:20 AM
  2. Pastel Payroll ODBC query
    By JenineB in forum Accounting Forum
    Replies: 0
    Last Post: 12-May-16, 09:09 AM
  3. Replies: 1
    Last Post: 12-Mar-14, 11:42 AM
  4. Pastel Payroll ODBC
    By JenineB in forum Accounting Forum
    Replies: 4
    Last Post: 05-Apr-13, 10:25 AM
  5. [Question] Pastel ODBC
    By Cassie in forum Accounting Forum
    Replies: 2
    Last Post: 09-Jul-09, 08:26 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •