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