alexbot's Q&A profile

• .NET Development Correct Solution to Max Cursors Exceeded in Oracle

  I've noticed that many sites are telling developers to increase the Max Cursor Length in Oracle to correct for this error. All this does is allow for a greater number of problems. The reason for this error is due to the Oracle Data Reader you are using in your code. Many Developers think that if they close a connection, the Reader Closes to. That is not correct. In a nutshell, even though you have disposed of your Reader Object, unless you specifically close it, it will remain an Open Cursor in Oracle. Example Code: strSQL = "Oracle Sql Statement Here..." cnOracle = New System.Data.OracleClient.OracleConnection(strCNOracle) cmdOracle = New System.Data.OracleClient.OracleCommand(strSQL, cnOracle) c ...Show All

• Visual Studio 2008 (Pre-release) PeerChannel throttling controls?

  How does one properly throttle a PeerNet network when messages are pouring in faster than the receiving nodes can process them I'm trying to prove whether or not PeerChannel would make a good foundation for publish-subscribe style messaging that is reliable and robust enough for an enterprise. My initial testing has been very positive. PeerChannel is looking to be super-reliable so far. Sending 10,000 messages in a 5-node configuration: 0 message loss, 2,500 msgs/min to 4,000 msgs/min per receiving node Sending 100,000 messages in a 5-node configuration: 0 message loss, 2,500 msgs/min to 4,000 msgs/min per receiving node Send 1,000,000 messages in a 20-node configuration Fine for first 2 hours (about 175,000 messages) then a ...Show All

• Visual Basic Dave299, dynamic code then? Possible or not do you think? I've been playing with the output too.>>

  Hi. I want to build a program which can add its own buttons. However, I only ended up adding one button, and I don't know why. Here's the code: Dim i As Integer Dim ButtonMade As New Button Private Sub Button1_Click_2(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click i += 1 ButtonMade.Text = i.ToString ButtonMade.Left += 100 AddHandler ButtonMade.Click, New System.EventHandler(AddressOf ButtonMade_Click) Me.Controls.Add(ButtonMade) End Sub Private Sub ButtonMade_Click(ByVal sender As Object, ByVal e As System.EventArgs) MessageBox.Show("Hello") End Sub I couldn't figure out why it just keeps on adding just one button, and when I try to add another one, it just transports the previously made ...Show All

• Visual Studio Express Editions Progressbars: For Each foundFile As String In My.Computer.FileSystem.GetFiles

  With regards ahmedilyas solution below to copying various file extensions, how can I tie 2 progressbars to this code ProgressBar1 measures each file copy progress ProgressBar2 measures overall files copy progress Thanks for any help. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=832447&SiteID=1 Dim theExtentions() as String = {"*.jpg", "*.bmp"} for each currentExt as String in theExtentions    for each currentFile as String in My.Computer.FileSystem.GetFiles(My.Computer.FileSystem.SpecialDirectories.MyDocuments, FileIO.SearchOption.SearchAllSubDirectories, currentExt)       'do your thing    next next im surprised i ...Show All

• Visual Studio Express Editions DLL and LIB?

  I'm curious as to how I can have my project compile and produce both a DLL and a LIB file. I have seen it done before (such as SDL does so) and I have been unsuccessful in doing it myself (I have been only successful in building a DLL or a LIB, not both). Any help is appreciated; thanks! If you don't export anything, either through __declspec(dllexport) or through a .def file, your DLL won't have any entrypoints for functions that can be called by a client. Note that you can dllexport a class, all its methods will become available. I can't comment on g++, it seems highly unlikely it would export every single non-static function. There's probably some kind of .def style file too. ...Show All

• Visual Studio Two datasources, one report?

  Assume I have a single report. Assume I programatically add two datasources to the report using LocalReport.DataSources.Add("DatasourceName", DataTable) Assume the report only has two textboxes - I want to grab the first name from the first datasource and place it in the first textbox and I want to grab the last name from the second datasource and place it in the 2nd text box. =Field1.Value <-- using datasource one. =Field1.Value <-- using datasource two. Obviously, those expressions won't work. What expressions would work Does there have to be a subreport to do this Is there a way to get something other than the first Right now I have =Fields!TOGAC_LOT_NO.Value giving ...Show All

• Visual C# SteValue method does not work.

  It is very frustrating to find out after hours of development that a method used so widely does not work as intended. Is it supposed to modify values in a DataRow or not What is the meaning of .SetValue semantically I find that if I have DataRow[] dtRows and want to modify some values in the fields the only way to do it is to use foreach (DataRow row in dtRows) row[0] = someValue; If I try: dtRows[0].ItemArray.SetValue (someValue, 0); it won't work. it compiles, execution takes place but the values remain unchanged. Am I missing something Thanks. The problem is the 0 in setvalue. The value needs to increment, for example: dtRows[0].ItemArray.SetValue ("Test1", 0); dtRows[0].ItemArray.SetValue ...Show All

• Visual Basic Transferring data from FoxPro dbf to Sql

  Dear All, I need all your help urgently. I wanted to write a small piece of vb code to sychronize a few FoxPro dbf tables to SQL tables that having the same structure or at least a few fields that i selected. I had tried a code which I found on the net that running row by row  and column by column to update the SQL tables but this code is too slow. In my dbf table it contains around 3000 records at least. Please help. Thanks in advance. Regards, Weoi Li ps: Happy 2006!!! I use code like the following to transfer from FoxPro to Access. This code may be dependent on the Jet engine but there should be a similar method for transfering to SQl Server. Public Sub Import() Dim ODBCDSN As String = "" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help with Managed DirectPlay Lobby Client/Launcher

  Can someone help me with the following managed DirectPlay code for lobby launching Age of Empires II Microsoft::DirectX::DirectPlay::Lobby::Client^ connection = gcnew Microsoft::DirectX::DirectPlay::Lobby::Client; Microsoft::DirectX::DirectPlay::Lobby::ConnectInformation^ ci = gcnew Microsoft::DirectX::DirectPlay::Lobby::ConnectInformation; ci->GuidApplication = *(gcnew Guid("FB69A260-5031-11d3-A2D4-006097BA6550")); ci->Flags = Microsoft::DirectX::DirectPlay::Lobby::ConnectFlags::LaunchNew; ci->UseConnectionSettings = true; ci->ConnectionSettings.PlayerName = "MeTheHost"; ci->ConnectionSettings.HostAddress = gcnew Microsoft::DirectX::DirectPlay::Address("localhost",47624); in ...Show All

• Smart Device Development Memory insufficient on Mobile 5.0 emulator

  I try to debug an application on windows mobile 5.0, however there is a low memory on the emulator. I am try to reconfigure the memory size for the emulator however the part was being disable. Please advice I try to follow the way u mention and increse the memory size. After i launch the emulator again the memory in the emulator still the same. ...Show All

• SQL Server counting result set in MDX

  Is there a way to count the number of rows in an MDX result set I would like to use this in the data source of a reporting services report If so how can this be done Does this Adventure Works sample MDX query help >> With Member [Measures].[RowCount] as Axis (1). Count , NON_EMPTY_BEHAVIOR = {[Measures].[Order Quantity]} select {[Measures].[Order Quantity], [Measures].[RowCount]} on 0, Non Empty [Product].[Product Categories].[Subcategory] on 1 from [Adventure Works] ------------------------------------------------------------------------------------------- Order Quantity RowCount Bike Racks 3,166 35 Bike Stands 249 35 ... >> ...Show All

• Visual Studio Team System Changing _VIEWSTATE in different versions breaks the test scripts

  The test scripts I created is based on the old version of the application. Everything was working well on the old version. Then a new version was promoted to the testing environment. My test scripts did not work. The error message is " KeyNotFoundExcept was unhandled by the user code ." The corresponding code is: request13Body.FormPostParameters.Add( "hidRedirectPageUrl" , this .Context[ "$HIDDEN1.hidRedirectPageUrl" ].ToString()); I guess this is because Web Test was not able to find the key "hidRedirectPageUrl". Thinking that the _ViewSate code is the only difference in the new version, I re-recorded my testing actions on the new version, get the new _ViewState code and copied the new _view ...Show All

• SQL Server How to delete rows in tables...

  I need to delete some rows in some of my tables after tranfering data from my OLTP to SQL database. Im using SQL 2000 I have tried with the following: Delete from fsalesinvoiceline Join dsalesinvoiceheader on Fsalesinvoiceline.salesid= dsalesinvoiceheader.salesid and Fsalesinvoiceline.company= dsalesinvoiceheader.company Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’ Go Delete from dsalesinvoiceheader Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’   I get the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'JOIN'   What am I doing wrong /Soren D. Jensen ...Show All

• Visual Basic Error 1904: ieframe.dll failed to register

  I have a VB.NET 2003 application that uses the Webbrowser control. When I install my application, I am now getting the following error (since installing IE7): Error 1904.Module C:\Windows\system32\ieframe.dll failed to register. HRESULT -2147220473. Contact your support personnel. Despite the error I can still use my application. Obviously though, I can't have errors like this occurring for our customers. Reza Nourai - MSFT said "One of the changes in IE7 included seperating shell and IE code out of Shdocvw.dll. The new IE-only library is IEFrame.dll..." Can anyone explain to me why the "failed to register" error is occurring and what is the best solution Uninstall IE7 ...Show All

• Visual Basic VBS Script Help

  Hi, I'm not sure if this is the correct forum or not. If not, please let me know where to post. I would like to create a script that will rename files based on a users input. So far I have a basic batch file that will do the job, but I want something that they wont have to edit. The files needing to be renamed are usually something like 06M123AB.000 where the 123 would be the only thing renamed in the folder. I would like to, if possible, let the user input the old numbers (123)  then input the new numbers (456) and have all files in the current directory renamed. I was thinking a VB Script would be better for this. Thanks for the help.           ...Show All