ClientSide VbScript and DataBase Connection

[sstevens]

I am using OWC10 to show a report for the user in spreadsheet format. I am
using ASP.NET but create the spreadsheet on the client using vbscript. Below
is an example of what I am doing. The query used is genereated by the code
behind and I get it as shown below. I need to know if there is a way to hide
the connection string and the sql command from someone who looks at the
source of the page. I do not want to move the spreadsheet to the server
because I have heard of performance problems. Any suggestions?

Function window_onload()
SpreadSheet1.Worksheets("Sheet1").ConnectionString = "my connection string"
SpreadSheet1.Worksheets("Sheet1").CommandText = <%=thisReportQuery%>
End Function

 

[Effie]

1. You can move it to the server, it will be faster, and the "performance
problems"
depend.
2. Query to DB on other asp page, and return results as XML to the html page.