›  Survey Software
------------------

    ›  Survey Consulting

------------------

    ›  Survey Articles

------------------

    ›  HR Software

------------------

    ›  Order Information

------------------

    ›  William Steinberg
------------------

    ›  View Cart
 Product Search help
.

Web Organization Chart

Frequently Asked Questions

Q: I have downloaded and setup the Web Org. chart Trial version on my IIS server and I try on my local development server but I get only "Type mismatch" error.
A: You have to create File DSN (and Not System DSN) and point to chart.mdb correctly.
Here is the sequence:
  • Start your control panel.
  • Click on ODBC data source.
  • If you have already created System DSN, click on System DSN tab folder, select the file and click on remove.
  • Click on File DSN tab folder.
  • Click on Add Push button,
  • Select “Microsoft Access Driver”, click on Next.
  • Type “Chart” and click on next.
  • Click on Finish.
  • Click on Select Push button.
  • Find Chart.Mdb and click OK.
  • Open your Setting.asp page
    Change the following line from:
    GetConnectionString = "dsn=chart"
    To:
    GetConnectionString = "Filedsn=chart"
  • Save the page.
Q: I have one question, is it possible to print the orgcharts ? Or to export them to pdf?
A: Yes you can both print the chart using the print function of the browser or convert it to PDF using ADOBE API. The output result of the chart is HTML and you can convert it to PDF using this API.
Q: I have a question about the license fee: is it server based or user based?
A: Both server and user. See the detailed price.
Q: I have installed the demo version and also created the FILE dsn as required. But i m getting the following error message while executing the application. Can not connect to the database. Check the connection string setting: [filedsn=Chart] Operation is not allowed when the object is closed.
A: The problem is that you can not connect to the database. There is a asp page coming with the product called TestConnection.asp. Modify the dsn in this asp page and try to run it. Any dsn (filedsn, system dsn or dsnless connection string) defined in this page can be used in the setting.asp. If TestConnection is not working with any dsn, use one of the dsn that you use in other application and try that one. If that one is not working then update your ADODB from Microsoft site for free. This is the URL: http://www.microsoft.com/data/download.htm
Q: How can I connect "Web Organization Chart" to Oracle database?
A: You can connect to the Oracle database. After you make sure the application is working with access database you need to do the following steps by steps.

I am sending you the kit that is used to connect to Oracle database. You can use the same in DB2 and see if it is working:

1- You need to create the sample ReportTable in your DB2 database and test the application with this table. I am sending you the script to create the table .

CREATE TABLE ReportTable (
Name varchar2(30),
JobTitle varchar2 (40),
DeptName varchar2 (60),
ORG_ID int NOT NULL ,
MGR_ID int NOT NULL ,
Picture varchar2 (255),
Email varchar2 (255) ,
Telephone varchar2 (25),
Secretary CHAR(1) NOT NULL ,
Category varchar2 (50) NULL);
ALTER TABLE ReportTable ADD CONSTRAINT REP_KEY PRIMARY KEY (ORG_ID);

The above SQL is writtem for Oracle. You may adjust it for DB2

I am also sending the setting.asp which uses same field names created in this table plus sql script to add data into the table plus chart and tree.asp pages. The last two asp pages use oChart.Oracle = True to point the DLL into Oracle database.

2- Use the test page called TestConnection.asp. Modify the dsn and use the DSN that is working fine pointing to DB2. You can open TestConnection.asp with interdev or any editor that you open asp page or even notepad and change ConnectionString = "Filedsn=Chart"
to
ConnectionString = your dsn pointing to DB2.

Run the application and make sure you don''t get any error. This test verifies the connection to DB2 is working fine through Asp.

3- In the last stage after the app is working with our sample table in DB2, modify setting.asp page to point to your view. You need to open setting.asp page and change:

GetConnectionString = "filedsn=Chart"
to:
GetConnectionString = whatever you used in TestConnection.asp
Q: I have downloaded and setup the Web Org. chart Trial version on my IIS server and I try on my local development server but I get only "Type mismatch" error
A: You have to create File DSN (and Not System DSN) and point to chart.mdb correctly.
Here is the sequence:

Start your control panel.
Click on ODBC data source.
If you have already created System DSN, click on System DSN tab folder, select the file and click on remove.
Click on File DSN tab folder.
Click on Add Push button,
Select “Microsoft Access Driver”, click on Next.
Type “Chart” and click on next.
Click on Finish.
Click on Select Push button.
Find Chart.Mdb and click OK.
Open your Setting.asp page
Change the following line from:
GetConnectionString = "dsn=chart"
To:
GetConnectionString = "Filedsn=chart"
Save the page.
.
.
.
Home | FAQ | Our Company | Contact Us | Survey Software | Survey Consulting
Survey Articles | HR Software | Order Information | William Steinberg

Copyright © William Steinberg Consultants Inc. 1988-2008     Design: Web By Craig
.