Thomas Israelsen's Q&A profile

• SQL Server Linked server problem

  hey, I have a sql server 2005 an I want to have a linked server to itself. I have made a linked server an gave it enough rights. When I do want to query all the tables I get the following error Msg 11001, Level 16, State 1, Line 0 TCP Provider: No such host is known. Does anybody know what the problem could bee Hey, I have found the fault. If you put "SQL Server" in the ProductName field in the window for making a linked server then it will change your driver automaticly to sql server. I had to use an OLDB rovider for SQL Server. When I changed the productname to "BLABLA" it worked perfectly. Thnak for the effort of helping me. ps the reason why i would like to use a linked server i ...Show All

• Visual Studio Express Editions about sqlconnection?

  hi gud day ppol.... i have a problem regarding sqlconnection for example dim theConnectionString as new sqlclient.sqlconnection(" what's NEXT "no idea"") thx in advance... sorry for stupid question yes...in the case of using OleDb for MS Access, you could write this one: Dim theConnectionString as New OleDb.OleDbConnection( " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = C:\mydatabase.mdb ; UserId = admin ; Password = ;") ...Show All

• Visual Studio Tools for Office MS Office Automation Question?

  Hi all, I'm using "AxWebBrowser" to display word and excel document and it works fine. However, I've got a strange problem about the AxWebBrowser doesn't display the word and excel tool bar. I tried many ways to fix it but all of them don't work. Is anyone can give me a hand about this problem. Thxs forum. The proper place to ask question about the Ax controls is the Office web components newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.web.components&lang=en&cr=US You should probably mention in what kind of environment you're embedding the control. ...Show All

• Visual Studio Express Editions Saving Data

  Hello, I have a form and I can use the data binding tool with my access DB with no problems but I cannot figure out how i save things manually, I want to save specific data to specific columns in a table, could somone point me in the right direction or post some kind of example Thanks! heres what i have so far "which doesnt work" Try Me .Validate() Me .ContractsBindingSource.EndEdit() TextBoxVat.Text = Me .InvoiceDetailsTableTableAdapter.Update( Me .db1DataSet.InvoiceDetailsTable.Address1Column) MsgBox( "update successful!" ) Catch ex As Exception MsgBox( "update failed, the data may already exist please check and try again." ) End Try ...Show All

• Windows Forms String with color

  Hi all, Anyone knows how to put some color to string output For example, I have this output in my listbox: string value1; string value2; myListbox.Items.Add(String.Format("{0} - {1}", value1, value2)); and now I want to color value1 red and value2 blue. How can I do that Idea/suggestion are very much appreciated. Regards. thanks guys, i guess there is no way i can format my strings with color. using ownerdrawn listbox is a way to do it. btw, thanks wang chi for the code. nice for my other apps. ...Show All

• SQL Server Dynamic FTP Connection

  Hello , I have a table having different ftp url,user name, passwod, port no.I want to copy the file from all the location on my server at. How can I change the connection string/ FTP location for FTP connection manager at rum time in SSIS. Thanks Not sure if anyone will see this, but the disconnect I'm having on this problem is between the script task and the FTP task. The script task is getting data from my DB, but I don't know how to pass that into the FTP task. The package level configurations don't make sense, because the values need to be populated differently each time a ForEach Container scrolls through the recordset. It looks like the "expression" in the FTP task is ...Show All

• Windows Forms What is the syntax for DataView Filtering using Child Column?

  Hi. Given 2 related tables, parent and child, how would you write DataView Filter using child column. For example, if you have Customer and Order, and you want to find customers whom made orders in April-2006 - How to write a Filter for this I know that you can list the children and then go back to get the parents of each but it seams more natural to use Filter. Thanks for your help. Hi, Thanks for your help. You are correct about the SQL. I was wondering if the same could be achieved on the client. I came across this article: http://www.intel.com/cd/ids/developer/asmo-na/eng/20137.htm page=2 in the article, they say you cand do this if you have a single relation to the ...Show All

• .NET Development determine external ip address from a windows forms application

  I've searched the forums for the answer to this but can't find a satisfactory resolution. We need to determine the external ip address (the same as if you went to www.whatismyip.com ) from our vb.net windows forms application. Any ideas Thanks Bruce Hi this is a easy way string ip = new WebClient ().DownloadString( http://www.whatismyip.com/automation/n09230945.asp ); ...Show All

• SQL Server Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All

• .NET Development .NET Compact Framework install HELP

  I am trying to install the .NET COMPACT framework on my PPC-6700 smart phone with windows mobile 5.0. When I put the .msi installer file on my phone and try to run it I get an error that says: " There is no application associated with NETCFSetupv2. Run the application first, then open this file from within the application." I can open .cab files on my phone, but for some reason I cannot open this .msi file. Could anyone please help me out Thank you you need to activesync your mobile device first, once established a connection between the PC and mobile device, run the .NET CF setup from the PC and this should install .NET CF correctly on your mobile device. ...Show All

• Smart Device Development Arabic Characters on PPC 2003 Emulator ...

  Hi, I've wrote some functions and tools for displaying arabic words on ppc device ... Now, I want to know is it possible to displaying arabic words on ppc Emulator ! I Simply copied the font that i wanted to work with it on Emulator but i just can see Squares on screen !! Is it possible ! If Yes so what's my wrong ! Regards, Hadi Hi Ahmed, As I thought , I couldnt rename Tahoma.ttf in Windows dir because it's an system file ... What to do now ! Regards, Hadi ...Show All

• .NET Development Tcp disconnection problem

  I'm writing a Client-Server model solution. I'm using TcpListener and TcpClients. I use StreamReaders and StreamWriters to communicate over the underlying sockets and I'm having some problems. I'm using ReadLine() and WriteLine(). First off, how do I know when there is a disconnection You would think there was an exception thrown, but it just blocks forever. So I have to use Thread.Abort() and this is hardly ideal. Also the TcpClient.Connected property shows true when indeed there is no connection. The problem there is two-fold. If I shutdown the server the client thinks it's still connected. Also, if I choose to close a connection myself during one of the StreamReader/StreamWriter blocking calls I must raise an exception (u ...Show All

• Visual Studio Express Editions Subform appears behind pictureBox?

  Newbie alert! :) I built a main form and set the property IsMdiContainer to true and then have a subform which works fine. I added a pictureBox to the main form but the sub forms appear behind the pictureBox. Any ideas why private void openToolStripMenuItem_Click(object sender, EventArgs e) { SubForm1 sform = new SubForm1(); sform.MdiParent = this; sform.Show(); } You shouldn't put any controls on the MDI parent form other than a tool strip and a status strip. Use the BackgroundImage property to display a picture. ...Show All

• Software Development for Windows Vista Accessing workflow instance members from WorkflowInstance (runtime event handlers)

  Hi All, Is there a way to retrieve a strongly typed reference to the actual running workflow from a WorkflowInstance instance More details: I have a runtime event handler (loaded, idled) that receives a WorkflowEventArgs parameter. In that method I would like to access some of the instance properties (DependencyProperties) of my own workflow class. The only object I have in that method is a WorkflowInstance with an InstanceId. So the question is, how can I get a MyWorkflowClass instance if I have an InstanceId Thanks in advance. I have a new sample that shows a very simple tracking service to get the current property values of a running workflow instance. The tracking service creates a profile ...Show All

• Visual C# Time of day arithmetic

  Hi. I am working with a time string that I want to be able to add a value to. If I enter a time of day as hhmm (example 2000), I would like to add a time value as hhmm (0535 + 2000 would return 0135) and return this as a string. Can someone help me with an easy way to do this please Thanks. My current routine doesn't work, but here is what I have done in sourcecode. The only part that seems to fail is the adding of hours and minutes to the time. Is there a shorter or better way to do this public static string MinSearch( string My Time, string MinConTime ) { int MinMinutes; int MinHours; string timestring= "" ; DateTime StartTime = Convert .ToDateTime(MyTime.Substring(0,2)+ ":&q ...Show All