bdc604's Q&A profile

• SQL Server Win 2003 x64 - SSIS error Importing xls and access data

  I am having a problem importing data from xls and access into my SQL2005 DB using SSIS . Would appreciate any help in getting this resolved.   Environment: Xeon 64 bit processor machine/Win 2003 64 bit (x64)/SQL 2005 64 bit   Some of the resources that I have dug up so far have pointed to Jet Engine SP8 and WOW64.   A search on the box shows this: C:\Windows\SysWOW64\Msjet40.dll – File version is 4.0.9025.0 Not sure what is missing. The following is the error from the import from xls. The one from access is very similar. ======================================================= ...Show All

• Visual Basic FIleOpen Dialog - fileopendialog.showdialog() - Change default view from List to Details

  In my app a user can mouse to File Menu - Open. The fileopendialog.showdialog() has default view of ListView. The user is alway going to have to sort the file list by Date in descending order in order to open the most recent file stored in the network location. How can I make the FileOpenDialog display in Detail View by default and not List View. Thanks, MIke Code Sample dlgOpenFile.InitialDirectory = sDefaultDir dlgOpenFile.FilterIndex = 0 dlgOpenFile.Filter = "All Files|*.*" dlgOpenFile.Title = "Open PO File" If dlgOpenFile.ShowDialog() = Windows.Forms.DialogResult.OK Then 'other ...Show All

• .NET Development TableAdapter Update problem

  Hello, i have problem in my application. I create dataset with single table. In MainForm i have 2 texboxes and update button. This is code for update button: [CODE] Klient klient = new Klient(); klient.ShowDialog(); KlientDataSet dataSet = new KlientDataSet(); Serwis.KlientDataSet.KlienciRow klientRow = dataSet.Klienci.NewKlienciRow(); klientRow[0] = Guid.NewGuid(); klientRow[1] = klient.Imie; klientRow[2] = klient.Nazwisko; dataSet.Klienci.AddKlienciRow( klientRow ); int result = this.klienciTableAdapter1.Update( dataSet.Klienci ); [/CODE] I got 1 in result variable so i think that database was updated. No my dat ...Show All

• Visual Studio 2008 (Pre-release) How to customize the control DocumentViewer's Find function ? waiting...

  The DocumetnViewer have the Find method and FindCommand to invoke the Find Dialog, but I needn't the Find Dialog, I like the full control for the Find , invoking the find prev and find next command without the Find Dialog. How to do this Thanks Beam ...Show All

• Visual Studio Team System When does TeamBuild get the BuildTypes?

  When I start a TeamBuild going for a build type, I get asked where to get put the code, but what process / Target actually gets the BuildType folder, or is this part done outside of MSBuild i can see that CoreGet gets the source tree but this is some time after the BuildType if made availabe. Thanks for your help Graham Just to add to what Anu said here, the build agent running part of TeamBuild service pulls the entire build type folder (not just TfsBuild.proj) to <BuildDir>\<TeamProjectName>\<BuildTypeName>\BuildType folder before starting msbuild process.  ...Show All

• .NET Development Timeouts

  A Treeview is used to select the record to be displayed. On clicking a node a record is displayed. It is possible to click 9 nodes & get the record displayed but the 10th bombs out with a TimeOut message. "Error. System.Data Timeout expired....." On restarting VB (2003) clicking the record causing the bomb is displayed correctly so it is not an issue with that record. I have VERY carefully checked that every "cnn.open" is correctly matched with a "cnn.close" I have also stepped through the code line by line in the debugger and the "Close"s are executed correctly. A record consists of ...Show All

• SQL Server IIS 6 MMC problem with ReportServer and ASP.NET configuration

  Hello, I had a working Report server till I did the following: - Go to IIS 6 MMC - Display Reportserver vs properties - click on the ASP.NET tab (2.0 50727) - click on the "Edit Configuration" button - Look at the config, do not change nothing - Click OK This has kill the Report server, it is now giving an error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object. Just to see, I did the exact same thing on another test machine and it did screw up the report server a ...Show All

• SQL Server Dynamic T-SQL steatment

  How can i build a T-SQL statement dynamically Vivek S Do you mean within SSIS You should use an expression: http://www.google.co.uk/search hl=en&q=ssis+expressions&meta = If you mean to be used in (e.g.) a sproc then you're on the wrong forum. Try the T-SQL forum. -Jamie ...Show All

• Visual C++ disappearing CPropertyPage's

  I have a VC++ MFC application in VS 2005. In this application I use CPropertySheet's in several locations. The program works fine for a while, but at some point the CPropertySheet's stop working, in such a way that when I click on a CPropertyPage tab, the tab for that sheet disappears completely or the controls on that CPropertyPage are all invisible. I'm guessing that I'm running out of resources, handles, memory, etc. Can somebody advise me on what to look for in the way of resources or memory, so that I can circumvent this problem Are there any utilities that would be particularly helpful in this regard ...Show All

• Windows Forms filtering music files e.g wma mp3?

  My filter for the openfile dialog is this... ("MP3-Files|*.mp3|*.wma|WMA-Files") It only finds/opens mp3's what have I done wrong Hi there, Your filter, with respect to *.wma files, is the wrong way around. If you use your filter as it stands, when you try and filter by Windows Media Audio files it doesn't show anything as the filter pattern it's looking for is "WMA-Files" instead of the .wma extension. If you change you filter you will be able to filter by .wma files successfully. For example, in C# you would do something like: OpenFileDialog findMusicFiles = new OpenFileDi ...Show All

• .NET Development DataTable internal index is corrupted ... Is exist an reason?

  Hello people, how are you I'm in front of a strange error. I have a data form, that show and manage the data by a BindingSource control. I hava a dataGridView and individuals controls like textbox to edit them. It's work fine at the begin , but after some adds, removes or updates, the .Net retrives me the follow exception: "DataTable internal index is corrupted: '5'" It's very borried.... it's an ilogical error.... Does anybody have some tip Thank you. Andre B. Did you ever find a solution to this problem I am having a similar exception and have been stumped.... The exception is being thrown while trying to ...Show All

• Visual C++ dont understand forloop

  #include <iostream> using namespace std; // So the program can see cout and endl int main() { // The loop goes while x < 10, and x increases by one every loop for ( int x = 0; x < 10; x++ ) { // Keep in mind that the loop condition checks // the conditional statement before it loops again. // consequently, when x equals 10 the loop breaks. // x is updated before the condition is checked. cout<< x <<endl; } cin.get(); } after i compile why it will show 0,1,2,..... 9 x++ doesnt mean oledi x = x + 1 therefore cout<<x<<endl should be 1,2.... correct me if i wrong. thanks in advance. ...Show All

• Visual Basic TableAdapter update unchanged record cause Concurrency Violation

  I found that concurrency violation would occur if updating the database using table adapter when the actual record does not have any change. Seems like my DataGridView marked the row dirty. TableAdapter.Update would result in concurrency violation because zero record was modified. Seems like TableAdapter did not verify there are actual changes in the record before sending the update command. Bug I've found that if you do an update on a table adapter with a record that has DBnulls in required fields, the update looks like it works, the underlying data source is updated (albeit with some bad field values), ...Show All

• Software Development for Windows Vista Workflow hangs after CallExternalMethod on second instance

  Using WF Beta 2: I created a state machine workflow with several CallExternalMethod in its event handlers. When I start an instance and step through the states all works fine and the workflow completes. When I create a second instance of the workflow, it hangs on the first CallExternalMethod it encounters. When I do some loggin I see that it does not enter the code of the MethodInvoking method.It does enter this code in the first instance, not in the second. The activity prior to this CallExternalMethod is the last shape it completes. Anybody got an idea Sorry to have bothered ever ...Show All

• Visual C# What are some things to remember when drawing in Window Forms?

  Hi all, I'm a beginner developer. I'm writing an application and draw many object like as Ellipse: private void timeout(float x, float y, float k, float z) { Graphics Cerchio; Pen MyColor = new Pen(Color.Red); Cerchio = this.CreateGraphics(); Cerchio.FillEllipse(new SolidBrush(Color.Red), x, y, k, z); Cerchio.Dispose(); } And I draw a timer countdown like this: private void EggTimerForm_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { Point p = new Point(270, 400); Graphics g = e.Graphics; g.DrawString( ConvertToTime(StartTime), ClockFont, Brushes.Red, p, new StringFormat() ); ...Show All