create a dll in vb to connect to a webservice

Posted on 2006-06-07
Last Modified: 2010-04-07
Hi EE's

I have a project with some unique requirements - and im kicking tires

I have a web application written in classic asp / sql server 2000

My customer has an application that they are developing in visual c++ that needs to synchronize data in their application to my website

their application downloads data from a device and saves it into a csv file - each downlaod creates a new csv file (called an event file)
I need to have that data from the event file sent to my website - then the website needs to tell the client app data has been recieved
and then the client application will open the website and the website will display the uplaoded data along with other compiled reports

SO...the question is....

I think it would be easier for me to create an activex control in VB6 to give to them to program against rather than have them try to consume the webservice themselves?
that way - i can be confident it is not a problem with my webservice or activex control - and it would be an easier implementation for them

Question by:bigbillydotcom
    LVL 5

    Assisted Solution

    We do something like that but we use the exe not dll because you may need user interface to display progress bar, setup paths, and any other connection settings that will take to get the files from one server to another.

    Once the varies settings is in place then all the user needs to do is to click on the button labeled Go and that will transfer the files. I also have a command setup so that any program can just launch the exe and run it without user interface as long as the settings are set correctly.

    my 2 cents
    LVL 13

    Author Comment

    thanks lunchbyte
    i considered that as well, but was concerned with the install/distribution of that model
    their app being in vc++ has made it somewhat of a pain, but maybe an activex control rather a dll would suffice
    that way, i could have some UI controls like you said, but wouldnt have to worry about installing the exe
    thanks - lemme hear from some others (or more from you!)
    this is more of an open topic and i will award points/grade accordingly
    LVL 5

    Expert Comment

    When it comes to install/distribution exe or dll, you will install the same files (like vb6 run time files and/or third parties that you are using) so it will make no difference which one you use. Just wanted you to be aware of that.

    I recently worked on a project using used the window service project. I have it setup so that as soon a file is created in certain folder, the program kicks in gear and does it work in the background. It was great and fun so another thing for you to think about.
    LVL 13

    Author Comment

    thanks lunchie
    i understand - and i agree as far as the runtime
    i just dont want to overcomplicate their process
    I would have preferred it all be done in vb, but they already have the vc++ program
    like i said - im kicking tires

    if you or anyone has a better idea how to get data from a client app to a website than this idea

    please share
    LVL 5

    Accepted Solution

    Seems we have the same situation, my client, downloads data from AS400, saves it to a text file, filename used is date stamp, manually uploads the text file via my website, from there a report is generated and is shown in the website. uploading process is done via dll embedded in my website.

    What you can do is tell the VC++ group to upload/send the csv file from a shared folder where your website resides, run a schedule that reads the folder contents if it contains a new file, that is every new file read, filename is being saved from a table for comparison against the folder. Then read the csv content and show it to you web.
    LVL 13

    Author Comment

    thanks pat
    problem is there will be millions of users
    trying to synch their client pcs to the website
    and the transfer and synch is going to be imported into a sql dbase at the website
    and integration with the client app needs to be seemless - not depend on the user to select a file and so on
    but just click a synch button in the client app
    I appreciate yours and any comments I get on this question
    LVL 5

    Expert Comment

    what a robust application, itss like you're creating a dialer/trojan that sends info to/from your website.
    LVL 13

    Author Comment

    with the exception that they have paid $3500 for the software
    and installed it on thier pc

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now