Recent content by esmithbda

Sorry about that, we are using ASP.NET with VB, Visual Studio 2005's Crystal Reports, and .NET Framework 2.0. That link looks very helpful - thanks!

We currently have a web application that takes in data via a form, passes it to a Crystal Reports report (x.rpt) and then that passes the data to the database into a stored procedure, which returns a dataset, the report acts on that, and then it is displayed in a Crystal Viewer object. In that...

I should note that it isn't a connection speed issue - once it finally allows you to see a file and you copy it, that is all fine - it is just the actual process of listing files.

We have a Windows 2003 server with shared folders on it. Users on the network get mapped to those folders on login, and their access performance is fine in regards to those folders. But when I come in via our Citrix VPN, it can take upwards of 5 minutes to click on a folder and have its...

The point I am at now is that in the VB code page for the report itself (that the form data is getting passed into), in the Page_Load sub, I have it calling the CrystalReportSource1.ReportDocument.SetParameterValue("@DateTo", "1/1/06") as an example here, and that way I can then take in Form...

I am using ASP.NET (VB) and have PageA with some input fields. I want to submit that page and have it spawn a new window with PageB (the reports), passing those parameters to that window, and have it run the report. The logistics are in place, but the spawned window continues to ask for the...

Sounds reasonable, thanks. Connect with a separate connection string built with that user's name/pass, and then try and do a basic thing all users should be able to do, and if that fails, fail the login. We do something similar with an Access tool that points to the same database, but that is...

We have a database app that users login to and they authenticate via SQL authentication. So in the SQL Server (2000) database, there are the actual SQL users and the passwords are managed by the server. (not a separate table that we query, but an actual SQL Server user) I am now building a...

Thank you George, it looks as if from there I could do something similar to in here: http://www.sqldbatips.com/showarticle.asp?ID=8 Thanks for the help!

Fair enough - and we technically do have that in place. Part of the issue is that we have N stored procedures and functions, where N is large enough that it is hard to keep track of them in a manner that is easy. We have new functionality being added regularly, and depending on how busy we...

Is there a way that I can query all of the stored procedures and functions for LIKE '%ABC%' where "ABC" in this case is a unique string that all of our key procedures and functions have in their name - and then modify their permissions? I am currently having to go through manually when we have...

We have an ssl cert issued from a second tier group - not Verisign. They are supposed in the Windows updates and they have a root install program at http://www.quovadis.bm/root/ but when we run it, we see the same issues as before running it. If we use the Windows client installed on a machine...

A few days now have passed and I can say with certainty that this appears to have been the issue. I changed it from auto-negotiate to full duplex 100 and it immediately resolved it and we have had uptime ever since. Thank you for pointing this out - as I had said, I had always heard to leave it...

aha - that got me to at least see some error messages. It said something along the lines of checking to see if I had the sqldebug.exe program (that might not be the exact name, this is just off the top of my head), and then that at least let me do more searches to see what the issue is. I ran...

When I right click on a stored procedure in Query Analyzer and select "Debug", I can enter the data and then it runs - but all of the documentation that I find on it says that it should stop at the first executable line and then wait for instructions from me (step into, step over, etc). But...