claudio32's Q&A profile

• SQL Server Import problem with varchar(max) field

  I'm trying to import some Assessor data from a text file into a table and the field for Legal Description (column 2 in the source text file) in the table is of data type varchar(max) because some of the data goes over the 8K size. I get an error on the first row of importing that refers to column 2 (see 'Initial errors' below). I read the related post and changed the size of input column 2 to 8000 and got this error. Finally I set the size of the of input column 2 to 4000 and it ran. So I'm thinking there is a limit on the size of varchar data that can be imported. Just want to clarify what that limit is and how I might go about importing this data. Thanks, John Error with input column 2 set to size of 8000: Setting Destination C ...Show All

• .NET Development .NET Client Accessing COM+ written in .NET Problem: Method not found.

  Hi, all. I have problem with COM+. I created COM+ with C#.NET. I have to call this COM+ from window application(in C#.net) remotely using late or early binding. I called COM+ with late binding, it throws 'Method not found' exception. And I don't know how to do early binding. I didn't have problem to calling COM+ written in VB. I add reference from COM tab. It works ok. However, when I try to add reference of COM+ written in C# from COM tab, it throws error message, "A reference to 'COMPlusServer2003' could not be added. Converting the type library to a .NET assembly failed. Type library COMPlusServer2003 was exported from a CLR assembly and can not be re-imported as a CLR assembly." I tried to add reference from just .NET t ...Show All

• Software Development for Windows Vista How to CreateProcess NOT as administrator

  One of our modules is an executable that will always be run as administrator (after getting permission from user). One of its screens allows the user to run a different executable, which the code currently does by CreateProcess. The problem is that since the first process is running as admin, CreateProcess has the second process run as admin also. This is undesirable because it is a security breach (the second process can open browse dialogs that should not have admin privileges in this scenario). How do I get the second to run without admin privileges I do NOT want attach a manifest to the second exe that says it does not want admin privileges because under certain circumstances (not from the first exe), it SHOULD be run with admin privil ...Show All

• SQL Server Wrong connection when switching computer

  Hi My C# application has a DataGridView which is bound to a DataSet. I used Visual Studio to add/configure the data source. Everything works fine on my computer. When I try to run the application on another computer I can't connect to the database, because it uses a wrong connection string. How can I make a specific connection/connection string permanent for a specific application Thanks. What do you mean with wrong connection string is the connection string pointing to the local computer and you always want to reference the local computer Then you might fix your problem by using the (local) keyword rather than the machinename for refering the Server in the connection string. Connection strings s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I work with Windows Forms (using C++) and Directx9??

  Hi, I need a help!!! I need a example what show me how to work with windows Forms (using C++) and Directx (9), step-by-step, since declarations until how I create a form and draw inside it a line or other picture, I need a example what make this, if someone can help me..... Tks......... Tks..... But I can’t add a reference Microsoft::DirectX, when I go add a reference, I put Microsoft:: and show only CSHARP and Win32, u need show me a handle of sample code, using C++ I have a problem with this......... Tks.............. Sorry with my english, because I’m brazilian.... ...Show All

• SQL Server how to call web service from within Script Component ?

  Appreciate if anyone can show me the code to call a web service from Script Component I cannot use the Web Service Task. Because parameters to the webservice are from rows of data inside Data Flow Task. Thanks !! mf915 wrote: thanks ! but the book is not available from rationalpress.com until March :( Don't worry. You can get the beta preview version. It contains the same stuff: http://www.amazon.com/Rational-Scripting-Integration-Services-Preview/dp/1932577211/sr=1-2/qid=1171050141/ref=sr_1_2/102-7891523-4086513 ie=UTF8&s=books -Jamie ...Show All

• SQL Server Scheduling bug?

  Hi! I'm trying to create a subsciption for my report. In first creation I can do scheduling just fine, but when I try to edit my schedule, it's totally different. It shows value 1.1.0001 and when I try to change it, it's gives me first message: value of '1.1.0001 0:00:00' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'. Parameter name: Value (System.Windows.Forms) and after that when pushing OK it gives me message: " The required field StartDateTime is missing from the input structure. (rsMissingElement)". Do you think it's a bug or is there something which I'm doing wrong Tero Kruth ...Show All

• .NET Development Application Blocks

  What are application Blocks and how are they used in data drivien applications , can someone send me some links on this topic...Thanks This should get you started: Enterprise Library for .NET Framework 1.1 http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnpag2/html/entlib.asp Note that although the title says 1.1, the link also contains a download for .NET 2.0. The general idea is that these are classes that are wrappers around common .NET functionality. The link above has quite a bit of information, so I won't go into any more detail here. If you have specific questions not addressed by this reference and the other sites it links to, please post again with more details. Thanks, Sarah ...Show All

• Visual Studio Platform SDK (R2) & MSDN Library for Visual Studio 2005

  Platform SDK (R2) & MSDN Library for Visual Studio 2005 These are two different things right .. I use the SDK all the time but only because it has all the fun API stuff in it. Doesn't all the stuff in the SDK come in the MSDN Library - np ahmedilyas wrote: of course it will, its the documentation :-) Of course it's documentation. But then, why do I need two large docs that do the same thing. Because that information is in both the SDK and the Library - np ...Show All

• .NET Development Querystring

  Hi all i have a html table and every cell has a unique id.i'm trying to post the ids to another file and store the ids in database.here's the codes. < div >< table border ="1" cellpadding ="0" cellspacing ="1"> < tr > < td id ="0,0" style ="width: 35px; height: 35px" onclick =" <%Request.Querystring("id")%> " ; > when i run these codes, here's the error. CS0103: The name 'request' does not exist in the current context. after that i have changed the code like that. onclick =" <%=System.Web.HttpContext.Current.Request.Querystring("id")%> " ; it says CS0117: 'System.Web.HttpReq ...Show All

• Visual C++ Dialog Box Problem..

  Hi forum, I am doing a dialog based application in VC++ using MFC. Here i am creating 3 dialog boxes. when i execute the program, main dialog box opens(MAIN DIALOG) and when i click the button in main dialog box ,sub dialog box opens(FIRST SUB DIALOG) and again when i pressed a button in sub dialog box, another sub dialog box get opens(SECOND SUB DIALOG). Here my problem is i don't know how to close the FIRST SUB DIALOG box when the SECOND SUB DIALOG box is displayed, keeping the MAIN DIALOG box as it is. Anybody Please tell me the solution for my problem. Thanks in Advance. Your execution flow as following Main Dailog ->Child Dialog 1 -> Child Dialog 2 You are invoking Child dialog 2 from C ...Show All

• Visual Basic How to copy image from google map??

  Hello, I have a program in vb.net.This program makes some line charts using a database contains longtitude and latitude.I use zedgraph control for these charts. i don't want to have an empty(white) image behind the line charts(background). So i would like to to find the correct location from google maps,according to longtitude and latitude from my database and copy the image to my program. Sorry for my bad English Thank you, L@L You'll need to tie in to the Google maps API: API: http://www.google.com/apis/maps/ Docs: http://www.google.com/apis/maps/documentation/ FAQ: http://www.google.com/apis/maps/faq.html ...Show All

• Visual Studio Express Editions What's the square root code in vb 2005?

  Hi Friends I am really new in visual Basic, I knew that the square root code in vb 6 was sqr but in vb 2005, it doesn't work Help, Please Thanks very much.................. There's lot's of difference. Microsoft.VisualBasic.VBMath handles old VB6 forms such as variant datatypes and err. I wouldn't use it. It's for supporting VB6 code. ...Show All

• Visual Studio Team System Code Analysis in Team Build giving error: No Rules Selected

  I've got a Team Build project setup with the <RunCodeAnalysis> set to Always. However, it is giving me an error CA0051: No Rules were selected. How do I inform Team Build which rules to use Do I have to specify this in the build project file I have Code Analysis Rules setup for the Check-In policy in Source Control, I guess I had assumed/hoped it would pull them from there. If I do have to set them up in the proj file for the Team Build, is there a sample somewhere I can look at You are probably right. When I was having the error message the first thing I did was change it to Default, and then I think I noticed that a couple of my projects only had Code Analysis turned on and rules selected for th ...Show All

• SQL Server SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog Jamie, The article was interesting. Since the ROLLBACK TRANSACTION runs after a successful INSERTion of data into the TestTable I would not expect the data in the table to be rolled back! I think that behaviour is non-intuitive and SSIS transaction support needs to be clarifed before I can rely on it. "Here was me thin ...Show All