Organization Chart Issue

P

pal

Dear all,

I have a code for generating Org chart which is working fine with the
SQL SERVER , But I need to change it to ORACLE table. But when I
specify the table it is not connecting. Is there any thing that I am
missing?

Below is the code,

strCommandPart = " /DATASOURCE=" & OrgChartDSNPath & ",
Table=DBO_OASYS2009_OR.ORG "
vsoAddOn.Run strCommand & strCommandPart
vsoAddOn.Run "/S-ARGSTR /NAME-FIELD=Title"
vsoAddOn.Run "/S-ARGSTR /MANAGER-FIELD=ReportsTo"
vsoAddOn.Run "/S-ARGSTR /Firstname-FIELD=name"
vsoAddOn.Run "/S-ARGSTR /PAGES=""" + TopExecutiveName + """
PAGENAME=""" + TopExecutiveName + ""
strCommand = "/S-RUN "
vsoAddOn.Run strCommand

Thanks
Jayadev
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Organization chart on one page 2
Access and Visio 1
MS Access >> MS Visio 0
converting Org chart child nodes from vertical into horizontal 0
converting Org chart child nodes from vertical into horizontal in code 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Automating Org chart wizard - wierd issue 2
Send Error Report dialog on vsd open 0

Top