enric vives's Q&A profile

• SQL Server Multi connection to .sdf file store on network share

  Hi In the " Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition" white paper, i can read that: "SQL Server 2005 Compact Edition support data file storage on a network share" and " Number of concurrent connections = 256 " But when i try to connect with two different PC at the same time to a .sdf file store on a network share, i have an error message : "File is locked by an other processus" The firsth PC is connected but the secondth can't ";Mode=Read Write" in the connection string don't change anything. anybody have an idea Although SQL Server Compact Edition supports concurrent database connections from mul ...Show All

• SQL Server select * from sys.fulltext_languages

  I have been researching this issue and I reallized that the Client (SQL Express Edition SP1) does not have a Fulltext Language installed. I have uninstalled and reinstalled the Client with changing the installation to support Full Text Indexes, yet Languages are never installed, does any one have any idea why or how to install the languages manually Thanks, Frank ...Show All

• Visual Basic Startup / Shutdown time

  Hello I would like to make a program telling me when my computer was started and when it was shutdown for the past 10 days for example. I am not sure if windows logs the time or is there a way to find the time through another way What API should I use Thank you in advance ! most likely API calls, which can be easily achieved, or using the WMI approach. Import the System.Management.Instrumentation namespace, and add this code to say a button click event:   Dim theScope  as   new ManagementScope("\\ yourComputerName \root\cimv2")   Dim theQueryString as new System.Text.StringBuilder() theQueryString.Append(" SELECT * FROM Win32_OperatingSystem")     ...Show All

• Smart Device Development NumericUpDown control

  I've got a control added to a form. I need to set it to min of 90.0 and a maximum of 108.0 and increment set to .1. I've googled and seen the .DecimalPlaces property but that must not be part of the CF control. Is this possible in Compact Framework 2.0 IF so a little VB.NET sample would be great.....such a little problem I've been beating my head against the table over... Harry This controls is 16 bit integer on device. You can use values from 900 to 1080 and divide by 10 before use or use domain up/down control if dot presence is important to you. Another way to go is to create custom control which does what you need. ...Show All

• Windows Forms Problem using ErrorProvider

  Hi, I am having a single error provider on my form. when i set error, it displays the error text properly in Tooptip properly but when i click on the error provider after that we are not able to see the error in tooltip is there any way to forcefully show the tooltip error Thanks & Regards Ajay I've found that simply changing the control's modifier from 'Protected' to 'Private' corrects this issue. Cheers! ...Show All

• SQL Server using the cache from one report that was created by another report

  I have two reports, the formatted report and the unformatted report. The formatted report has a link to the unformatted report which essentially is the same report but with no totals our grouping, and was designed so that the user can dump data to Excel. Also the unformatted report is hidden from the user and can only be run from the the previously mentioned link. The formatted report is driven by sql that is dynamically created and when the user clicks the link, it passes this sql to the un-formatted report and re-runs the exact same sql. My question is, is there a way to have the unformatted report use the cache from the formated report and thereby avoid re-running the sql. ...Show All

• SQL Server RS2005 on Win2000

  I've followed a couple of threads on this, but still haven't quite resolved the issue. RS 2005 is installed on a Win 2000 Server. The service seems to be running perfectly, but when I navigate to <localhost>\ReportServer, I get: Reporting Services Error -------------------------------------------------------------------------------- The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied. -------------------------------------------------------------------------------- SQL Server Reporting Services I've manually c ...Show All

• Visual Basic Only numbers in a textbox

  Hi is there a way to alow only numbers in a textbox Reagrds alvin Unless you never want to be able to use the control characters such as delete / backspace, arrow keys in the textbox then this code is lacking the additional condition required to handle these. Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress If Char.IsNumber(e.KeyChar) = False And Char.IsControl(e.KeyChar) = False Then e.Handled = True End If End Sub ...Show All

• Visual Studio C# Chinese wont build resources on Vista

  In my C# project I have CHS/CHT for Chinese resources. If I build the project on Vista these two languages will not build the resource dll file. I have to rename to Hans/Hant for Chinese to build. If I move the project back to XP then it again wont build and I have to rename the resources again. I've heard of a workaround where you set the resource programatically in code based on the OS. Does anyone have a beter solution or info about this issue Thanks in advance, KC What's the error you get on Vista when it won't build What's the original name of your resources file for CHT/S on Vista, and what works on XP I use CN/HK country codes on my Chinese resources files, and have my resource files named ResStrings.zh-cn.resx a ...Show All

• Visual FoxPro Combo Quick fill while combo is expanded.

  Hi all; I have a class which uses code Marcia Akins posted here (Thanks Marcia). The code uses the InteractiveChange of the combo in order to produce a quick fill functionality. The problem: This won't work when the combo is expanded. I've tried to utilize the kepress method but it didn't work. Is there a place I can disable the inherent functionality of the combo when its expanded so it won't interfere with the quickfill functionality Thank you all. >> For some reason the combo does some sort of incremental search regardless of the setting. A stupid question, but the IncrementalSearch property really is .F. isn't it ...Show All

• SQL Server restoring table or view or sp

  Actually I have very big size of databse. Also its back up is obvious that also biger size. In case of only data loss of one table or view or sp or change then restore whole database then get back previous backup database & restore table i.e. it consuming too much time. I want to restore only one table or view in faster way. how i can do it. plz give any suggestions If you database was made of seperate files you could restore individual files. To restore only a table you need a third party product such as litespeed. I am not sure if any product can restore only schema components i.e views and sps. Standard practice is to keep the SQL scripts for Views and SPs. Do you not have these ...Show All

• Visual C# System.MarshalByRefObject cannot be converted into parameter type Interfaces.IClientSessie exception

  Hello I'm having a problem in my remoting application (client part). This is the exception I get "The argument type System.MarshalByRefObject cannot be converted into parameter type Interfaces.IClientSessie." The exception happens on balie.login(... banksessie1.ClientSessie seems to be the problem removing this part solves the exception. I can't seem to find the problem. Anyone any insights or at least some more information about this error (part of) Button click try { int nummertje; string text; BankSessie banksessie1 = new BankSessie ( this .balie); string text2 = this .balie.logIn( this .textBoxNaam.Text, this .textBoxWachtwoord.Text, banksessie1.ClientSessie , out nummertje, ...Show All

• Audio and Video Development ACA Explorer

  Hello, Don't know if anyone has created one yet but I figured I'll share this small tool i made with everyone. AcaExplorer allows you to view the content of unencrypted Advanced Content Archives and extract files. Usage: Run acaexplorer.exe > Click on [Open Archive]  > Select an *.aca file and click [Open] > Select one or more files from the listbox > Click on extract and choose the destination > Click [Choose] and voila! Tip: use [CTRL] to select multiple files The tool is free and can be downloaded from: http://www.levelx.eu Notes: The program doesn't warn if there is already a file with the same name in the destination map and overwrites. Currently there is a max 16MB limit.   ...Show All

• Visual Studio 2008 (Pre-release) Problem with NTLM on IIS

  Hi everyone! I began to investigate different security option of the WCF and found this problem: WCF is hosting on IIS. So I have no problems while there was Anonymous access. Then I restrict access only with integrated Windows security and since this i wasn't able to make my service work. So first time it responded with such error: The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate,NTLM'. The problem seems to be clear: In Service and Client config's i set clientcredentialtype to Windows, then IIS responded generally the same error: The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header receive ...Show All

• SQL Server Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All