Summary
In this article we give solution for error 'Failed to create link. Bad file name or number' when running Sage intelligence report on Sage 50cloud Pastel Accounting.
Description
When running Sage Intelligence reports you might get error 'Failed to create link. Bad file name or number' as shown below.
Resolution
You need to open Pervasive Control Center and manually create the database link for the company that you are running the report for.
You can create the database using Pervasive Control Center as per steps below.
Creating Database using Pervasive Control Center
- Open the Run command by pressing the Windows logo key
+R on your keyboard
- Type pcc as shown below and click OK
- In the Pervasive Control Center there are two panes, on the left-hand pane expand Engines you should see the server computer name. Expand the computer name to see Databases as shown below:
NOTE: If using Pervasive Workgroup it will be the workstation name and on a Client/Server Installation it will be the Server name.
If on a Client/Server installation you need to Expand on the server’s computer name. If the server’s computer name is not showing, right click on Engines, select New and select Server. Enter the server’s computer name and click OK. - Right click on Databases, select New and then Database
- On the New database screen enter the company name on the Database Name field. The database name should start with PAS19 and then the company folder name e.g. if your company folder is DEMO, you should enter the database name as PAS19DEMO
- On the Location field click on the eclipse button as shown below and navigate to the company folder. Select the company folder and click OK.
- Once you have selected the company folder make sure that the above is as per the screenshot and you have deselected the option Create Engine DNS.
- Click Finish and close the Pervasive Control Centre
If you still have the same issue, you need to uninstall and reinstall Pervasive on the machine with the issue. Refer to article How do I Uninstall and Reinstall Pervasive Version 10 and higher if needed.