Ben Vaughan's Q&A profile
SQL Server cant connect to MSSQL Server Express 2005
Hi, i have installed MS SQL Server Express 2005 on my local machine. Also the managment Studio. I can connect to the MS SQL Server Express 2005 with my c# programm and with the mangament studio. I have in Windows/system32 the file ntwdblib.dll version 2000.80.2039.0. The TCP/IP and Ip Protocl are active. But i cant connect with php to the local MS SQL Server Express 2005. My php code is: mssql_connect('192.168.0.2,1433', 'martin', ''); I get the return code Warning : mssql_connect() [ function.mssql-connect ]: Unable to connect to server: 192.168.0.2,1433 in c:\Inetpub\wwwroot\Projekte\Skripte\mssql_connection.php on line 2 Does anyone know what i made wrong or i have forgotten mfg martin Hello, i use W ...Show All
Smart Device Development how to make the server on wince interact with any other clients like java ,win32..
Hi i have build up application on wince for TCP server n client using socket programming . I am using functions WSAStartup socket() bind() listen() accept() recv() at Server side and WSAStartup socket() connect() send() at Client side The wince client is able to interact with other servers like java ,win32 etc (using activesync on emulator only) but other clients like win32 , java etc are not able to interact with the wince server(through emulator). I tried on the smartphone (windows mobile) the same code , but the wince client gives a connect error. The Server function which fills the structure from which I am extracting the address is:- remoteSocket = accept(listenSocket, // Listening socket (LPSOCKAD ...Show All
SQL Server How to handle multivalue field?
Here is my scenerio: I tried to do a comprehensive catalog of my classical music collection, and my most basic unit of data is a track from a CD. As it happens, a track have a variable number of performers (e.g. a symphony may contains a conductor and an orchestra, a string quintet may contains five members, a piano trio contains three members, etc.), so I can't easily provide a field for performers. I have a table for performers and another for tracks (along with other things). Since I have a large number of tracks, it would be very undesirable to create an additional table relating every individual artist with a track (it would blow up the database size and is rather unnecessary). So my ideal solution is a multivalue field for perf ...Show All
SQL Server forms in reporting services
Is there a way to insert forms in reporting services. If so, how would this be done> Andrew, I know that you can't create forms in reporting services, but you can import a form in to the system. Do you know how that would be done. ...Show All
Windows Forms Problem displaying image with alpha
Hi, I'm having some problems displaying an image with alpha. Here's what I have // get the image bits from an handle IntPtr imgBits = GetSurfaceBits(m_surfaceId); // create a new bitmap from these bits m_bmp = new Bitmap(512, 512, 4 * 512, PixelFormat.Format32bppPArgb, imgBits); To display it: private void panel1_Paint(object sender, PaintEventArgs e) { using (Graphics g = e.Graphics) { // clears the panel to blue g.Clear(Color.CornflowerBlue); // this doesn't do anything if (m_bmp != null) g.DrawImage(m_bmp, 0, 0, m_bmp.Width, m_bmp.Height); } } I'll just get a blue panel when doing this. The bitmap is correct because if I do: m_bmp.Save("test.png", ImageFormat.Png); the image gets saved correctly ...Show All
SQL Server Restoring to a new DB - The basics
Hiya, I've recently gotten into the administration side of SQL and am muddling my way through it as best I can. We have a DB server with three or four databases on it. Maintenance routines do a full backup of each one nightly and weekly and put all sets into one backup (.bak) file. I've never had to restore them, but I thought I'd put myself through a test run since this is unexplored territory for me and I would prefer not to have to learn in an emergency. A scenario I can foresee is where I'd have to restore just one table, perhaps to a new location (i.e. not overwrite the live db, just bring up a copy of part of it elsewhere so I can do a data dump from some old data). But when I go to 'restore database' or 'restore file/filegr ...Show All
SQL Server Error :(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
Hi, I am trying to connect to my SQL Server 2005 but it gave me following error message. TITLE: Connect to Server ------------------------------ ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) So, Please help me to solve this problem. tnks. hi, i found the solution...Actually the error was because the wrong character used instead of using '\' i have us ...Show All
SQL Server Microsoft report builder is a very BAD product
This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. You may want to rethink your architecture from the ground-up. try to build a cube with multiple fact tables and multiple measure groups then build your report on the top of this. Philippe ...Show All
Visual Studio Express Editions Alternate text for picturebox
Hi, I am inserting a picture of a person when FirstName and LastNames are typed into two text boxes, a button is clicked and this is searched for in an associated database. I want a picture box to display a picture of the person found for verification. I looked up the Books online. Is this what I put in the VB file Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' Browsers that do not support an image format ' will show alternate text. PictureBox1.AlternateText = "This is the image of the person searched for." End Sub VB tells me that "PictureBox1 is not a member of Systems.Windows.Forms.PictureBox. How do I set alternative text on mouseover I know how to do ...Show All
Windows Forms Property Grid
Does anyone tried using a Property Grid. If yes, does it have a textchanged event. I do not see an event other than the valuechange which fires on tab of the cel.. What I want is an event that fires as soon as the user types in a key in the cell. Thanks The PropertyGrid control has both a TextChanged and PropertyValueChanged event. BTW please post WinForms related questions in the WinForms forum. Please reserve the BCL forum for questions related to the BCL that are not covered elsewhere. I'm moving your question to the WinForms forum. Michael Taylor - 10/2/06 ...Show All
Visual C++ Dialing through Modem VC++.net
Hi, I need the find a method to dial a phone number from my visual c++.net program. Hope some one can help me. dki C++/CLI version of How to: Dial Modems Attached to Serial Ports in Visual Basic void DialModem() { System::IO::Ports::SerialPort ^ port = gcnew System::IO::Ports::SerialPort( "COM1" , 9600); port->DtrEnable = true ; port->Write( "ATDT 555-0100\r\n" ); } ...Show All
Windows Forms IsMdiContainer
Is it possible to define the size of the MdiContainer Sorry the bad english. Thank you. I have it like this: #region ToolBar1 private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e) { if (c1 == false ) { Form2 tobogan = new Form2(); tobogan.MdiParent = this; MdiParent.Size = new System.Drawing.Size (100,100); tobogan.Show(); c1 = true; } } #endregion ...Show All
Visual C# Exception Breakpoint on Application Termination
I am using C# 2005 Express edition. My application runs fine but on closing I get the following message (for some reason I can't take a screenshot of the dialog) The exception breakpoint A breakpoint has been reached (0x80000003) occurred in the application at location 0x7c90130 This happens in the debug version and release version. My first reaction was that I had left a breakpoint in the program, my second that it is related to the debug version. I am new to C#2005 and could not find any swicth to change the build type from debug to release so don't know if calling for a Build automatically created a Build version. I would like to get rid of it since it would be annoying for my users Thanks in ad ...Show All
Visual C++ Visual C++ 6.0 and Visual Studio .NET
I have an old program (I programmed quite a long time ago with Visual Studio 6.0) that i want to transfer to Visual C++ .NET however, i have since lost the source code to it. Do you know of a de-compiler that i can use on the .EXE file that will give me that source code Thanks in advanced. D. Rux Dan Rux hi, I am afraid that there is not a way to get your source code from the .EXE file. The only thing that you can obdain from any .EXE file is only assembly language code (useless i think) and i am not sure if this can be done by Visual Studio. ...Show All
Software Development for Windows Vista Vista Beta 2 - Missing theme parts?
Hi, I'm currently developing under Vista and maintaining apps written for Windows XP which use custom drawn theme elements quite extensively and have noticed that various parts of the default Vista theme are not defined - for example: "startpanel" no longer has "SPP_USERPANE" defined for DrawThemeBackground() Obviously, I realise that Vista doesn't make use of the top/bottom elements of the startpanel like WindowsXP does but am wondering if I am to expect themes to be 'partially' defined like this in the final version Ok, I can check the OS i'm running on and whether the result of DrawThemeBackground() is S_OK (or checking if the part is defined) but i'm unsure as to whether start making adaptations now based ...Show All
