Data over HTTP

[Sparky]

Hi,

Not sure if I've got the right forum, but hope so. I have a VB6 program which I want to interface with an MS SQL database. Rather than leaving the port open for the database on the firewall I thought it might be better to have the VB app call an ASP page which can then query the database on the server and return the data that way?

Is this possible and does anyone have any views/advice on querying the DB in this way or querying it direct?

I'd be grateful for any help possible with this.
Cheers,
Sparky

[visualAd]

Yes -- have a look at the link in my signature which shows how to send HTTP Post requests using VB6. You can send variables and even isntructions in the body o f post request which the ASP application can pick up and use to access the database, it can even return a status notice depending on whether your applications request failed or succeeded.

[Sparky]

Thanks for replying - when I try to run this in VB6 I get an error about licensing, is there something I need to do before I can use it, or is it because I am trying to use it through the VB editor?

Thanks,
Sparky.

[dglienna]

What version of VB are you running?

[Sparky]

**Apparently there is a fix to stop that problem, which is available from microsoft - thanks anyway**

Sorry, forgot to mention that - I am running VB6 Professional.

Thanks for replying,
Sparky.