Instructions to share the program out to other machines.
You will need to share out The Order Exchange folder this is usually located as shown below in its default location;
C:\Program Files (x86)\The Order Exchange\The Order Exchange
The application is called TheOrderExchange.exe (Application file)
You will need to create a short cut to that file using UNC path and copy this short cut to the desktop.
Issue 1: Cannot connect to data base.
Open up the TheOrderExchange exe config file and check the connection string ensure you are not using local but is using the full SQL instance name
e.g. instance name
Issue 2: No permissions
All users must be granted access to the SQL database this is usually set in the SQL Management Studio
For The Order Exchange data base give all users db owner access.
Issue 3: Cannot connect to accounting system.
Users do not have access to accounting database and executables, please check all paths and credentials.
Issue 4: Unable to generate or print reports in The Order Exchange
If your is issue is a Crystal Error then you would need to install Crystal and ODBC installation files
We have provided 32bit and 64bit installation that can be installed through the menu under Administration => Install => Crystal Reports
The installer will download to the order exchange program folder in a sub folder called installs and should start automatically. If it does not start then go to %PROGRAMFILES(x86)%\The Order Exchange\The Order Exchange\Installer and run it manually
You may also need to install the following
- SQL Native Client 10
- SQL Native Client 11
- 128 Barcode Font (this needs to run as admin when installing)
Please contact support if you need more information
Issue 5: Everything is setup but the Client cannot connect to the SQL database through the network
Ports and protocols used by Microsoft SQL Server database engine (SQLServer).
About this task
Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
- Enable remote connections to your SQL Server.
Microsoft SQL Server by default uses TCP 1433 but this can be changed using SQL Server Enterprise Manager or the database Management Studio.
- Enable TCP/IP.
- Open the 1433 port in your firewall.
- If you are using a named instance, create an extra rule in your firewall with the port 1434.Note: For a named SQL Server instance (e.g. [yourServerInstance]\SQL2012SP2), the firewall needs an extra rule on the UDP protocol with the specific port 1434. Without this rule the system will return the exception
error: 26 - Error Locating Server/Instance Specified.
- Display the firewall advanced settings by navigating to Control Panel > System and Security > Windows Firewall > Advanced settings.
- Select Inbound Rules in the left-hand pane, then click New Rule in the right-hand pane.
- In the New Inbound Rule Wizard, Rule Type step, select Port.
- Protocols and Ports step, select UDP and set Specific local ports to
- Action step, select Allow the connection.
- Profile step, tick the Domain checkbox.
- Name step, enter a name for this rule, e.g.
Named instance port 1434.
- Select Finish.
- If it still not working make sure the shared PC has latest SQL server native client installed.
a. Copy the SQL server native client from S drive, to the shared PC and install 10 and 11
7. Open ODBC Data Source Administrator
a. Under System DSN add a new one
b. Put the server name and Name as test
c. With integrated Windows authentication
d. Change the default database to TheOrderExchange
e. And then Finish
8. If this doesn't work go to the server PC and make sure SQL server Browser Service is running.