• 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…

  • ODBC Connection Access Denied (Password error)

    Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.

    Over the past 10 years I have always managed to make the appropriate adjustments…

  • 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…