Mateusz Rajca's Q&A profile

• SQL Server Problem connecting to external SQL Server

  Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy! Well not for me .. This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight o ...Show All

• Visual C++ Where shall I ask the quesiton about C? E.g. Question about how to generate different random numbers...

  Dear all, I had one question about generating different random numbers. One piece of my code is as follows. Actually, because of the limited time, I don't think it can work. Its principle or algorithm is only to guarantee different values between generated values border upon/nearby. However, how to guarantee the value is different with all the previous ones, not only the border upon value. void initRandom() { int i,j = 0; for (i = 0; i < 100; i++) { random_numbers = rand() % 100; // Get random number. // Try to compare the value with previous ones. for (j = i; j==0 ; j--) { if (random_numbers[j] != random_numbers[j-1]) { break; } else { random_numbers[j] = rand() % 100; } } } } Do yo ...Show All

• Visual J# Visual J# in a beginning java college course ?

  Is using Visual J# in a beginning java college course appropriate I'm considering using VJ# in a first programming course as an alternative to JBuilder and J2SE. Given install problems other students have had, VJ# seems like a nice alternative. I intend to let the student decide which tools to use based on their peer/employer's preference. I expect criticism. But: 1. Most of my students are using WinXP. 2. VJ#.Net Express is free and has an outstanding GUI. 3. Code written in VJ#, via the Mono Project could always be ported to other platforms. 4. Java compiler source seems close to moving into Open Source - I think! So whichever choice the students makes, learning the essentials of Java programming can be accomplished. What is ...Show All

• SQL Server Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. Joey gives an answer how. You could also do: declare @query varchar(max) set @query = 'select col ' + cast(@param as int) + ' from table' Or if the column names aren't actually numberd, use a CASE expression to pick the columns. The question I have is why do this If all columns are only useful one at a time, this is probably a design issue. If this is to support some use ...Show All

• Software Development for Windows Vista IGraphBuilder vs FilgraphManager

  I am trying to get a HD mpeg file to play in DirectShow using C++. I have two different applications one in C# and one in C++. The C# application renders the HD mpeg file just fine and the C++ programs gives me the following error "An invalid media type was specified.". I the documentation is said that IGraphBuilder was the same or similiar to the FilgraphManager. Here is the C# code that works: m_objFilterGraph = new FilgraphManager(); m_objFilterGraph.RenderFile(openFileDialog.FileName); m_objBasicAudio = m_objFilterGraph as IBasicAudio; try { m_objVideoWindow = m_objFilterGraph as IVideoWindow; m_objVideoWindow.Owner = (int) panel1.Handle; m_objVi ...Show All

• Visual Studio VS 2005 SP1 Beta doesn`t want to install

  I`m not commenting the decision to use windows installer patching system right now (long story short: 1GB of memory wasn`t enough), but after an hour or so the installer doing who knows what atm just died with a very informative message: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The number was different the first time I think, when I ran out of free space. And as I click OK it just keeps poping again and again. Oh, wait... it`s stopped after 40- or 50-something clicks. Now, after some time, we have this: Error 1935.An error occurred during the installation of assembly 'CppCodeProvider,Version="8.0.0.0",PublicKeyToken="b03f5f7f11 ...Show All

• Visual Studio Team System WorkItemChanged event handler throws exception!

  I wrote a simple handler for the WorkItemChanged TFS event. The registration went fine and the handler is called when the event is triggered. So far so good. But, as soon as I try to get the WorkItemStore object inside the handler method, a ArgumentException is thrown:   Error:   Cannot pass a GCHandle across AppDomains. Parameter name: handle ,     at System.Runtime.InteropServices.GCHandle.InternalCheckDomain(IntPtr handle)    at System.Runtime.InteropServices.GCHandle.FromIntPtr(IntPtr value)    at CProdStudioObjectRoot.{dtor}(CProdStudioObjectRoot* )    at ATL.CComObject<CCurrURILink>.{dtor}(CComObject<CCurrURILink>* )    at ...Show All

• Visual Studio Express Editions Textbox problem?

  Hello guys, I have a question about textbox, the question is how can I retrive data from a database to display in only one textbox, the data will appear if the user fill in the other textbox for example, company address will appear if the user key in the company name textbox. Thank you. The general idea is that the contents of the textbox are used as a parameter to a SQL select statement which is then used as a datasource for other textbox controls which are bound to the dataset returned by the SQL statement. I would probably recommend having a search button - which would execute the population of the dataset rather than trying to do it on a text changed event on the textbox as you will get a lot of database traffic ev ...Show All

• Windows Forms Do Not Merge Menus of MDI & Child

  I see several threads over the past few years on how to merge menus from the child on to the MDI - as it does this by default it's just a matter of how you want them to appear. However, I would like to maintain 2 separate menus - 1 on the MDI, and 1 on the child. If I change the Merge Type from Add to Remove it removes it from the MDI menu, but does not display it on the child form. Any suggestions would be appreciated. GRaab Ok, color me blind. I didn't see that you mentioned you were using VB 2003 in the last post. The stuff I was talking about only applies to the newer menu strip items in v2.0. For future reference if you aren't using VS2005 you should probably mention that in the subject header or in the initial messag ...Show All

• Smart Device Development PocketPC Desktop -Synchronizing issue

  Hi, Well ,I am working in PocketPC (eVC++,VC++6.0) I have to Synchronize the PocketPC and DesktopPC . For Synchronizing am using ActiveSync I have a Folder in the desktop for example D:\Temp\ I have a Folder in the PockePC in the Device Root for example: \Temp . I am coping a text File from desktop and placing it in the Device (PocketPC), say for example \Temp\Text.txt in the device. when i do this i create a .dat file (say Test.dat) ,now what happens is, i place both Text.txt and Test.dat in the Temp folder. so the same file (Test.txt) is copied in desktop ( D:\Temp\Test.txt) This for a single file. Suppose I have multiple files and large size files, what I did is, I transfer all the Files using Getpacket and Setpacket. My Problem is ==== ...Show All

• Windows Forms Problem calling event from control

  Hi, I have a control, SimpleSplitter , that derives from Splitter where I override the OnMouseDown , OnMouseUp , OnMouseSplitterMoved and OnSplitterMoving . I do this because I don't want the Splitter to handle these for me since it will draw what I call a shadow splitter when handling these events. So I wanted to still handle the event but not call the OnMouseDown of the Splitter , instead, I wanted the parent of the Splitter , that is the Control . I'm not seeing how I can do this. If you don't understand what I mean, you have the code here: http://n0n4m3.gamedev-pt.net/ pag=managed_component2&language=en The solution I used was to create a new event, MouseDown2 , but I don't like this solution and I think there's a better one. Tha ...Show All

• Visual C# W3wp.exe Application Error - Exeception breakpoint - break point has reached

  Hi All,           We are getting following error message on our Win2003 server. "W3wp.exe Application Error - Exeception breakpoint - break point has reached". We are running the Asp.net2.0,1.1 and SQL 2005 and IIS6.0. for this application is pointing Asp.net1.1 and sql 2005 and we are added one ISAPI filteration for SEO friendly URL. We are getting above error message.... AOur application is not ruuning... For ISAPI filtration dll, we are used VC++ ->  MFC6.0. Error Message in Detail ----------------------------------- W3wp.exe Application Error The Exeception breakpoint break point has been reached (0x80000003) occured in the application at the location 0x7c82 ...Show All

• Visual C++ _CRT_SECURE_CPP_OVERLOAD_STANDARD_NAMES couldn't work

  I used /D "_CRT_SECURE_CPP_OVERLOAD_STANDARD_NAMES" in the configuration of the project property. It solved secure problem for functions like sprintf. However, fopen, fscanf, sscanf still report something like: c:\mvs2005\bs_module\source\utility.cpp(1639) : warning C4996: 'fscanf' was declared deprecated c:\program files\microsoft visual studio 8\vc\include\stdio.h(249) : see declaration of 'fscanf' Message: 'This function or variable may be unsafe. Consider using fscanf_s instead. To disable deprecation, use _CRT_SECURE_NO_DEPRECATE. See online help for details.' I don't want to use _CRT_SECURE_NO_DEPRECATE, because I want the warning pops up whenever there is a secure problem. I believe the three functions listed ...Show All

• Visual Basic VB.Net SQL Server 2005 Accessing a stored Procedure via a datagridview

  Hello, I've created a datagridview from a table in SQL server 2005. In the table I have one text field and two bit fields that I'd like to be updated from the datagridview during runtime. I need to know how to do this with in line sql as well as by hitting a stored procedure. Dim cmd As New SqlClient.SqlCommand() Dim param As SqlClient.SqlParameter Dim dr As SqlClient.SqlDataReader Dim conn As New SqlConnection() conn.ConnectionString = "Data Source=xxxx;Initial Catalog=xxx;Persist Security Info=True;User ID=xx;Password=xxx" cmd.Connection = conn cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "makeuncallable" param = New SqlClient.SqlParamet ...Show All

• SQL Server Executing Package Question

  Hi, Simplification of setup: - SQL Server Box with Enterprise Edition of SQL Server 2005 - Workstation with the client tools (Managment Studio, Business Intelligence Studio, etc) SQL Server 2005 installed running Windows XP 1. Am I right in saying that I need to install the SSIS service in order to run this package on my workstation from the command line, the Execute Package Utility tool, or through Management Studio 2. I can however execute the package on my workstation in the Business Intelligence Studio without the SSIS service installed, correct 3. Assuming I need to install the SSIS service on my workstation, if I execute the package via the command line or the Execute Package Utility utility, will it run on my local machine or on the ...Show All