Transfer Data to my web database from VB

How do i transfer data to an internet database from VB  using any technology?

thanks
ashok
ashok_001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bonggoyCommented:
Could you be more specific?  
0
autCommented:
Use the INet control and the Web Browser control.

Let your program create an HTML file, and in the HTML document, place your data in a FORM to be submitted using "POST".

Then write a simple JavaScript that automatically submits the form to a CGI script on your server.

The CGI script should handle writing the data into the database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ashok_001Author Commented:
Hi!

I have a program that collects some information, when it's running, from the user - VB 6.0, i now want to upload all of this info, as a record, into any standard database, that is on the web.

I also want the program to read specific information off the database.
I do not want to make use of any browser commands/html etc. Is there any activex control, or any other utility/library that will automate this work for me? and what kind of database, is required on the server side, access/custom db etc..... i dont know
cgi, is there a cgi library that can do this for me

thanks guys for responding
ashok_001
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

ashok_001Author Commented:
Adjusted points to 150
0
ashok_001Author Commented:
Aut,

I need to know a little more info abt this, please help me with this qn. i want to do my work like how real player
checks for upgrade. do let me know

ak
0
autCommented:
Checking for upgrade can be achieved with a VERY simple trick :-)

Here's how:
1. Create a text file, call it "version.txt", and in it, place the latest version number. DO NOT put a carriage after the version number.

2 Host this file on the web server, so it's url will be something like this:
http://www.mydomain.com/version.txt

3. Place an Inet control on your form. Also, place a Command Button on your form.

4. In the form's code, place the following:
Private Sub Command1_Click()
    Dim LatestHTML As String
    Static flgChecking As Boolean
    Dim CurrentVersion As Single
    Dim LatestVersion As Single
   
    'flgChecking ensures that you cannot send another request if the current
    'one has not finished executing
    If flgChecking Then Exit Sub
    flgChecking = True
   
    'Get Current Version
    CurrentVersion = CSng(App.Major & "." & App.Minor)

    'Get the Text File
    LatestHTML = Inet1.OpenURL("http://www.mydomain.com/version.txt")
    LatestVersion = Val(Trim(LatestHTML))
   
    'Check Current Version
    Select Case LatestVersion
        Case CurrentVersion
            'User is running the latest version
            MsgBox "No newer version is available at this time."
        Case 0
            'Could not check for newer version
            MsgBox "Could not determine the latest version, please try again later."
        Case Is > Version
            'A newer version is available
            MsgBox "A newer version is available for download."
    End Select
   
    'Allow the subroutine to be run again
    flgChecking = False
End Sub

0
ashok_001Author Commented:
Aut,

I have one more question

I tried to upload to an ftp server using
inet1.execute "POST filename(w/path)",
it fails. any reasons?

ashok
0
autCommented:
Why does it fail? What's the error, I mean...
0
ashok_001Author Commented:
There is no error as such, but the file is just not transferred. I would be very greatful to you if you, would give me an example so as how to upload via http/ftp

pls help

regards
ash
0
autCommented:
Don't have exact code at the moment, search for:
upload
in this topic area, and you'll get a LOT of matches...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.