Search results for query: *

We started without a try to shell out. But then we had a problem with system.directoryservices. This library isn't supported by CLR in SQL2005. What do you mean by "you shouldn't actually have to do anything to validate the account"? Isn't it necessary to use the directorySearcher to validate?

MrDenny, Thank you... but: 1. In SQL2005 you must allow to run operating system commands in the SQL2005 Surface Area Configuration. If you allow this, you have a security risc our customers don't want. 2. If you try it by CLR, you can't use the Shell-command from the standard...

We want to deploy a ASP.NET web-application that is secured by a login-page. We don't want to have a seperate password-system. We want to use the existing Active Directory system. The web-application runs on a IIS-server which is OUTSIDE the domain. So it is not possible to reach Active...

Situation: a VB.NET-application that runs in a Windows-domain on a Citrix/Terminal-server Frustration: users have to log-in twice: once in Windows domain and once in our application Objective/goal: users that already are logged-in in Windows domain don't get the log-in screen of our...

Thanks for all this reactions! Do I understand correct that there is absolutely NO chance that two concurrent users of the same stored-procedure will lock each other because of the use of a table variable in that stored-procedure. If necessary (not enough memory available), the tempdb will be...

Does anyone know if SQL2005 is better than SQL2000 with the table variables (DECLARE @tblTable TABLE ...)? Table vars are "SQL-tables in memory". If you put to much data in a table var so the table var needs more memory than available/free, they say the table var will use the tempdb. In that...

We have a web-application that connects through a SQL-user to a Microsoft SQL2005-database with certain rights on certain SQL-objects (for example: only that User Defined Function, only that Stored-procedure). Sometimes we have to update some of those SQL-objects: new or extra code in a UDF or...

To reduce printing network traffic we use Print-IT from Provision Networks on our Citrix-farm (http://www.provisionnetworks.com/solutions/print-it/print-it.aspx). One application uses Crystal Reports XI for printing the application reports. When those reports include the font type "Tahoma...

Patrick, Indeed, with ASP.NET it is possible to update the DLL's, because the DLL's are called by the IIS and are most of the time free. Buth with ASP.NET you need an extra service (IIS) and our custumers want an Windows-application, not a web-application! So ASP.NET is not an option... Thank...

We want to divide our Windows-application in three tiers: - data (SQL-server) - business (IIS-server with web-services) - user-interface (Citrix-servers) The business-tier will exist of web-services we call from our application. Now we have RPT-reports that get their data through an...

The reason is our company also has develloped web-applications that uses an already written .NET business-framework with the business-logic included in this, and NOT in stored-procedures. All of this exists of DLL's. In a web-application, you can overwrite those DLL's while users are busy, so...

Christiaan, thank you! The configuration is: one separate SQL-server and more Citrix-servers. The application is on every Citrix-machine and connects to the data by ADO. If we place the bussines logic framework on the SQL-server: 1. What will be the performance and load implication of the...

We have a Windows .NET application that is running on a Citrix-server. The application uses stored-procedures on a SQL-server. We want to stop using stored-procedures because we want to centralise all the logic (insert/update/delete) in a business-framework written in .NET. This means that...

We have a Windows .NET application that is running on a Citrix-server. The application uses stored-procedures on a SQL-server. We want to stop using stored-procedures because we want to centralise all the logic (insert/update/delete) in a business-framework written in .NET. This means that...

When I try to update the connection crystal reports gives the error: "Data object cannot be opened/accessed." I'm sure the stored-procedure is in the SQL2005-database. We can select the SP to use this in the report. But later, when we reopen the report and want to retrieve data or want to...

Ian, Thank you for this information, but the reports are not based on tables. They are based on a stored-procedure and in the SQL-statement in CR we see: {CALL "DatabaseName"."dbo"."MyStoredProcedure";1(parameters)} If we run this SQL-statement from the query-analyser, it works. Although, in...

We have a lot of rpt-reports that are made based on an ODBC-connection to SQL2000-server. We migrated to SQL2005-server an now a lot of reports give the error: "The database table <stored procedure> cannot be found." It has nothing to do with the version of CR. We have the same problem in CR10...

We have a lot of rpt-reports that are made based on an ODBC-connection to SQL2000-server. We migrated to SQL2005-server an now a lot of reports give the error: "The database table <stored procedure> cannot be found." It has nothing to do with the version of CR. We have the same problem in CR10...