MKB's Q&A profile

• SQL Server SQL Memo datatype

  I hope I'm in the right forum I have a simple VB.Net application that records Engineering Change Requests.  Currently I'm using varchar fields to record proposed changes.  I'm using varchar since I don't know what the datatype that is equal to the MS Access Memo datatype. I did look in the help files with limited success.  If I remember correctly it said that you can use the Image datatype to store large amounts of data.  Whe ...Show All

• Visual C# Help

  Below is my code which i used in my web application, but when i add multiple item into the arraylist and traverse through the arraylist, the arraylist is empty. Please help, public partial class _Default : System.Web.UI. Page { Item item; ArrayList al= new ArrayList (); protected void Page_Load( object sender, EventArgs e) { } protected void btnCreate_Click( object sender, EventAr ...Show All

• SQL Server table schema changes not being propagated - merge replication

  Hi, I have attemped to change column types (i.e. from int to varchar(8)) on read-only published tables. I used ALTER TABLE ALTER COLUMN to make the change, and according to BOL this should make sure the changes are seen at the subscribers. Unfortunately, after I make the change to table and run sp_enumeratependingschemachanges, I do not see the table changes listed. However I can make changes to SPs and UDFs, and they do show up in sp_enumeratep ...Show All

• SQL Server Logging of SSIS package doesnt work when executed as a job

  I am having the same problems as those in another post. SSIS package works fine when executed in BIDS and through execute package utility but it doesnt work when executed as a step in a job. The other problem is that the logging also doesnt work when i try executing it as a job. So I have no clue about what to do without knowing what error it is. When I run the job it simply says the step has failed. I have tried most of the solutions post ...Show All

• SQL Server Getting Error while connecting to Reporting Server

  Hello,     I am trying to connect to my Reporting server. I get the following error message. Does any one get the same error and work around  TITLE: Connect to Server ------------------------------ Cannot connect to RAJUVENKAT. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with ...Show All

• .NET Development xml data into SQL Server table

  How can I import data in an xml file into a table in an existing SQL Server database It can be used as a means to  Import/Export data into an existing table. ...Show All

• .NET Development Changing CanonicalizationMethod Algorithm

  I'm trying to interop with a service provider's web service.  They are currently requesting that messages be signed with an X509 certificate. The reference request notes the following Canonicalization algorithm:   <CanonicalizationMethod Algorithm=" http://www.w3.org/TR/2001/REC-xml-c14n-20010315 " /> However, the WSEv3 output produces the following algorithm: <ds:CanonicalizationMethod Algorithm=" http://www.w3.or ...Show All

• Visual Studio 2008 (Pre-release) Separate SQL Server (2000 in this case)

  How do you instantiate the db with LINQ if the SQL Server is separate from the application server All the samples I've seen do it like this: Northwind db = new Northwind ( "c:\\northwind\\northwnd.mdf" ); Is the following how you'd do it, say in a shared hosting type situation (except that the connection string itself would be stored in the web.config, of course) Northwind db = new Northwind ( DataSource=<serverIp>> ...Show All

• Visual Studio 2008 (Pre-release) Peer Channel performance

  Hi all! I am building a p2p application using WCF and the peer channel and one of the requisites of this application is to be able to send the higher number of updates per second. While doing some profiling, I noticed that server was sending (at least the sending method executed and returned) at the rate I had specified but clients were receiving at a variable rate. For instance, I specified an update rate of 170 miliseconds on the serve ...Show All

• Visual Studio Uninstalling Add-ins - removing toolbars

  Hi all, I have an addin for VS.NET which I've recently altered to work with vs2005.  I'm having an issue with uninstallation though.  When my uninstaller runs, it runs 'devenv /setup' to remove the toolbars for each of the Visual Studio versions installed.  This works (albeit with ugly consequences) on VS2003, but on 2005 my add-in's toolbar and commands are still present. Some searching around yielded the /resetaddin command, whi ...Show All

• SQL Server How to create XML documents over 8000 bytes?

  I have a script transform object that is creating XML to be inserted into a SQL 2005 database. It seems only an N_TEXT can be inserted, but N_TEXT is read-only in the script task.  The only way I've found to make this work is to have the script transform produce the XML into a DT_STR(8000) string, then convert that to N_TEXT in a Data Conversion task so it can be inserted. Now I have a problem in that my XML has exceeded the 8000 byte DT_ ...Show All

• .NET Development DataGridView able to display different tables from .mdb?

  Hi, What I need to do is probably extremely simple to do but it seems I just can't find out how. I want to: -Display a form with a datagridview on it. -A button with an OpenFileDialog, which will be used to choose the .mdb file to load. -A combobox showing all the tables available in the .mdb -I want the datagridview to show the table selected the in the combobox...<---That's where I'm stuck... How the heck is it possible to do tha ...Show All

• Visual Basic Need a VB6-to-VB.NET translation

  I have a block of VB6 code to be translated into VB .NET if possible. The block of code reads as follows: Option Explicit Private Sub cmdClose_Click() Winsock1.Close End Sub Private Sub cmdConnect_Click() Winsock1.RemoteHost = InputBox _ ("Enter remote host (IP address or name)") Winsock1.RemotePort = 1066 Winsock1.Connect End Sub Private Sub cmdSend_Click() If Winsock1.State = sckConnected Then Winsock1.Se ...Show All

• Visual Studio Team System Project creation problem TFS Beta 3

  Hi, first of all complements to the great improvents made on the install of TFS beta 3. much easier. I still have a problem though. When i try to create a project i get the following error Error Unable to connect to the specified SQL Reporting Services at http://url:8080/ . Explanation The Project Creation Wizard was not able to connect to the SQL Reporting Services at http://url:8080/ . The reason for the failed connection cannot be ...Show All

• Software Development for Windows Vista Unable To Debug WWF Projects

  For some reason when I try to debug a WWF project  (code debug) by using the start "Debugging -> Start Debugging" menu item, the project builds successfully but does not lauch the program into the debugger. If I run the project by using "Debugging->Start Without Debugging" the application runs fine. Any thoughts Pete If your host is asp.net, you need to attach to w3wp.exe (win2003) or aspnet_wp.exe (win xp) and select workflow d ...Show All