x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 240 subscribers
  • Views 1287 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
alilland@controlac.com

Is it possible to connect to the Pervasive Database from a Linux machine?

Posted By

Making queries from excel / crystal reports is easy on a windows computer using the ODBC connections, but is this something that has been done from Linux computers on the network? For instance, if we have an application running on a random computer controlling a TV, showing data on a graph, and that computer is a linux computer controlling the TV, the desire would be to connect to the database from the application running on linux. Obviously Sage is a windows product, not a linux product, but does are there any drivers available to connect to the sage database on linux?

  • FormerMember
    0 FormerMember

    In order to use the TSSimba.dll ODBC driver, Sage requires that the full workstation be installed. In my opinion your best bet would be to replicate to SQL using Anterra or Sage's SQL replicator, then pull the data from MS SQL.

  • 0 in reply to FormerMember

    Thank you! Fortunately, I actually have the full running workstation installed, its actually a windows computer running the linux subsystem, but to my knowledge I have not figured out a way to connect to windows DSN's from the linux subsystem. Its pretty straight forward to find files and whatnot on windows from the linux subsystem, but I havent found anyone mentioning how to connect to windows ODBC from there. WSL (windows subsystem linux) is a rather new feature for windows, and its only available when the windows computer is in "developer" mode. 

*Community Hub is the new name for Sage City