Managed by the FaxBack Support Team
This article applies to FaxBack Fax On Demand

SOLUTION

Fax-on-Demand Reports across a LAN
Copyright © 2007 FaxBack Inc.


We have a tested procedure to allow anyone on a local LAN to run FaxBack fax-on-demand reports without the requirement for remote users to create an ODBC data source on their machine.

For use with Voice Server version 10.0.0.13 or later and NET SatisFAXtion version 8.1 or later.

Here’s the steps:
1. On the FaxBack Server, follow the steps 2 though 17 below:2. Open this file in MS Access: C:\faxback\logs\VoiceServerLogging.mdb
3. Export the tables VO, and DO to the ODBC Data source “NET SatisFAXtion Logs”. Give the tables the names VO1 and DO1 respectively
4. Download and Install the Microsoft SQL 2005 Management Studio Express from here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
5. Open this application on the database NET SatisFAXtion Logs (default) and delete the existing tables VO and DO and then rename VO1 to VO and DO1 to DO
6. Create a file DSN with access to the ODBC Data source “NET SatisFAXtion Logs” The login is SA password: “netsatisfaxtion”
7. Edit c:\faxback\faxback.ini Change
DBStats=Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Faxback\logs\voiceserverlogging.mdb
to
DBStats=DSN=NET SatisFAXtion Logs;UID=;PWD=;8. Shut down and restart the voice server. Make a test call to the FaxBack IVR system.
9. Open c:\faxback\logs\Reports.mdb
10. Delete the existing linked tables DO and VO
11. Right-click on the Tables screen and select “Link Tables”
12. Select the data type as ODBC and use the System DSN “NET SatisFAXtion Logs” Select the tables DO and VO
13. When you are finished with the Linked Tables wizard, you should see two new tables in the Tables screen in Access: dbo_VO and dbo_DO
14. Rename these tables to VO and DO respectively
15. Run some reports to verify that the data is live. Run a report including the current date and verify that the test call you made in step 8 is shown.
16. Exit MS Access.
17. Copy this DSN file and c:\faxback\logs\Reports.mdb to your network location

MOVE TO ANOTHER MACHINE
A. Open Reports.mdb from the network location
B. Delete the tables VO, DO and FAX
C. Select the data type as ODBC and browse to the DSN file you created in steps 6 and copied to the network in step 17
D. Use database login SA password “netsatisfaxtion”
E. Select the tables VO DO and FAX
F. When you are finished with the Linked Tables wizard, you should see three new tables in the Tables screen in Access: dbo_VO, dbo_DO and dbo_FAX
G. Rename these tables to VO, DO and FAX respectively (deleting the existing tables of those names.)
You can now run reports from Reports.mdb on the network location, from any machine! When REPORTS.MDB is accessed on the network, the user will get an ODBC link failure. They simply have to enter the login and password (SA, netsatisfaxtion).

Copyright © FaxBack, Inc.