Sergey Kovalev's Q&A profile

• SQL Server SQL Express on Load Balanced Servers

  Hi, I have two 2003 servers which are load balanced - not for high demand but for resiliance. The application that is being run on both servers shares data on a NAS raid 5 device. Can I install SQL Express on each of these servers and have them share the databases on the NAS device Help please anybody Paul hi, clustered scenarios are not included in SQLExpress edition  .. you have to pay for the standard edition at least http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx more.. a NAS is just a "shared" device.. and a SQL Server instance can not share a database with other instances.. you have to detach the db(s) from it to attache it/them to other instances and ...Show All

• SQL Server sp4 on dev edition 2k

  I'm running SQL Server 2000 (Developer Edition) on an XP machine. I'm trying to apply Service Pack 4, which, though I haven't service packed SQL Server 2000 in a couple years (most recently working more in 2005), I have installed SPs against SQL Server without difficulty in the past. I've downloaded the x86 SP4 exe. I extact the package ... but when I got to run setupsql.exe from a command prompt, I get nothing -- no dialog, no apparent install. silent switch is NOT specified. Hi, I donot remember the threads but earlier i see the threads asking how to remove / delete registry information which is still their after Uninstallation , so i would suggest you to refer below links for Manual Install & ...Show All

• SQL Server Portfolio/Benchmark cube structure question

  I am looking for some design advice on my table structure and cube. I am working at a financial company that wants to compare portfolios to benchmarks. Both a portfolio and a benchmark have securities. For analysis purposes the benchmarks are compared to the securities on a number of levels (industry, rating, currency, country, etc.). I want to be able to show in my cube a comparison between a portfolio and a benchmark for the previously stated dimensions. Example: 4 percent of portfolio A is Autos (industry) 5 percent of the benchmark A (the benchmark for portfolio A) is Autos Two options as I see it: Have a PortfolioBenchmark Dimension (DimPortfolioBenchmark) and that my fact table will list MarketValue and Weighting (weight of ...Show All

• Windows Forms Error: The deployment identity is not the same as the original deployment identity

  What is this error Thanks, Lorenzo PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : http://172.16.19.33/Prisma/Prueba1.application Server : Microsoft-IIS/5.1 X-Powered-By : ASP.NET Deployment Provider url : http://lnsistemas-08/Prisma/Prueba1.application Server : Microsoft-IIS/5.1 X-Powered-By : ASP.NET ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://172.16.19.33/Prisma/Prueb ...Show All

• Windows Search Technologies Problem crawling with a hierarchical custom protocol handler

  I have developed a hierarchical custom protocol handler that I'm integrating with Windows Search on Vista. The handler has a IUrlAccessor and IFilter implementation that enumerates the contents of a directory by returning the search URL of each "file" in the directory as a text chunk with the STAT_CHUNK structure specifying the GathererPropset and PID_GTHR_DIRLINK propid. My understanding is that the indexer should take these URLs and queue them for indexing, in which case I should see subsequent calls to CreateAccessor with those URLs. However, instead I'm seeing the indexer call CreateAccessor once to get the directory accessor, then it reads the dirlink text chunks, but it never make the expected additional calls to Create ...Show All

• Visual Studio Express Editions Install Error - "Encountered a problem"

  What is wrong with the Visual Basic Install It does not even begin the installer. I get the message "Encountered a problem..", click "OK", and it is done. The message seems to come as the installer gathers files and performs system checks. I do have MS Office installed, and I am running XP pro SP2. I am doing a manual installation from a CD. I tried to install Visual C just to see if there is something else I need to do prior to install. The installer runs with Visual C, Express Server and every other package. VB just does not want to go. Thanks ahead of time for any help. Rudy. I thank all of the folks who took the time to read my post. I still encounter the error message. To add more background inf ...Show All

• SQL Server Does .NET support mySQL connectivity?

  If so, what category does this fall under (ODBC, etc). I need to be able to send queries and updates through C++ .NET 2.0. You can connect to MySQL through ODBC, but there seems to be a more native driver for it, too: http://dev.mysql.com/doc/refman/5.0/en/connector-net.html ...Show All

• Internet Explorer Development password text field

  hi, it is possible to write code to allow user create password text field that comes with (*) star text field instead of (.) dot password text filed! is there is way that we can convert password text filed from dot to star text! Alidad   I think you should be able to change the password character Have a look at msdn2.microsoft.com/en-us/system. windows.forms.textbox.passwordchar.aspx   ...Show All

• Visual C# WindowsApplication1.exe has encountered a problem and needs to close...

  Hi. When I Create new C# WindowsApplivation Project in VS.net2005 and Compile it, I receive this error :   WindowsApplication1.exe has encountered a problem and needs to close….. I write no Code in this project and just after the Project Creation I used "Start without Debuging" for Compile it. What should I do Thanks. I'm so sorry for my language. yes! for every new solution I have this problem. and I don't modify code in any way. I said that my project was empty. it's kind of you for answering to my question. ...Show All

• SQL Server Special Characters appear importing from MySQL

  I am importing a small table from MySQL through a linked server on a daily basis. I found that in two fields, when there is no data, it is including a box character for each blank spot. I'm guessing this special character is showing up because sql doesn't know how to represent it, but I don't get why it is there at all. I wan't to show either a NULL or blank value. I updated the MySQL driver to the latest and that didn't help. Any ideas are appreciated. ...Show All

• Visual Studio Express Editions Technical Problem when transporting Project

  I have built a project on a PC running Microsoft Visual Basic 2005 Express Edition. I also installed this software onto my laptop (from the same CD and registered it fine too). But when i save the project from my PC and close Microsoft Visual Basic 2005 Express Edition i sometimes get errors about the program (doesn't bother me that much and i just send the error reports via the prompt). I then copy the solution that i have developed in the Projects folder to my memory stick and copy that into my Laptop's Projects folder, but when i goto open Life.sln or Life.vbproj (one folder deeper) i get an error that says this (BTW, it's the same error both ways [so both times it's Life.vbproj]): Unable to read the project file 'Life.vbproj'. C ...Show All

• .NET Development Visual Studio 2003 with SQL Server 2005

  Could we use the visual baisc.net in visual studio 2003 to connect to SQL server 2005, or other tools If it could, may I have the sample code i believe you can, would be the same connection string and accessibility as you would do with SQL 2000, if you have used it. Take a look at the SqlCommand, SqlConnection, SqlDataReader, SqlDataAdapter classes which allow you to access/use SQL Server within your application http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx http://msdn2.microsoft.com/ ...Show All

• Microsoft ISV Community Center Forums Setting a global variable and referring to it from a private sub routine?

  Hi, I am basically wanting to improve my code and make it more user friendly and error proof! Ok, so currently its based around a single user form which toggles on and off from a set command buttons which allows the user to view the from and select certain buttons which automate a lot of the tasks necessary from within the workbook. I have a different amount of records/rows in it each month and I display a pop up msg box asking the user to input the number of employees to be processed each time they click a button. This is grand and works fine but is not very user friendly and if they put in too many it messes up the data! So I got some feedback from these forums a while back saying that I should redo it and instead of ask ...Show All

• Software Development for Windows Vista Taskbar Thumbnail API

  Our app currently does not display properly in the taskbar live thumbnail in build 5384.  It seems to not display any popup windows in the thumbnail.  Is there an API that allows us to construct our own thumbnail for this (or can we turn it off) Thanks. The thumbnails are only live when the window they represent is in the restored or maximized state. If the window is minimized then it loses its visual representation, and the thumbnails show the last image of the window as it was drawn right before it was minimized. This is why your app doesn't update while minimized. ...Show All

• Visual C++ Accessing Image resource (bitmap)

  Hi, I tried but without success to access a bitmap file which I added in my application resource file as following: "resource.h" #define IDB_LOGOBWVISU 107 "app.rc" IDB_LOGOBWVISU BITMAP "Dessins\\LogobwVISU.bmp" How do I access this resource from within managed C++ code taking into account that I want to assign it to following Image object: System::Drawing::Image* Logo_Visu; Many thanks in advance, Stephane Hi again,   I put efforts and finally finished translating my whole application in C++/CLI.  Wasn't so bad after all except that following code is still giving me headaches:  HANDLE h = LoadI ...Show All