Tonny Steen's Q&A profile

• Visual C# How to add new data source?

  When I want to choose the connecting "data provider", I see these "SQL Server data provider, Oracle data provider, ODBC data provider" in all time. I want to add a new data provider. I guess that I should add the my new data provider's ( Npgsql ) dll file to somewhere. But to where I couldn't find the file that I must add my dll file to there. To sum up, I want to add a connection on the right menu whit using mouse. I want to add Npgsql connection. But there are some other "data provider". So I can not select my data provider which is Npgsql.dll. Where shoul I add my dll file to ...Show All

• SQL Server SSIS package runs in Development Studio but not as a job

  When I run a package I created in the development Studio it runs fine but if I create a job and run it I get an error "The AcquireConnection method call to the connection manager "ODS" failed with error code 0xC0202009" I have the package setup to use a XML config file and it works fine on all the other packages but this one will not work. I am and if I go in and edit the connection and click on save my password then test connection that works and so does the package. But if I do not save the password and try to use what is stored in the XML config file I get that error. Here is my config file: < xml version="1.0" > <DTSConfiguration> <DTSConfigurationHeading> ...Show All

• Visual C++ Event Confusion!!

  Hi all, I'm pretty new to the world of VC++ programming and I'm trying to implement a mousemove event on a picture box on a dialog. I can get the MouseMove event to fire if I add a message map etc to the dialog cpp file and header, but when I add a picture box, there doesn't appear to be a class file to add any code to for the MouseMove event. I'm a little confused, if the code goes in the Dialog cpp and header how do I tell it that it's the picture box I want the event to fire on and not the dialog box Please someone help, I'm totally confused. Cheers Pete Right-click in the picturebox and assign inique resource ID for it. For exampe, IDC_PICTURE instead of default IDC_STATIC. If you don't have dialog cl ...Show All

• Visual Basic Case Usage

  I am pretty much a noob programmer, but I'm getting the hold of visual basic pretty much. But in one of my programming attempts something is messed up, because as far as I know my code is good... Take this code: If you would use a couple of NumericUpDown controls it would solve all of your problems....you would not have to worry about upper and lower bounds because you can set the limits of the control...you would not have to worry about errouneous entries...such as alpha characters etc....You also would not have to worry about your implicit conversions from string to integer....You should always use option strict ON...You also need to understand the select case statement...it finds the first true case and then executes the code within t ...Show All

• Windows Forms datgridview problem

  not able to delete or update... adding rows is fine Private Sub updatedata( ByVal ds As db1DataSet) OleDbConnection1.Open() Dim addedrows As System.Data.DataSet Dim deletedrows As System.Data.DataSet Dim updatedrows As System.Data.DataSet updatedrows = ds.GetChanges(System.Data.DataRowState.Modified) addedrows = ds.GetChanges(System.Data.DataRowState.Added) deletedrows = ds.GetChanges(System.Data.DataRowState.Deleted) OleDbDataAdapter1.Update(updatedrows) OleDbDataAdapter1.Update(addedrows) OleDbDataAdapter1.Update(deletedrows) End Sub ...Show All

• SQL Server Master and SubReports

  Hi All, I am new to Rs2005. I have 4 seperate reports, r1, r2, r3, r4,.....etc. I want these reports to be called in sequence in a Master report. I want to make all 4 reports 1 big report. Can this be done, and if so can somebody please point me in the correct direction. Many Thanks in advance. Kenny   Hi, It is possible to have 1 master report that contains multiple sub reports. Although, it is better to have 1 report with all the sub parts in it (so no separate reports) by using multiple datasets. This is easier to maintain and is better for performance. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Windows Search Technologies Vista 64 Search preview pane only shows icon

  In Vista 64 I only see an icon of the item in the preview pane. If it is an email I see an envelope or a Word Document you see a Word icon. Agent86oz, I think I know what the problem is here. Please click on "Views" on the toolbar in the search window. Once there, move the slider to "details." This should reveal more information about each search result. Paul Nystrom - MSFT ...Show All

• SQL Server transform Active X script to what?

  HI I'm totally new to integration services, I was savy with DTS but now having been told to get on with it in SQL 2005 I'm a bit stuck. I've got an ActiveX task which basically does the following:- Function Main() DTSDestination("Title") = DTSSource("Title") DTSDestination("Surname") = DTSSource("LastName") DTSDestination("FirstName") = DTSSource("FirstName") DTSDestination("OtherNames") = DTSSource("PersonCode") IF (IsNull( DTSSource("LastName") ) ) and (IsNull( DTSSource("FirstName") ) ) THEN IF Not (IsNull( DTSSource("PersonCode") ) ) then DTSDestination("Surname") = DTSSource("PersonCode") El ...Show All

• SQL Server Establishing connection to SQL 2005 Server Express

  Using localhost (127.0.0.1) an error occurred while establishing a connection to SQL Server 2005. Error message - An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (.Net SqlClient Data Provider) Error Number: 10061 Event Source: MSSQLServer Message text: Cannot connect to 127.0.0.1. Any ideas Thank you! Thank You! This is most helpfull. I won't say how much time I spent trying to reconnect to my server after upgra ...Show All

• Visual Studio Tools for Office Public Folder Tasks

  I have written code in vb .net that uses outlook.taskitem. I create my body part using my data which is stored in a string. When using outlook 98 the formatting is fine in the body of the task created in the public folder, but when I upgrade to Oulook 2003, the body of the task also shows the formatting i.e. {\rtf1\ansi etc. What is the best way to overcome this Can you show how TO paste document in the message.body e.g Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") ' Create the message. Set objOutlookMsg = objOutlook.CreateItem(olMailItem) Dim objApplication As Word.Application Dim objWord As Word.D ...Show All

• Visual Studio 2008 (Pre-release) Setting an XElement's value

  In section 2.7.3 of the XLinq Overview document of the May CTP release, a method named ReplaceContent is discussed for the purpose of updating an XElement's value. No where does it mention setting an element's value via the XElement's Value property. Is this a no-no It does work. Here is a code sample: XElement auto = new XElement ( "Automobile" , new XElement ( "Make" , "Ford" ), new XElement ( "Model" , "Mustang" ), new XElement ( "Year" , "2004" )); Console .WriteLine(auto); auto.Element( "Year" ).Value = "2006" ; Console .WriteLine(auto); And here are the results: <Automobile> <M ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dream Build Play - partner in crime

  I'm still hard at work on a new game I'm working on, but it's more for fun than anything I would submit for a contest.  But I really want to enter the dream, build, play contest too, I just don't think I'll have the time to do it all on my own. Does anyone out there want to partner up   I'm no programming guru, but I've got a few skillz.  I've been messing with XNA since beta 1, I got one (and a half) xna game(s) under my belt, and I'd say my biggest assets are creativity, thinking outside the box, analytical problem solving, writing, story, plot, characters, and high fives (not necessarily in that order) ...only reply if you plan on winning!  Art is no ...Show All

• SQL Server SQLCMD sometimes fails to connect

  Hi, I have a set of .sql scripts that I use to create a database with. Some of the scripts are quite large as they are made up of concatinating all my individual stored procedure .sql files. I run all the scripts files from a .bat file using SQLCMD to execute the .sql files. I have found that just recently I often get SQLCMD failing to connect as the specified user half through the batch. It seems to be linked to the size of .sql file it had previously run. The error I get is: Msg 4060, Level 11, State 1, Server MYSERVER, Line 1 Cannot open database "test" requested by the login. The login failed. Msg 18456, Level 14, State 1, Server MYSERVER Line 1 Login failed for user 'sa'. If I run the individual .sql files ...Show All

• Visual Studio Push report data

  Hi, As I am trying to create a crystal report for my app., I want to show the data in my report with the code below, and the report appears blank with no errors. Can anybody help me out here. I tried following the business objects website and I could not get it to work, please help. Dim rptAdpt As New OleDbDataAdapter( "SELECT * FROM Booking" , DBCon) Dim dsUserBook As New DataSet Dim showRpt As New rptBooking Try DBCon.ConnectionString = csWBoard DBCon.Open() rptAdpt.SelectCommand = New OleDbCommand( "SELECT User.fullName, Booking.bookingType, Booking.startDate, " & _ "Booking.startTime, Booking.endDate, Booking.endTime, Booking.venueName, " & _ "Booking.userID FROM [Use ...Show All

• Visual Basic Saving ListViewItemCollection

  Connection.Open() Dim cmd As New OleDbCommand cmd.CommandText = "INSERT INTO PANELDETAIL (PanelID,PanelName,ExamName) VALUES (@PanelID,@PanelName,@ExamName)" cmd.Parameters.AddWithValue("@PanelID", tboxID.Text) cmd.Parameters.AddWithValue("@PanelName", tboxName.Text) cmd.Parameters.AddWithValue("@ExamName", lviewIncluded.Text) cmd.Connection = Connection cmd.ExecuteNonQuery() Connection.Close() Basically, this code just inserted a certain record on my database...All seems fine but the one with the question mark, I don't know how to insert but I am certain that it's wrong.I just want to ask how can I ...Show All