My dashboards connect to my databases using aspx scripts. I have a connection string, then I fire SQL directly and get the resulst back as XML. It all works perfectly.
BUT I’m trying to connect to an oracle database. Normally I have to write:
select column from schema.tablefor queries on this database to work, but I can’t get my aspx script to run this. It won’t recognise schema.table as a valid table name.
I know the script is fine, the connection string works and my TNS entry works as I can run
select global_name from global_nameand it returns the correct value.
So it’s something to do with the schema and/or the dot that is making it fall over…
I’ve tried
"select column from schema" + chr(46) + "table"and tried using a \ to escape the dot. But nothing works!
Any ideas or suggestions welcome!
Ta
Debbie
ETA. Oh forget that. I’ll leave this thread here as monument to my stupidity and try to remember to connect to the right database next time… 
Debbie 
(BOB member since 2005-03-01)