Visual Basic/MySQL interface

[bwjen1]

I have a SQL database with my PowWeb account. I have several php pages which interface with this but I am keen on extending this to a stand alone vb application.

I want the vb program to run stand alone on a machine and use an internet connection to interact with the database.

Does anyone have any thoughts on the topic or any snippets of code which show how to connect to a remote unix database

Cheers,

[tbonekkt]

You won't be able to do this at PowWeb since remote mysql connections are disabled.

[B&T]

Unless you put the update scripts on the server, then have your PC app link to a server IO module via uploaded data. A kludge, but it could work ;) though it would have to be a low volume app without fear of multiple simulaneous updates that could not be controlled.

[blade83]

... have your PC app link to a server IO module via uploaded data. A kludge, but it could work ;) ...

Cool idea -- I might have to try that out.

[bwjen1]

Can you post any developments you make please blade83.

Thanks heaps.

[zimmer3]

Hello,

I've done this in two different ways in Visual Basic 6 (I've done this in VB 5 too, but its been years)

1. Add the web browser control to your Form, and size appropriately. You can then use VB to validate data and such

2. Add the Inet control (i believe that stands for Internet Transfer Control), it might be listed in the Controls as Microsoft Internet Transfer Control.

Inet will let you perform internet actions without a browser. For example, if all you wanted to do was add new rows to your db, you could use the Inet control to send either GET or POST requests. You can also use Inet to grab a page, an image, whatever, and for ftp.

If you think either will work for you, give us a better detail on what you are trying to do and I can give you a snippet toget you started.