vb6 mysql com object

£10-15 GBP / hour

In Progress

Posted

about 12 years ago

£10-15 GBP / hour

Note: User marioalonzo is my preferred developer for this project. I need a VB6 application to download a sql file via CGI and import it into a mysql db. It needs to report any problems to the user. As per issue1169, this doesn't appear to be possible VB6. So can it be done in a COM object that I can call from VB6? The COM object will have a single function Download_Import() with input parameters as follows: * cgi URL * cgi basic-auth user * cgi basic-auth password * cgi timeout (in case I need to extend from VB) * temp dir (to download the file to) * mysql host * mysql database * mysql user * mysql password Return value: something to indicate success or details of failure Notes: * the CGI script may take several minutes to generate the data * the CGI script can return a gzipped file of around 20MB * mysql and zcat (from [login to view URL]) will be available on local machine PATH. Currently I have to run "zcat [login to view URL] |mysql -uuser db" manually on the command line. The application needs to cope with the following problems, reporting them back intelligibly to the client: * network error * basic authentication problem * http timeout * http error * can't write file * corrupted gzip file * db authentication failure * db import failure + other foreseeable problems The solution needs to work on XP, Vista and Windows8. I guess the first step is to write a "Hello World!" COM object and see if I can install it and call it from VB6.

C# Programming

C++ Programming

Visual Basic

Project ID: 1598412

About the project

3 proposals

Remote project

Active 12 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@marioalonzo

Hello Mr. Horton This is the plan that I believe it will provide the desired solution: - First, I will make a prototype assembly following the instructions in the URL [login to view URL] - Second, I will sign the assembly with a strong name, just as it is explained in the following URL [login to view URL] NOTE: Signing the assembly will prevent installation problems that might arise in server platforms. - Third, I will try to make a background thread to be deployed in VB6, following the instructions in the URL [login to view URL](v=vs.71).aspx Once I reach the objectives on each of the previously listed items, I will add all of the project logic The connection to the database will be handled with a connection string. If any impassable technical difficulty arises with this type of connection, I will try to use an ODBC connection instead. I tried to download the file [login to view URL], but unfortunately the URL does not work any more. Is it possible for you to provide me with a copy of this file? I think this work can take between 3 or 5 days, working 8-10 hours everyday. My hourly rate is £10, as per the established range in the project´s page at freelancer.com This proposal is completely negotiable in terms of money and time. Any additional research time will not be billed and/or included in my invoice, only effective work time is going to be included. This proposal is completely negotiable in terms of money and time. Many thanks for considering me a preferred option. Best regards, Mario Alonzo

£10 GBP in 40 days