Relate Accounts Production - ODBC Setup Guide - Support Services - Troubleshooting

Aug 20, 2026

Upload by Putri

Relate Accounts Production ODBC Setup Guide provides support contact details and legal notices, then focuses on troubleshooting connectivity failures to the RAP database. It explains how to verify the correct server and database names via Relate Accounts, and outlines advanced steps for enabling SQL Server client protocols such as Named Pipes and TCP/IP. The guide then walks through creating an ODBC connection using Windows system tools, covering required fields and configuration steps.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages12

Reading Time30 min

AccessFree to download

ODBC Setup Guide

Support Services

Trouble Shooting

Advanced Trouble Shooting

Creating an ODBC connection

RELATE ACCOUNTS PRODUCTION ODBC SETUP GUIDE SUPPORT SERVICES Relate is committed to strong customer services and satisfaction. At all times you will be able to make contact with our company and technical services teams. You can make contact with our support department in the following ways: Telephone: +353 (0)1 4597800 Fax: +353 (0)1 4597779 Email: [support@relate-software.com](support@relate-software.com) [Opening Times for Support: 08:00](Opening Times for Support: 08:00) – 17.30 This document is protected under copyright law and may not be reproduced in any format whatsoever without the prior written consent of Mabruk Limited T/A Relate Software. Failure with this condition may result in prosecution. The program and documentation are protected under copyright law and the program is licensed for use by the user who has completed the Software Registration agreement and the program is licensed under the conditions referred to in the Software Licence Agreement. Relate Software does not warrant that the software package will function properly in every hardware/software environment. The software may encounter problems working in combination with modified versions of the operating system, with certain print-spooling or file facility programs, or with certain printers supplied by independent manufacturers. Rigorous testing of the software is carried out by Relate Software and all documentation and help files are reviewed, however Relate makes no warranty or representation, either express or implied, with respect to this software or documentation, their quality, performance, merchantability, or fitness for a particular purpose. The software and documentation are licensed‘as is’, and the licensee, by making use of the system assumes the entire risk as to their quality and performance. Relate will not be liable for direct, indirect, special, incidental, or consequential damages arising out of the use or inability to use the software or documentation, even if advised of the possibility of such damages. In particular, and without prejudice to the generality of the foregoing, Relate will not incur any liability for any programs or data stored. Relate will not incur any costs of recovering such programs or lost data for whatever reason. We reserve the right to alter, modify, correct and upgrade our software and documentation without notice. © 2002 Relate Software South City Business Park, Tallaght, Dublin 24, Ireland All Worldwide Rights Reserved Trouble Shooting Could Not Connect to RAP Database One of the most common issues after installation is not being able to connect to the Relate Accounts Production database. Issue: After clicking on Relate icon to login, you will be told,“Could not connect to RAP Database”. This is because the Server name or/and Database name is incorrect, see Figure 1 below Figure 1 Solution: Go to a machine that can login to RAP. When logged into RAP, you need to Select Tools > Change Database. This will display the Change Database window. The correct Server name and Database name will be shown here. Take note of the Server Name and Database name and input on the machine displaying the “Could not connect to RAP Database”message. If the issue is still not resolved, see Advanced Trouble Shooting. Advanced Trouble Shooting Enabling Named Pipes and TCP/IP: Go to the Start button on your computer. Click on the Run button in the Start Menu. The Run window will be displayed. In the text field type “cliconfg”, as shown in Figure 2 below. Then click the OK button. Figure 2 The SQL Server Client Network Utility window will be displayed (See Figure 3) . Make sure Named Pipes and TCP/IP are enabled protocols. Figure 3 Enabling Protocols: Highlight Named Pipes and click the Enable button. Named Pipes will now be displayed in the “Enabled protocols by order:” list. Do the same for TCP/IP. Tick the “Enabled shared memory protocol” and Click OK. Creatin

FAQs

What should I check when I cannot connect to the RAP database?

Confirm that the Server name and Database name are correct. Use Tools > Change Database on a machine that can log into RAP, then enter the shown values on the failing machine.

How do I enable Named Pipes and TCP/IP for the SQL Server client?

Open the Run dialog and execute "cliconfg" to open the SQL Server Client Network Utility, then ensure Named Pipes and TCP/IP are enabled as protocols.

What steps are involved in creating an ODBC connection to SQL Server?

Use Control Panel to open Data Sources (ODBC), add a new data source, select SQL Server, then follow the creation steps including entering Name/Description and selecting the correct server before proceeding.

Aug 20, 2026

Upload by Putri