c.v.'s Q&A profile

• SQL Server Setup failed - no package <sqlncli.msi>

  I tried to install a sql 2005 desktop engine. This fails with the error: An installaton package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli.msi’   I used a fresh, new download SQLEXPR.EXE. What shall I do   I have the solution. If someone is interested:   ...Show All

• SQL Server Querying Oracle v8.1.7 with multivalue parameters

  I am currently working towards an Oracle server through Microsoft SQL Server Reporting Services (2005) and I am troubling with an "ORA-12704: character set mismatch" error when I generate my reports. What I'm trying to do is to run a query using multi value parameters from Reporting Services to the Oracle server. This have worked fine until recently towards an Oracle version 9 database, but now I'm trying to make it work ...Show All

• SQL Server Missing ODBC DriverI ran the check against "MDAC 2.8 SP1 ON WINDOWS XP SP2."

  I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager. "A connection could not be established to SERVERNAME\INSTANCENAME . Reason : Data source name not found and no default driver specified. Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME ...Show All

• SQL Server Query Empty node

  Hello, I have an XML file which contains different shops, where a certain node (<openinhours>) is empty in some occasions. The node displays as <openinghours /> in my xml file in that case. Now when I try to get the openinghour value of all the shops, it shows an error that I cannot atomize. Is there any way to check if the node contains text by using the value or exist Thanks in advance! ...Show All

• SQL Server ...cannot be run because the SSIS subsystem failed to load....

  Greetings all, After moving all my packages to a new server, win2K3, SQL2k5, non of the SSIS packages run. They all ran fine on the other server. The error is "2006-03-07 13:09:38 - ! [LOG] Step 1 of job 'ExportXML' (0x4E0C7495EFE4034FA6EF94B7C7F77262) cannot be run because the SSIS subsystem failed to load. The job has been suspended" These packages ran perfectly on the old system. Running the package manually, using DT ...Show All

• .NET Development LPT port mode changing

  Hi. How I can change LPT port mode with .NET (or even with WinAPI) to EPP mode Regards. Eugene. The team that monitors this forum doesn't work with LPT ports. This forum is specific to the objects contained in the System.Net namespace, so you may not get a response to your question here. I will, however, leave the question open for a while just in case someone from the community knows the answer to ...Show All

• SQL Server How to set data regions to have a fixed height

  Hi, I am having a problem with my report. I would like to display this way -------------------------------------------------------------------------------------------------- <Main Report> Employee Name: XXX Employee Address: xxxx ------------------------------------------------------------------------------------------------- Subreport consisting of 2 tables Code / Description / Amount ! Code / Desc ...Show All

• Visual Studio Team System Team Foundation Server

  Hi how do go about implementing Team Foundation Server beta 3 in our company. We are 3 users. I understand i have to install TFS on the server and the TF client on our workstations, but we all have SQL Server 2000 installed. Other applications on our server use SQL server 2000. how do i go about doing this Must TFS run with SQL Server 2005. we dont want to upgrade to 2005 we dont see a need to. Please help.   Wesley .Net De ...Show All

• Visual Studio Express Editions SQL 2005 Express Connection Problem

  I have a sql 2005 express. And I have a client PC in different WAN . But I can't connection SQL 2005 express to other WAN Pc. I can use in sql 2000 but I can't use in sql 2005. What is a different connettions thnks. Depending on your configuration you may have some additional step after turning on remote connections: 1. If you are running a named instance which is the default for SQL Express, you would need to enable SQL Browser unless y ...Show All

• Visual Studio Tools for Office Serious error when hide the column

  Hi, I have one ListObject on ExcelSheet defined as: Microsoft.Office.Tools.Excel.ListObject myListObject = this.Controls.AddListObject(this.Range["A10", missing], "myListObject"); Then I am binding this listobject as follows: DataSet dsTrims = new DataSet(); string strWhere="select col1, col2, col3, col4 from tableTrims"; dsTrims = MyProvider.ExecuteDataSet(System.Data.CommandType.Text, st ...Show All

• Visual C++ Background color/image in CTabCtrl

  Hi I'm trying to paint a color or put an image in the background of my tab control (a derived class of CTabCtrl ) with no success so far. +--------------------------------------------------------------+ | TAB A \ TAB B\ TAB C#################################| +--------------------------------------------------------------+ | | | | | | | | | | | +--------------------------------------------------------------+ I managed to have something in th ...Show All

• Windows Forms Method '&lt;method&gt;' cannot handle Event '&lt;event&gt;' because...

  I am getting the following error where ntfHelpDesk is a NotifyIcon. <color="firebrick">Method 'ntfHelpDesk_DoubleClick' cannot handle Event 'DoubleClick' because they do not have the same signature.</color> Any help is appreciated. <quote> Now that I'm  ...Show All

• SQL Server CLR Trigger

  Hi,       I want to call webservice in the Trigger.  How to call the webservice from CLR Triggers .If anybody knows teh detail let me know.   And i worked out  the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using System.Data.SqlTypes; using System.Data.SqlServer; namespace CLR {   & ...Show All

• Visual C++ SqlConnecT?

  Whenever I try to connect to my database using C++ .NET i get this error: .ERROR: \sqlconnect.cpp(29) : error C2664: 'SQLConnect' : cannot convert parameter 2 from 'const char [11]' to 'SQLCHAR *' if (connection_handle != NULL) { return_code = SQLConnect(connection_handle, "ADEL" , SQL_NTS, "sa" , SQL_NTS, "sa" , SQL_NTS); } I'm trying to connect to database ADEL username and pass ...Show All

• Visual C# GridView and Row No.

  Hi, I get a problem in showing row no label in my GridView. The first time when I populate from database it was fine. It show the no. ascending as I want to. But, when I sort the Grid, the row no is not in order. My question is how could I show that row no in order though I sort the grid. I used ASP.Net 2.0 with SQL2005. For the row no, I test with two ways. First one is ROW_NUMBER() sql function. Next one is put the blank ...Show All