Search:

Type: Posts; User: Daniel Duta

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    326

    Re: Immediate Window in VB6 IDE

    Thank you qvb6. I have replied to Krool's message to understand better the UI settings from registry.
  2. Re: Add User Control NOT AVAILABLE?

    I have a similar issue but mine is related to Immediate window behavior in sense that I cannot bring/dock the window on the below of the IDE. Could you tell me what properties are set under UI? Could...
  3. Replies
    2
    Views
    326

    Immediate Window in VB6 IDE

    For some tome, for some reason when I am in design view the Immediate window is no longer properly. Although it is set as dockable it cannot be moved to the bottom side but only to the top. Once it...
  4. Re: Ping a program running on some IP via the internet

    Could it be used to access the messages from a mail server via IMAP over SSL (port 993) ?
  5. Replies
    34
    Views
    1,212

    Re: [RESOLVED] Fast replace in a large string

    In my opinion, if we talk about a robust solution, in terms of speed the Olaf's method for parsing huge files is hard to beat in vb6. It is based on ICSVCallback_NewValue function and a StringBuilder...
  6. Replies
    2
    Views
    274

    Re: Uudecoding in VB6

    For some reason at the beginning I have got an error at the latest line of the file (Subscript out of range) due to the fact that Ubound of byte array was larger than should be but once I extracted...
  7. Replies
    2
    Views
    274

    [RESOLVED] Uudecoding in VB6

    I use an IMAP over SSL library to extract (via port 993) some data from a mail server and usually the attachments are coming encoded in Base64 but from some servers that use linux OS these...
  8. Thread: End of VB

    by Daniel Duta
    Replies
    39
    Views
    1,604

    Re: End of VB

    It's a bit funny but until now I thought you were a teenager :)
  9. Re: [vbRichClient] SQLite database and basic database functions

    Yes, I treat the excel file as database using the OLE DB method. But instead to transfer data to Access db I have to upload a db from a SQL server (where the Office package is not installed). Usually...
  10. Re: [vbRichClient] SQLite database and basic database functions

    Usually we have to transfer from different sources (csv, text, excel) tables which are significantly larger as number of rows and columns. I know from experience that method "INSERT INTO ... ...
  11. Replies
    3
    Views
    409

    Re: RC5 GzDecompress function

    Hi Olaf. It is a bit strange but when I run my routine at home the RC5 function worked from first attempt.. I tried to reproduce that decompressing error but with no success. I have no explanation...
  12. Replies
    3
    Views
    409

    RC5 GzDecompress function

    I use for a while the GzDecompress function from vbRichClient library and it worked so far very well. However it seems there is a memory limitation related to the file size (Runtime error 7; Out of...
  13. Replies
    7
    Views
    678

    Re: RC5 without register it

    Hi Olaf. Yes, I try to make a small app RC5 based (...the previous parser) and it would be useful to deploy it in a regfree way. What I tried above, using the Trick's module, was to register the...
  14. Replies
    7
    Views
    678

    Re: RC5 without register it

    Thank you for reply, Trick. I would prefer to use early binding method but unfortunately I have got an error within CreateObjectEx1 function.
    170327 The code lines used are :

    Option Explicit
    ...
  15. Replies
    7
    Views
    678

    RC5 without register it

    I am interested to use the Trick's module presented at this link http://www.vbforums.com/showthread.php?835363-RESOLVED-VB6-ActiveX-dll-and-using-it-without-registering-it-(manifest-) and to use it...
  16. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    I took all these suggestions transferring the StringBuilder content on disk at each 1Mb accumulated in SB (that in this context is a buffer). The results are beyond my initial expectations: total...
  17. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    Hi, Dile. Of course, it would be more efficient to move all content in a database directly but we work in a team with some specific task. Shortly, we have 3 layers of tasks inside our ETL process: ...
  18. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    Thank you Olaf for your solution. You have synthesized very well above what I intend to do (what is it possible to do) within blocks and on the other hand the speed indeed increased significantly...
  19. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    Yes, it is a normal text file with row separators LF. My ''chunks'' are separated by "============================" (...I call them blocks because chunks are associated with space of a string and...
  20. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    A block is, in your example, a chunk of a file that has a size defined by the buffer size. You call it m_lBlock explicitly. In my case a block is the data within 2 delimiters (see above "======")...
  21. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    Thank you for reply, Arnout. I didn't understand very well the entire usage of the class but I was able to read the first line and I found out the file size (757517246) and total number of blocks...
  22. Replies
    17
    Views
    1,137

    Re: How to parse big files ?

    The initial request was based on a smaller file (100.000 rows) and the approach above worked very well and fast. The reason to read it twice was to capture some specific details from blocks...
  23. Replies
    17
    Views
    1,137

    [RESOLVED] How to parse big files ?

    I need to parse a big txt file (non csv) that has over 700 Mb and so far all my attempts failed with Out of memory error. Initially this file had a smaller size and the lines below worked very well...
  24. Re: [RESOLVED] How to save a xls file as csv via ADO ?

    Such files, which for some are exceptions, are common files at my workplace.
    These files come automatically from a BI tool and it only exports data from another tool where users have the freedom to...
  25. Re: How to save a xls file as csv via ADO ?

    Sorry for the late reply but I got stuck with some work. Well, I am glad to see the above CSV converters are 100% similar in terms of results both with original excel file and the Python output. I...
  26. Re: How to save a xls file as csv via ADO ?

    Thank you, Chris. Have you test it before ? For what reason you have used the loop For j = LBound(s1) To UBound(s1) : Next j ?
  27. Re: How to save a xls file as csv via ADO ?

    Absolutely, I am aware about it and for the second part I do not have big expectations considering that our small community is divided.


    No, Dile, I have just need to extract the excel info into...
  28. Re: How to save a xls file as csv via ADO ?

    Thank you Dile for details regarding CSV format in conjuction with MIME standard. Even I have to decode files often from this standard, in this case all tests above failed locally without having to...
  29. Re: How to save a xls file as csv via ADO ?

    I've tested approaches above and both of them, at a certain line, start to write data in a wrong format. While the ChrisE's routine mixes data even from the first line, the RC5 String Builder method...
  30. Re: How to save a xls file as csv via ADO ?

    After many attempts I've noticed that there are 3 sources of errors that affect my conversion to a csv file: some cells contain comma, other cells contain many carriage return and other cells contain...
  31. Re: How to save a xls file as csv via ADO ?

    Yes, Dile, I filled the db path with full path of my csv file according to wqweto suggestion and most likely this is the proper way as long as I get a different error :). Indeed, the excel file...
  32. Re: How to save a xls file as csv via ADO ?

    Yes, you are right wqweto, however Microsoft Access Database Engine 2010 (ODBC and OLEDB drivers) was accepted to be installed around SQL Server 2012 so that to have a connectivity with Office files...
  33. Re: How to save a xls file as csv via ADO ?

    Thank you for reply, Dile. For some reason first Execute command raises an error. I suspect that the destination path mentioned after INTO command is not declared properly or at least I do not...
  34. Re: How to save a xls file as csv via ADO ?

    No, that server has nothing installed from the Office package but the SQL server only. I do not understand very well which is the gain creating a linked table in database when my purpose is to have...
  35. Re: How to save a xls file as csv via ADO ?

    Thanks, Chris. Yes, this is the classic method (late binding) but I cannot use it as long as that machine doesn't know anything about Office library.
  36. Re: How to save a xls file as csv via ADO ?

    Thank you for reply westconn. Yes, I tried this approach before and it is a bit faster but the cells in the final csv looks very mixed. I have also tried an older function posted on site years ago...
  37. [RESOLVED] How to save a xls file as csv via ADO ?

    I need to open an excel file, to read a certain sheet and to save it as csv on a server where MS Office is not installed. I know how to set the ADO properties so that to get data either as array...
  38. Replies
    3
    Views
    468

    Re: RC5 Stream

    Thank you for your support, Olaf. Very useful the Base64Dec function because it may return the result either as string or byte array. In the same time it is amazing that in a single line of code you...
  39. Replies
    3
    Views
    468

    [RESOLVED] RC5 Stream

    I have a task where I used RC5 library due to some functions that suits my needs. The main file is coming in the MIME standard and does contain an attachment as tar.gz format. The processes of file...
  40. Replies
    15
    Views
    1,127

    Re: vbRichClient error

    Yes, Olaf, most likely I fell into that error...At first step I noticed that my app screams for vbRichClient5.dll and I registered it manually in the system folder just to test if it is seen in the...
Results 1 to 40 of 355
Page 1 of 9 1 2 3 4



Click Here to Expand Forum to Full Width