HobbyC
asked on
Sage Line 50 "Unable to Connect to data Source"
I have a network with SBS 2003 running, and Sage Line 50 V12. All machines run fine - with one older machine I am having a problem with printing reports and invoices. When you hit print it tells you "Unable to Connect to Data Source - check Configuration".
I have trawled the web and it seems to be an ODBC driver problem. I have tried re-installing the ODBC driver from the Sage files on the server - it installs OK. I have also tried opening Sage directly from the server file directory to see if that makes a difference.
I have also had this problem intermittently on a laptop which connects to the network wirelessly. can't get to the bottom of it. The default printers that Sage uses for these reports are all installed on both machines.
Is there anything else I am missing that would cause this to be a problem?
I have trawled the web and it seems to be an ODBC driver problem. I have tried re-installing the ODBC driver from the Sage files on the server - it installs OK. I have also tried opening Sage directly from the server file directory to see if that makes a difference.
I have also had this problem intermittently on a laptop which connects to the network wirelessly. can't get to the bottom of it. The default printers that Sage uses for these reports are all installed on both machines.
Is there anything else I am missing that would cause this to be a problem?
We had a similar issue on a different version of sage; however it was occumpanied by several other error messages. It turned out that we have multiple users accessing sage at the same time using the same u/p. We solved the issue by ensuring that all users had their own u/p.
I would check the "company" file this is in the installation directory eg c:\program files\sage\accounts
open it using notepad and check that there is not a trailing slash on the path to your data.
open the demo data and see if you can print from that
let me know how you get on.
open it using notepad and check that there is not a trailing slash on the path to your data.
open the demo data and see if you can print from that
let me know how you get on.
ASKER
The COMPANY file is showing "c:\program files\sage\accounts"
I opened the demo data, and I can't print reports from that either.
I find that if I'm in the customer module and click on "Print List", I can connect to the printer and print this list out, but anything with a report format pulls up the error message.
If Sage can connect to the data, and connect to the printer, it must be something to do with where it gets the report layout data from. Is there a different file containing the path to the layout data, maybe?
I opened the demo data, and I can't print reports from that either.
I find that if I'm in the customer module and click on "Print List", I can connect to the printer and print this list out, but anything with a report format pulls up the error message.
If Sage can connect to the data, and connect to the printer, it must be something to do with where it gets the report layout data from. Is there a different file containing the path to the layout data, maybe?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I uninstalled and re-installed Sage on the client using netsetup from the server, and the program will now print reports under various different logins, so immediate problem solved.
I looked in the Help > About > Directories and it shows:
Program Directory: C:\Program files\Sage\Accounts
Data Directory: \\SERVER\Sage\Accounts\Acc
These are the default settings when I install Sage on clients.
The "COMPANY" file on the server shows "C:\PROGRAM FILES\SAGE\ACCOUNTS".
Do I need to change any of these settings?
I looked in the Help > About > Directories and it shows:
Program Directory: C:\Program files\Sage\Accounts
Data Directory: \\SERVER\Sage\Accounts\Acc
These are the default settings when I install Sage on clients.
The "COMPANY" file on the server shows "C:\PROGRAM FILES\SAGE\ACCOUNTS".
Do I need to change any of these settings?
The company file contains the path to the data that the client is using.
This SHOULD, in your case, be \\SERVER\Sage\Accounts\Acc
The file itself should be in the program directory in your case C:\Program files\Sage\Accounts
The only reasons I have encountered for this are, the installation directory being another directory or the file not being the company file, (but a saved copy perhaps company.txt with the file extension hidden).
This SHOULD, in your case, be \\SERVER\Sage\Accounts\Acc
The file itself should be in the program directory in your case C:\Program files\Sage\Accounts
The only reasons I have encountered for this are, the installation directory being another directory or the file not being the company file, (but a saved copy perhaps company.txt with the file extension hidden).
ASKER
Thanks - uninstalled and reinstalled Sage on the machine and the problem seems to be solved.