• ODBC issue (works from Excel when sysadmin has no password but not when sysadmin has a password

    Trying to connect to the Sage 50 Canadian (non cloud) database using excel through ODBC

    MySql connector allow me to select the Sage50:COMPANYNAME.SAI file and the population of the correct path to the server and port 

    Initial attempts with the sysadmin…

  • Direct DB Connections via Connection Manager | Changing Port #s

    Hi folks,

    I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0).  They host Sage on a MS Azure server.  They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

  • Is it possible to import employee pay into Sage using the SDK?

    Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…

  • Sage 50 Canadian SDK - how to do wSDBGetDBVer in c#

    I am trying to use some of the features described in the documentation that came with the SDK. In the doc, dev-progref.pdf, I've read about the methods and they all seem to start with wSDB. I've seen that the wSDB* methods can be called in C++ and VB…

  • How to find log in credentials for Sage 50 database

    I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…

  • SDKInstanceManager.Instance.OpenDatabase always returning false with no reason why or error message

    I have a C# application that executes a call to SDKInstanceManager.Instance.OpenDatabase to open the data file but it keeps returning false, and it does not give any error message as to why. I have the proper parameters sent because this same data file…

  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: 

    Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)

    But I do not know how to capture the data you are going to select in a DataTable…

  • ODBC connection failing

    I am trying to connect to the Sage 50 database using ODBC/My SQL connection.  In MySQL Connector/ODBC, I enter Sage username and password, , I select TCP/IP Server : localhost (database is local on this computer), I leave the port to default (13540), and…

  • Sage 50 SDK Canadian Edition

    is there any complete example about how to create or update a customer and assign the Tax. as it seems to not be possible with the sdk and only with a direct access to Sage 50 Mysql Database

    Thanks

  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…