How Connect To The Database Using PHP?

Sage 50 Quantum 2016 connects to the database using PHP

The CData SQL Gateway with ODBC Driver for Sage 50 Quantum 2016 may be used to access Sage 50 data from MySQL clients without doing an ETL or caching data. The methods below will show you how to connect to Sage 50 data in real-time using PHP’s normal MySQL interfaces, mysqli, and PDO MySQL.

Connect to Sage 50 Data

Provide values for the relevant connection attributes in the data source name if you haven’t previously (DSN). To configure the DSN, utilize the built-in Microsoft ODBC Data Source Administrator. This is also the final step in the driver installation process. A tutorial on utilizing the Microsoft ODBC Data Source Administrator to build and configure a DSN can be found in the help documentation’s “Getting Started”.

Under the Connection section, the User and Password attributes must be set to valid Sage 50 user credentials. These are the identical credentials that will be used to access the Sage 50 software.

Provide values for the relevant connection attributes in the data source name if you haven’t previously (DSN). To configure the DSN, utilize the built-in Microsoft ODBC Data Source Administrator. This is also the final step in the driver installation process. A tutorial on utilizing the Microsoft ODBC Data Source Administrator to build and configure a DSN can be found in the help documentation’s “Getting Started” chapter.

Please keep in mind that only Sage 50  and later are supported. Under the Connection section, the User and Password attributes must be set to valid Sage 50  user credentials. These are the identical credentials that will be used to access the Sage 50 software.

Configure the SQL Gateway

See the SQL Gateway Overview set up connectivity to Sage 50 UK data as a virtual MySQL database. You will configure a MySQL remoting service that listens for MySQL requests from clients. The service can be configured in the SQL Gateway UI.

Connect in PHP

The following examples show how to use object-oriented interfaces to connect and execute queries. Initialize the connection object with the following parameters to connect to the virtual MySQL database:

• Host: Specify the remote host location where the service is running. In this case, “localhost” is used for the remote host setting since the service is running on the local machine.
• Username: Specify the username for a user you authorized on the SQL Gateway’s Users tab.
• Password: Specify the password for the authorized user account.
• Database Name: Specify the system DSN as the database name.
• Port: Specify the port the service is running on; port 3306 in this example.

To know more about upgrading to 2019 Sage 50 Edition Click the Below Link:

https://www.accountspro.co/blog/sage-50-2019-upgrade/