Jump to content

All Activity

This stream auto-updates     

  1. Earlier
  2. OlmanQuesada

    rs.Properties("Unique Table")

    You should recreate a new update from scratch that reflects the changes in that table. Please take a look at this URL https://stackoverflow.com/questions/34623292/how-to-update-a-table-using-join-in-visual-studio
  3. OlmanQuesada

    References msdatasrc is already set - error CS0012

    Hello, In screenshots 3 and 4, there are two issues that have to be solved manually. 1. The first is related to MSComDlg objects. In vb6 there exist only one single dialog object with several functionalities: print dialog, color dialog, open file dialog, etc. In .Net there are specific dialog objects according to their functionality. For instance, there is a openfile dialog, print dialog, etc. The VBUC tool converts every MSComDlg object into their respective equivalences in .Net, so if you find a single MSComDlg object in your VB6 form, the upgraded form in .Net would have as many .Net dialog objects as functioanlities detected in the original application. However, for non upgraded library elements of the original MSComDlg , it will create a stub class called UpgradeStubs.AXMsComDlg_AXCommonDialog. This stub class may reference enums or types defined in the MSComDlg Activex component. To avoid the error in screen 3 there are two paths: b. Verify what are the nn-upgraded elements for the UpgradeStubs.AXMsComDlg_AXCommonDialog instance created in that form and replace them by .Net functionality. a. Include a reference to the MSComDlg object and then perform (a). 2. In regards with the second issue (screenshot 4), the error is generated because rst that is declared as object and in runtime it's created as ADORecordsetHelper (implementation of a .Net DataSet) is being cast to msdatasrc.DataSource and that casting is incorrect because msdatasrc .DataSource is an unmanaged type while ADORecordsetHelper is a .Net type. What is the datatype for cboTeileNr? I looks like it's an Activex object. Regards, OlmanQ
  4. Hello, thanks for this nice piece of Software. I've got a problem at step 2. Resolve References: This reference 831FDD16-0C5C-11D2-A9FC-0000F8754DA1 I didn't find in my .vbp-file. I've solved this with a reference to MSCOMCTL.ocx. After that every things works fine :-) But after the start of visual studio 2017 I got a problem with the references as you see in the last screenshot. Error Code: CS0012 Error Description: The type "DataSource" isn't defined in one of the referenced assemblies. Add a reference on the assembly "Interop.MSDATASRC", Version 1.0.0.0, Culture=neutral, PublicKeyToken=null" This reference is already set (see on the right side). The problem is located on the data-comboboxes. What I have to do to solve this problem? Every support is appreciated. Thanks a lot! Thomas
  5. OlmanQuesada

    Winsock not listening

    Hello Dion, Do you have a firewall that may be blocking connections attempts? You can try by implementing the winsock error event to trap error messages. My suggestion given you're now in .Net, replace the winsock by System.Net.Sockets. The communication between .Net and Interop/Activex components my be not as smoothly as expected, so using a pure .Net component could be the best option. Some guides about .Net sockets: https://docs.microsoft.com/en-us/dotnet/framework/network-programming/synchronous-client-socket-example https://docs.microsoft.com/en-us/dotnet/framework/network-programming/synchronous-server-socket-example
  6. Dion

    Winsock not listening

    FYI - it has exactly the same issue if I convert to C# (there goes that idea).
  7. Dion

    Winsock not listening

    I've just converted a smallish VB6 winsock server program to VB 2017. It's successfully converted to AxMSWinsockLib, and after the usual minor changes to code (non associated with winsock), it compiles and runs, but winsock events don't seem to trigger. Netstat shows that the port is listening and I can see attempted connections from the client (which is still VB6). The sub definition lines (as created by mobilze) are: Private Sub Socket_ConnectionRequest(ByVal eventSender As Object, ByVal eventArgs As AxMSWinsockLib.DMSWinsockControlEvents_ConnectionRequestEvent) Handles _Socket_0.ConnectionRequest Private Sub Socket_DataArrival(ByVal eventSender As Object, ByVal eventArgs As AxMSWinsockLib.DMSWinsockControlEvents_DataArrivalEvent) Handles _Socket_0.DataArrival Private Sub Socket_CloseEvent(ByVal eventSender As Object, ByVal eventArgs As EventArgs) Handles _Socket_0.CloseEvent Anyone had similar issues? Is there something obvious I'm missing? Any other ideas? Do I just rewrite to System.Net.Sockets?
  8. willvv

    Analyse Tool and 3Th Part Tools VB6

    Hi Mark, sorry about the delay with the response. Here are the answers: - You can download the assessment tool from here: https://mobilize.blob.core.windows.net/clickonce/SFX/AssessmentWizard.zip, once you get the results you can share them with us at sales@mobilize.net so we can set up a call and review them with you to suggest next steps. - Our migration tools have support for several third party libraries and support for additional libraries is added frequently. At this point we don't support the Janusgrid component but we can certainly add support for it as part of a migration project, or if you want you can add support for it yourself after the migration project (by default the migration tool will create a placeholder on the client-side which can be implemented in a very straightforward way). Regarding the target library, we use Kendo UI for Angular components, however it is possible to extend this and use any other UI library that can be used with Angular 6. I hope this answers your questions. - Will
  9. Hi, Support. So, I've two questions: 1)where I can download analyse tool for vb6 apps for WebMap? 2)In my vb6 app we use 3th part tools like Janusgrid and Aebacus, WebMap can migrate this vb6 code exists for Janusgrid or Aebacus? Thank you.
  10. OlmanQuesada

    Documentation for UpgradeHelper projects

    You can find inline documentation in the helper classes and you're also free to edit them. The recordset helper tries to infer the right command type, but when the basic clauses are not fulfilled it has to get the database schema to find if the recordset is populated by querying to a table name. Retrieving the schema has a very important impact on the performance, so in this case modifying the source code by using the exec keyword would help to reduce the performance. Regards,
  11. MichaelLotosh

    Documentation for UpgradeHelper projects

    I get expected results with or without "exec" keyword. It's just with "exec" keyword I get results 10 times faster. With "exec" keyword the code enters first "if" statement in getCommandType function and exits function right away. Without "exec" keyword the code continues to get DB schema which takes long time. Like I said before, It would be nice to have some documentation to better understand if some functions needs to be modified/removed in UpgradeHelper projects. Here is the sample code that I use to populate recordset: ADORecordSetHelper rs = new ADORecordSetHelper(""); DbConnection connCurrent = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateConnection(); rs.CursorLocation = mCursorLocation; connCurrent.ConnectionString = ConnectionString; connCurrent.Open(); DbCommand TempCommand = null; TempCommand = connCurrent.CreateCommand(); TempCommand.CommandText = "SET ANSI_WARNINGS OFF"; TempCommand.ExecuteNonQuery(); rs.Open(SQLQuery, connCurrent, mLockType); rs.ActiveConnection = null; UpgradeHelpers.DB.TransactionManager.DeEnlist(connCurrent); connCurrent.Close(); connCurrent = null; return rs;
  12. OlmanQuesada

    Documentation for UpgradeHelper projects

    Hello Michael, In my understanding, the recordset is populated by executing a stored-procedure. Could you provide us a quick sample of how the recordset is populated? If you use the "exec" keyword when executing stored procedures the results is the expected?
  13. MichaelLotosh

    Documentation for UpgradeHelper projects

    Hello, Do you have any documentation for UpgradeHelper projects? I just had an issue with ADORecordSetHelper.getCommandType function. Our project calls stored procedures without "exec" keyword. getCommandType function is trying to load db schema in order to identify CommandType. Each query loads about 10 times slower with this function. You normally don't see the difference if the form is using couple of SP calls, but on heavy DB forms the difference could be several seconds! getCommandType function even after loading DB schema still ignores SPs and assigns default "Text" type to CommandType. It would've been nice to know before that we don't need this function since it assigns "Text" type to all DB calls anyway.
  14. OlmanQuesada

    rs.getProperties().Item("Unique Table")

    Hello, ADO.Net does not provide that functionality as classic ADO or ADODB does, that’s why the VBUC generate a stub indicating that property is not supported. In order to achieve the same functionality will require changes in your migrated code. The VBUC converts classic ADO components (like the recordset) to ADO.Net components. In specific, the recordset is migrated to a helper class that inherits from the System.Data.Dataset object. This class includes methods/properties to emulate the behavior of the classic Recordset when possible, but there are some of them that cannot be emulated as ADO.Net does not provide any way to recreate them. For instance, using the <Recordset>.Properties(“Unique Table”) to indicate which table to be updated when the recordset is populated via a SQL JOIN statement. To get the functionality described above, you can use the <RecordsetHelper>, the Update/Insert/Select clauses must be provided in order to perform those operations. You can use the SQlInsertQuery, SQLUpdateQuery and SQLDeleteQuery properties of the RecordsetHelper class to indicate the Sql statement to use to execute SQL operations. As a workaround to this, Update/Insert/Delete SQL must be specified to perform those operations (here some info from Microsoft : https://docs.microsoft.com/en-us/aspnet/web-forms/overview/data-access/advanced-data-access-scenarios/updating-the-tableadapter-to-use-joins-cs)
  15. KevinKor

    rs.getProperties().Item("Unique Table")

    We populate the recordset with a join of table1 and table2. In some other place in the code, we need to update the record from table1. Without rs.Properties("Unique Table") = "table1" the recordset will update the records from both tables and not just table1. It then calls the method, getProperties, which is in the NotUpgradedHelper class.
  16. Arvind

    OWC Charts Conversion - From Classic ASP to ASP.NET

    Hi Alberto, This really makes me feel how silly I was. Yes, it did work! Thanks your help! Since the DLL was already under a subfolder of the selected root, I thought it automatically finds the DLL. Lesson learnt! Thanks, Arvind MR
  17. AlbertoEspinoza

    OWC Charts Conversion - From Classic ASP to ASP.NET

    Hello, For this specific scenario, the VBUC was unable to resolve the reference to the dll containing the class OWC.Chart. In these circumstances, you can right click over the unresolved createobject in that list, and choose the "Set Reference manually" to indicate the location of the dll containing that class. Please let me know if that works for you. Regards,
  18. Hello, I recently bought the Mobilize VBUC to convert from Classic ASP to ASP.NET for one of my website. While conversion, the tool is unable to resolve the references for OWC Charts. I am sure there is a DLL file (msowc.dll) in our code path, with which the tool can resolve the reference. But it fails to resolve the same. Please find the error below: Could you please let me know if Mobilize does not recognizes OWC Charts? or Can you help to fix this issue? Note: My application uses Chart depictions, which uses OWC. Thanks, Arvind MR
  19. AlbertoEspinoza

    rs.getProperties().Item("Unique Table")

    Hello Kevin, Could you share a sample code in VB6 where that is happening, please?
  20. Hello, VBUC didn't convert the code: rs.getProperties().Item("Unique Table").setValue("tableColumnName"); Do you have any recommendations on how to handle it?
  21. KevinKor

    rs.Properties("Unique Table")

    How would one modify the code to get similar results for an Update method? Currently, the method goes as follows: "AdoRecordSetHelper.getProperties().Item("Unique Table").setValue("table");" Thanks
  22. AlbertoEspinoza

    buy a license

    Hello Thomas, You can contact our sales department via email, info@mobilize.net, Alberto.
  23. bitboss

    buy a license

    Hello, I am looking for to buy the license and didn't find anything. Is there a special web side? Thomas
  24. smithassignment1

    Receive Error License is invalid when try evaluation copy

    That's really a good project to make. i will also thinking to work on it. But I am presently working as a professional content writer.
  25. Hi Danny Paniagua, Here is my PC configuration - Operative System: Windows 10 (Enterprise)- Language: ENU- Edition: Enterprise- Version: 1703 - OS build 15063.1029 Note: I do not see the threshold information. Hope this help. Let me know if you need any additional information. Thanks Chi
  26. DannyPaniagua

    Receive Error License is invalid when try evaluation copy

    Hi Chi, We're trying to figure out what's the problem that you are experiencing on your environment, however our tests work with no issues. We will require of your support identifying the environment characteristics that might be affecting the tool, so we will need more information about your win10 environment in order to try to reproduce the problem you have reported. We have the following configuration: - Operative System: Windows 10 - Language: ENU - Edition: Enterprise - Version: 10.0.10240 (Threshold 1) Can you provide us the information about your configuration? Thanks in advance, Danny Paniagua
  1. Load more activity
  • Newsletter

    Want to keep up to date with all our latest news and information?

    Sign Up
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use