KevinC123's Q&A profile

• SQL Server Catch Error message in Variable?

  Greetings all, When an error occurs it is written to a log file (Assuming you have loggin on). Anyone know of a way to catch the error in a variable When an error occurs I send an email explaining where there error happened and to view the logfile. I would like to include the last error in the email. Saves having to go view the log... Thanks Yes there is a way. In fact, its done for you. The OnError eventhandler has a system variable scoped to it called @[System::ErrorDescription]. That variable contains the error message of the error that caused the eventhandler to fire. Please reply if any of that needs clarifying. -Jamie ...Show All

• Visual Studio Attention: July CTP Source Control and Web Site developement

  If you are doing Web Site development and the Web Site is under Source Control in Visual Studio, we do not recommend that you download and install the July CTP (see issue below) The Problem When you open a Web Site that is under source control in Visual Studio, it fails to get registered with Source Control. You will see the following error: "The project '<path>' is under source control.  An error occurred registering this project with source control.  It is recommended that you do not make any changes to this project." That means that although you can still work with the Web Site in Visual Studio, you will not ha ...Show All

• SQL Server Registry to store configuration values ?

  I try to store a SSIS-configuration value in the registry. But it's failed. I get a warning, that the registry-key is not found. What is the syntax I have searched in BO,MSDN and  Google/Internet ==> nothing. There is no example.     In the registry you have this entry: HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1\value In Value you store your connection string In the SSIS-Configuration the reference is: SOFTWARE\ProjectName\Connections\ConnectionString1 Loom ...Show All

• Visual Studio VSS Internet Web Service under non-default web site

  The SourceSafe Internet Web Service setup tool in SSAdmin.exe is hardcoded to create the SourceSafe web service virtual directories under the Default Web Site.  When the tool is calling into ADSI to configure the virtual directories in IIS it is always using " IIS://localhost/W3SVC/1/ROOT" and so the virtual directories always are rooted under the Default Web Site.  If you are using Windows 2003 Server and wish to move the SourceSafe web service virtual directories, you  can save the virtual directory configurations and re-create them under another web site. The steps are: 1. Use SSAdmin ...Show All

• .NET Development VB.net 2003 installed with VB6. Now I cannot access remote SQL Servers

  Hello I have been happily using VB6 for years and have had no problems with connections to remote SQL servers using ado. I have just installed VB.net 2003 Enterprise (cos is looks shiny and fun  ;-)  )  and when I return to continue programming in vb6 which I left on my computer I find it wont connect anymore to any server except the database engine on my own computer. At the same time I find that the enterprise manager of SQL server also cannot connect to any remote SQL server. The connections all work perfectly to my own computer but not to any other. Is this permanent, do I need a patch of some description, is vb6 unable to ...Show All

• .NET Development Getting child tables position

  Hello I have a code like this: DataTable masterTabelle= new DataTable("Master"); DataTable subTabelle= new DataTable("Sub"); myDataSet.Relations.Add(masterTabelle.Columns["SubID"], subTabelle.Columns["ID"]);   On a DataGrid's Datasource i set the myDataSet.Tables["Master"]. Now if I navigate through the DataGrid, I'm getting the Position of Master table's row with the CurrencyManager. But through the Master I'm expanding the Child ("Sub" table) and how I can get the Position with CurrencyManager of the Child table Or how I can bind a field on the child table (still over the relation with Master table) to a control To make this ...Show All

• Windows Forms How to print true black barcode?

  Hi, I have a problem. Barcode printing on plastic card from program develloped with Visual Studio 2003 using PrintDocument component or Crystal Reports for .NET goes wrong - barcode prints "in composite black using YCM colors" instead of printing "in true black using only K color". Without problems I can do the same job from Delphi 4 QuickReports or from MS Access 2003 Report. Please help me with any ideas Thank you, Juozas Kimtys Hi, Thank you for the answer. It is good idea to look to printer settings, but there is no user accessible settings for my two different card printers from different manufacturers that h ...Show All

• .NET Development Remoting Configuration in VS2005

  Hi there, I'm trying to configure the remoting services and channels of an application using the app.config file in VS2005. It keeps giving me an error telling me that it... Could not find schema information for the element 'application' as well an error for every other child element under the <system.runtime.remoting> element. Here is the start of the configuration.... < configuration > <!-- Configiration of the Remoting system --> < system.runtime.remoting > < application > < channels > < channel ref = " tcp " port = " 6565 " & ...Show All

• Windows Search Technologies Address bar - locked

  my address bar will to type in the full name of a web site, but once complete it will not pull up the site, it stays on the main msn page. Like typing in www.miamidolphins.com - but while typing it will drop down and offer a list of sites, if i pick one of those I can go straight to the sight or choose from my favourites. but to actually type a new site name in the address bar and click go - it goes no where. how do I solve this i do have google and msn tool bars open help maggie ebersold Hi Maggie, Your issue doesn't appear to involve Windows Desktop Search - does it Thanks, Bill ...Show All

• .NET Development TableAdapters/XSD Schemas/XPath Query and the Update Function

  I am starting a new thread as I have not seen in other threads people using the same combination of technologies. I have been working on this problem for the last 2 weeks and am completely stumped!!!! Here is the scenario: I am having problems with SqlXmlAdapter.Update.  I am running Visual Basic Express 2005 and SQL Server Express 2005. Here is the code that does not work...  I hope this is enough to work with... ____________________________________________________________________________________________ Dim mvarConnection as String = "Provider=SQLOLEDB;Server=" & sqlServer & ";database=" & sqlDatabase & ";user ...Show All

• Visual C# i have error :(

  hi, can anybody help me when i want to save the record in access database and i cannot save it this is error http://www.geocities.com/qtruni/eee.JPG and this the code for save button +++++++++++++++++++++++++++++++++++++++++++++++++++ private void Savebutton_Click(object sender, System.EventArgs e) { if (sidTextBox.Text != "" && fnameTextBox.Text != "" && lnameTextBox.Text != "" && nationalityTextBox.Text != "" && phoneTextBox.Text != "") { OleDbConnection myCon = new OleDbConnection(strCon); // OleDbConnection my ...Show All

• Visual Studio Team System Make a new field depending on "Assigned To"

  I added a new field called "Responsibility" to the Bug workitem. And I was trying to make it dependent on "Assigned To". Say, when "Assigned To" is set to user A, "Responsibility" will show "QA". Below is what I did for the new field, but it doesn't work properly. My problem here is the new field value won't get updated correctly, unless I empty the "Assigned To" box first and then select user. Any help is greatly appreciated. <FIELD name="Responsibility" refname="MyCompany.VSTS.CMMI.Responsibility" type="String" reportable="dimension"> <HELPTEXT>The responsibility of the defect</HELPTEXT> <ALLOWEDVALUES> < ...Show All

• Windows Forms disable add new row?

  How can I eliminate that new row line at the end of my datagrid. I need the grid to be editable, but don't want users adding a new row. You have to create a DataView for your table and set the AllowNew property to false. DataView dataView = dataTable.DefaultView; dataView.AllowNew = false; dataGrid.DataSource = dataView; ...Show All

• Windows Forms .NET Framework 1.1 Released!!!!

  The latest version of the .NET Framework has been released.  This version contains hundreds of bug fixes and a few new features.  Download it today from: <a href="http://msdn.microsoft.com/netframework/">http://msdn.microsoft.com/netframework/</a>  - mike <a href="http://www.gotdotnet.com/team/changeinfo/default.aspx">Compatibility Considerations and Version Changes</a> ...Show All

• SQL Server SQL Server Developer Edition Migration Wizard

  Hi, It appears that the migration wizard is not installed with the developer edition of SQL 2005. I have installed another version of SQL 2005 and have run through the migration wizard. With what editions of SQL Server the migartion wizard comes as a default Thanks, Vaishu I do not think there is a migration wizard. SQL Server 2005 setup detects all SQL Server components automatically during installation. One approach to upgrade SQL Server 2005 Developer edition to SQL Server 2005 Enterprise Edition is as follows. 1. Install SQL Server 2005 Developer Edition. Suppose the instance name is SQL2005DTE. 2. Start ...Show All