Results 1 to 7 of 7

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

  1. #1
    Junior Member
    Join Date
    Jun 2018
    Location
    East London
    Posts
    13
    Thanks
    5
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,483
    Thanks
    35
    Thanked 405 Times in 352 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "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
    13
    Thanks
    5
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,483
    Thanks
    35
    Thanked 405 Times in 352 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "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
    13
    Thanks
    5
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,483
    Thanks
    35
    Thanked 405 Times in 352 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "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
    13
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thanks Neville, i'll try that

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
  •