connectivity issue

[system]

Anybody have any suggestions?

1. SQL running from my pc runs fine. Oracle database. tns ping works OK
2. Aspx-hosted SQL runs perfectly from the webserver. Returns data in under a second as XML to my browser
3. When I set up an XML data connection in xcelsius (on my pc, running the aspx on the webserver), it hangs as soon as it tries to run the file.

The powers-that-be won’t let me have fiddler or any other potentially useful tool…

Debbie

---

Debbie (BOB member since 2005-03-01)

[system]

Fixed.

When I code my aspx using GetString to format/process the output, xcelsius sometimes doesn’t play nicely…

streamlining coding in aspx pages

This may be completely the wrong forum for this, but since it’s what I’m using to get data for my xcelsius dashboards… I get my data by writing SQL and embedding it into an aspx script. I found my basic VB code in the Xcelsius user guide and online, but not being a programmer, I’ve been trying to understand what it’s actually doing. So I went through the tutorial here: http://www.w3schools.com/ado/ado_intro.asp which tells me that what I’m using is ADO Here’s my basic code. I connected it to …

So I switched it back to processing each row in turn and it now works.

Debbie

---

Debbie (BOB member since 2005-03-01)