Lars Andreas Ek's Q&A profile

• SQL Server (re)using serviced component in SQL CLR

  Hello guys, I am desperately trying to get some code running for reusing an existing EnterpriseService object (server activation) from SQL 2005. I tried the sp_oa* approach ... it fails finally when calling methods or properties with "The RPC Server is unavailable". After that I switched over to using SQL CLR procedures with the same success level ;). Approach 1: I do have the ProgID / ClassID. When I run Type.GetTypeFromProgID then I get back an object "System.___ComObject" ... Unfortunately I cannot (explicit) cast it to a particular interface (will result in a NULL exception) nor can I apply reflection (GetConstructor, GetMethod). Approach 2: Use Activator.CreateInstance(...) and alike. The creation fails with &qu ...Show All

• Windows Live Developer Forums Adding Layers to the Map

  Hi, I am in a process of developing a website using virtual earth that displays data from my database on Virtual earth Map. From the VE SDK i learnt that this can be achieved by Layers. But didnt not really understand how to implement it. Could some one help me in doing the same or provide a sample code that will help me. Email: madhu.gandhi@patni.com . Thanks and regards, Madhu. Hi, I want to develop a section on my website divided into (about 6) neighborhoods that will cover about 40 miles using MS Virtual Earth map. I want to add layers to display local restuarants, schools, grocery stores, golf courses, hotels, etc. Two questions: I have ideas and where can I look to find a programmer to help me make t ...Show All

• Windows Forms Dialog results

  Having come from Delphi I am trying to figure out how to use dialog boxes in VS C#. I have created a form MySearchForm containing a listBox but this is a private field. In the main form I wish to call the dialog as such MySearchForm searchForm = new My SearchFoodForm() ; searchForm.listBox.Items = // but this is not exposed as it is private if {searchForm.ShowDialog() = DialogResult .OK) { index = searchForm.listBox.SelectedIndex; } How do I expose the listbox, or am I going about thing the wrong way Seems a bit long winded. One way I got it working was to simple change listBox from "private" to "public" and then I had access to it from the calling form. ...Show All

• SQL Server Setting column value in script task

  This should be simple. I have a package which reads a flat file into a data flow. One of the columns (RefNumber) needs to be parsed and split into 2 distinct values. So in the dataflow I add the 2 new columns (ID1 & ID2) in a derived column transformation, and then call a script task. In the script task, RefNumber is readonly, ID1 & ID2 are readwrite. Here's a cut-down version of the script task with the boring stuff removed; Public Overrides Sub Parser_ProcessInputRow(ByVal Row As ParserBuffer) Dim narrative As String = Row.RefNumber.Trim() If (String.IsNullOrEmpty(narrative)) Then Return End If 'lots of stuff happening here not relevant to the question so snipped If ((IsNumeric(narrative)) And (narrati ...Show All

• .NET Development Input string was not in a correct format

  I get this strange error. I have Int field in my table, and I read it this way: cmd.Parameters.Add( "@godina" , System.Data. SqlDbType .Int, 4).Value = plo.godina; but, when I try to execute, I get this error Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format. Source Error: Line 283: plo.model_plovila = cmd.Parameters["@model_plovila"].Value.ToString(); Line 284: plo.brodogradiliste = cmd.Parameters["@brodogra ...Show All

• Visual FoxPro "When" firing after "Valid"

  Hi all; I am temporarily using an older SPR in VFP 9 as it is. I have had some problems with the code, and after using the debugger I have learned that in a "Get, when, valid" command, the "When" fires AFTER the "Valid". Anyone had experienced a simillar probem Any ideas why Thanks, Aleniko Cetin; Correction. Problem still there but I think it is caused by the get command. Run this code in VFP9 and in Foxpro2.6 (If you still got one...) and see how the 'When' clause runs again after the valid in VFP9. This causes the final value to be different when run in VFP9. I have simplified the original code to the code bellow. Thanks for your input. SE ...Show All

• SQL Server Programming in ssis

  Hi.. I am working on sql server integration services..New to this topic...I want to transfer data from flat file to sql database by doing it programatically.Creating source,destination and transform adapters my basic question is should the source,transform and destination adapter be bulid for each file i am trying to transfer. What is the advantage of this doing it this way. Would anyone let me know about this.. Thanks The answer to your question will depend on your application's requirements, but in principle, if you are using the same metadata throughout the data flow, you can use a for-each loop and dynamically update the connection string of the flat file connection manager, using the p ...Show All

• Visual Studio Team System Timeout errors while running Unit tests in Load Test

  I’m running a unit testing script in Load Test and after running for about 9 minutes with 250 users, I get a bunch of test errors. The error message is ‘Exceeded specified execution timeout period of '300' seconds on agent’. My unit testing scripts has calls to Web services. Does anyone know how to fix this issue If I run the same Web services calls as a Web test, I don’t get these errors. Thanks! This means that an individual unit test is taking longer than the test timeout setting (which is 300 seconds by default). You can increase this on the Timeouts tab in the Test Run Configuration (from the menu choose "Test" and "Edit Test Run Configurations", choose your config to edit, then ...Show All

• .NET Development ADO Date question

  Hi Guys I am trying to find out if any records exist for a particular day or dates from a MS Access DB using .net. In VBA i had to format the date so that it would be mm/dd/yy. If i try this using ADO and .net it doesn't seem to work. Dim rst As New ADODB.Recordset rst.Open( "Select Count(*) From DutyTimes Where DutyDate=#" & dteDutyDate & "#" , ConnString, ADODB.CursorTypeEnum.adOpenKeyset) Using this code if i search for a 21/11/2006 then it works fine but if i search for a date 09/08/2006 then it does not find any records although they do exist. I have tried formatting the data to no avail. Any help would be great Thanks Steve You need to remember that dates are usually ...Show All

• .NET Development newbie, tcplistener/tcpclient

  Hello everybody, I am trying to use my friend's computer as a server and my computer as a clien. I want to develop a program about that. But I dont know how to do it. I think I must use tcplistener, tcpclient and some events for this application. I am using C#. And i found two examples. They are: for tcplistener http://msdn2.microsoft.com/en-us/library/system.net.sockets.tcplistener.aspx and for tcpclient http://msdn2.microsoft.com/en-us/library/system.net.sockets.tcpclient.aspx TcpListener is ok. But TcpClient needs a server's name.. TcpClient client = new TcpClient(server, port); // you can find this line in the second link above.. How can i create a server And it is a string How can program find the server's ip from a name Can you plea ...Show All

• Windows Forms How to bind the textbox in windows forms with the column in dataset?

  Hi I have manualy created a dataset and datatable and created 2 colums. My question is How do I bind a control (textbox or control) in the windows form with colum in the datatable(manualy created) Advance thanks Hi Luis I have struggling a lot to get output of the dataset(from database) to save as a xml file with Root node and child node, sibling and so on.(I am getting the output xml with all elements under one root node as it from the single table of the database). So tried different methods to get the needed structure.(this thread is one of them). Finaly I got two option to try(please check below link) . So, could you give me your opinion from the two link below or somthing else ,which is the best to implement as I am considering ...Show All

• Smart Device Development Querying SQL Server CE 3.0 with Visual Studio

  Hey all! I'm comming across fustrations with the sql querying tool that is built into visual studio 2005. I'm trying to query a Sql Server CE 3.0 database, and have dropped a few tables onto the diagram pane, and select my columns and everything queries fine. However, if I change my join between the two tables to a Right outer join, the designer automatically slaps a '{ oj ... }' around my where clause which isn't supported by sql server ce 3.0. Anytime I remove it and try to execute my query it automatically re-adds these sumbols and displays an error to me. Is there any way I can get visual studio to stop automatically adding these sql symbols when talking to a database that doesn't support them Below is the query it produce ...Show All

• Software Development for Windows Vista What is the difference between WCF's one way operation and .NET 2.0 asynchronous web service call?

  The one way operation is really new to me. Anyway, I don't see the differences from asynchronous web service call in .NET 2.0. 1. If i declare an [OperationContract] method, make it one way, this should be similar to making a regular void web service and then from the client, I call the asyncronous method in the proxy and then in the asyncronous callback I simply leave it blank. What are the differences 2. If i declare an [OperationContract] method, make it one way and then I declare a CallbackContract to send the message back to the client. What is the difference between this scenario and calling an asyncronous method in the web service proxy that returns output 3. Again, for one way methods, because the client does not wait for ...Show All

• Visual C++ more Textboxes saving to a file

  I have to do a singly linked list,with windows forms application, i have till now this: I have in the main Form1 some buttons, when i press the first button i open a new form2 and in this one i have 2 textboxes in which i fill the data (name and age) , i have problem saving the text from the 2 textboxes to a .txt file, and when i put some other data in the textboxes i want my old records that are in to be still in it. Example: name: prima //the first 2 records age: 18 name: prima2 // the second ones age 188 yes, you are right, i was spending 5h but not on this problem, and i finally understand where things have to go, it's late in the night on my side so i gonna see tomorow if things are working ok. Tha ...Show All

• SQL Server Management Studio Express installing error in Vista

  At installation Management Studio Express in Vista there is a mistake with what that number. Management Studio it is not supported in Vista Same error trying to install on Vista Ultimate 64 bit. Warning Icon The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506. [OK] Installation is rolled back. The Event Viewer shows that the MsiInstaller errored with Event ID of 10005. Tried it twice with the same result...   Finally I enabled the Administrator Account and logged in as Administrator. Then I ran the .msi successfully. ...Show All