Bernd Wechner's Q&A profile

• SQL Server No mapping between account names and security IDs was done

  I can design a report fine in the Report Designer. I can build it fine. I can preview it fine. But, when I try to deploy it I get the error: No mapping between account names and security IDs was done Any help will be appreciated. ...Show All

• Visual Studio Express Editions Need Code

  Hi, i need code for connecting MySQL with .net .......................... Assuming you've already got MySQL installed and setup... I'd take a look at this tutorial , otherwise you may want to start at the beginning of their VB.NET & MySQL tutorials . ...Show All

• Visual Studio Express Editions date.parse

  I have a string, called stringdate, like "07-01-2007" that means January, 7 2007. I need to convert it to a Date avoiding the confusion with July 1, 2007 I am using Date.Parse(stringdate,df) where I am defining Dim df As New System.Globalization.DateTimeFormatInfo df.DateSeparator = "-" However, how do I specify that the date format is "dd-MM-yyyy" Have you tried setting the shortdatepattern: df . ShortDatePattern = "dd-MM-yyyy" ...Show All

• .NET Development sorting data in tables

  as abv, how can i do it im using sql server express 2005. my situation.. i had retrieved data and sort them before i add them into a combobox. so the problem now is that the ID at the combobox doesnt tally with the ID at the database. the data in the table will continue to increase as time goes.. eg. combobox 0. apple 1.orange 2.pear table 0.orange 1.pear 2.apple i would like to sort the data before i can use the ID for another purpose. SelectedIndex is just the number of the selected item in the listbox. So instead of using selectedindex, use the SelectedItem and cast this to a DataRowView and extract the value, like so: DataSet ds = null; DataTable t = null; private void button2 ...Show All

• .NET Development Why can't I deserialize my Type?

  I'm playing with Types, Interfaces and Serialization and have come up with a situation that I think should work but does not. I have an Employee Type that implements the IEmployee Interface. I construct an Employee instance and serialize the instance to a file.(App1) In another application(App2) I then try to read the serialized instance of the Employee Type from the file. The catch is that I compile App2 WITHOUT any reference to the Employee Type, only to the Interface IEmployee. I am doing this so that App2 can use the IEmployee Interface without knowledge of the actual implementation as found in the Employee Type. App2 compiles cleanly. Knowing that I need access to the employee class before I can deserialize the class, but wanting t ...Show All

• Visual Studio Increment Field or Formula?? Help please!!!

  Hi friends, i have this view (in my sql server): it's the count of alternatives per question idCuestionario Cuestionario idPregunta Pregunta idAlternativa Alternativa Conteo ---------------------------------------------------------------------------------------------------- 101 Cuestionario_1 5 Pregunta_1_1 1 Alternativa_1_1_1 5 101 Cuestionario_1 5 Pregunta_1_1 2 Alternativa_1_1_2 2 101 Cuestionario_1 5 Pregunta_1_1 3 Alternativa_1_1_3 3 101 Cuestionario_1 6 Pregunta_1_2 11 Alternativa_1_2_1 12 101 Cuestionario_1 6 Pregunta_1_2 12 Alternativa_1_2_2 23 101 Cuestionario_1 6 Pregunta_1_2 13 Alternativa_1_2_3 34 ...Show All

• Visual Studio Team System Team Foundation Server vs SubVersion

  Hi, Did any one has done comprehensive report comparing Team Foundation Server vs SubVersion vs VSS The comparison will be toward business decision. - Cost analysis. How much saving if using TFS compare to others - Efficiency & Productivity - Quality Assurance. - etc Thanks, John > Sourceforge is using SVN too - should they use TFS in future Errm. No. If you wanted a Sourceforge like site that was using TFS, then check out the excellent CodePlex site ( http://www.codeplex.com ). You are correct that you need a Microsoft platform to run TFS on. For the kind of organizations that TFS is aimed at, this is not a problem. Considering how new TFS is, the adoption has been staggeringly ...Show All

• Visual Studio Generic GDI+ error when switching to Page Layout View in LocalReportProcessingMode

  Hi, I am getting the message "A generic error occurred in GDI+." every time I try to render a report in PageLayout view. This is true whether I switch to PageLayout view manually or using the .SetDisplayMode function. It is true using a report viewer that I create in code and one that was placed on the form in the designer. It is true when viewing simple and complex reports. (Even blank ones.) The reports render fine in Normal view. I am only rendering reports in Local Processing Mode. Print Layout view was working fine until today, and I cannot identify the change that caused this error. I changed the data source of one of the reports, and I opened the report several times programmatically on an undisplayed form. I w ...Show All

• Visual Studio pass a multiline text to the crystal report

  Hello I have areport i made it by crystal report and i want to pass a multiline text to the report and i write this code but i don't know what's the wrong on it crystalreport1.DataDefinition. FormulaFields("unboundstring1").Text = Chr(34) & reporttext & Chr(34) when i pass single line text it's pass it but it's not accept multiline text it's show me error message ...Show All

• Visual Studio Visual Studio 2005 Beta 2 Uninstall error.

  I am receiving the following message when I try to uninstall VS 2005 Beta 2 Setup is unable to determine a valid ordering for the installation.  See the error log for further details. Has anyone else received this message   And where is the error log located that is supposed to contain "further details". Thanks. Tried it on another machine with VS2005 B2 installed. The uninstall tool worked fine. On the first machine with the problems arising I manually uninstalled all the components using the add/remove programs at the control panel. Guess that's the cause for the current situation. Going to find a way to reinstall the VS2005 B2 to hopefully be able uninstall it again using the automated tool... ...Show All

• Visual Basic Fax Service in Windows 2003 R2 and ASP .Net

  Hi Gurus, I have an application using ASP.Net 1.1 and windows fax service. It is running properly in Windows 2003 SP1. But it can't connect to fax service in Windows 2003 R2. I think the fax service is working well as I can send fax manually from this Windows 2003 R2 server. I would appreciate for your advice. Best Regards, WL ...Show All

• Visual C# GetFillParameters Problem

  Hi all, Simply i am unable to get parameters with SqlDataAdapter's GetFillParameters() method. Here is my code sample : private void button1_Click( object sender, System.EventArgs e) { SqlConnection s = new SqlConnection(@"Integrated Security=SSPI;Data Source=(localhost);Initial Catalog=Northwind"); SqlDataAdapter cmd = new SqlDataAdapter("SELECT * FROM Customers WHERE City = @City", s); try { s.Open(); MessageBox.Show(cmd.GetFillParameters().Length.ToString()); } catch (SqlException ex) { MessageBox.Show(ex.Message); } When i run this code sample i get "0" in a message box but no errors. Why can't i get the parameters in my sql code Any comments ar ...Show All

• Visual Studio Tools for Office Problem when Publishing VSTO office 2007 application

  Hi, We have developed application in VSTO Excel 2007 which uses an webservice hosted in a server. We tried to publish this application in the server but it failled due to this reason Failed to update customization from the specified deployment manifest. ************** Exception Text ************** Microsoft.VisualStudio.Tools.Applications.Runtime.UpdateFailedException: Failed to update customization from the specified deployment manifest. ---> System.Net.WebException: The remote server returned an error: (502) Bad Gateway. at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request) at System.Net.WebClient.DownloadData(Uri address) at etc... So we published this application locally and configurin ...Show All

• .NET Development Jagged arrays are not cls compliant

  Hi Guys, While analyzing my code with FxCop 1.32, I get the following "Breaking" - rule: "MyMethod" uses a multidimensional array of 'System.String[, ]'. Replace it with a jagged array if possible. ( Jagged arrays are not CLS Compliant .) " Please, help me with the above issue. Thanks in advance Yogendran (yogi) CLS compliance is that it follows the rule all .NET languages must follow. If it is not CLS compliant there is no guarantee that the code can be reused from another .NET language. http://msdn2.microsoft.com/en-us/library/bhc3fa7f(VS.80).aspx If you are making a stand-alone application that will not share code (like a class library) to be used by ...Show All

• SQL Server xp_cmdshell error 1326

  EXEC xp_cmdshell 'dir *.exe' Msg 50001, Level 1, State 50001 xpsql.cpp: Error 1326 from LogonUserW on line 620 I have followed following document completely with no problem but yet system generate above error http://www.support.microsoft.com/kb/890775 before that I used to get following error that is one of the described scenario in that document Msg 50001, Level 1, State 50001 xpsql.cpp: Error 87 from GetProxyAccount on line 499 Configuration: SBS2000 Premium (Includes SQL 2000) User: a regular with PUBLIC access on MASTER The first error looks like it is caused by a bad password or bad account name. I am not sure about the second. ...Show All