Accessing SQL Server & Access Data via internet

[TheTuna]

I know nothing about setting up an IIS Server.

Is it possible using IIS to allow a vb application to connect to data on the server (either access or sql server) when said application is connected via the internet?

If Yes, can someone provide direction?






No Dolphins were harmed in the posting of this message... Dolphin Friendly Tuna!

 

[mattKnight]

Hey Tuna

long time no post! How are you?

Have you thought about VPN rather than IIS?

Take Care

Matt
If at first you don't succeed, skydiving is not for you.

 

[paulbent]

VPN is a good suggestion and I'd also look at running your app under Terminal Services for VPN users.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[vb5prgrmr]

In short IIS is a service that serves up static and/or dynamic content i.e. tek-tips, yahoo, google, etc.

You can however, create a program that can access this service and push and pull content from the site but if you were going to do that, then why not create the program as thin client?

Good to see you back and glad to see you miss this place.

Good Luck

 

[TheTuna]

Hey thanks gang... good to be back.

You know, not sure why I didn't consider VPN... back to the drawing board.

No Dolphins were harmed in the posting of this message... Dolphin Friendly Tuna!

 

[BobRodes]

You can access SQL Server via IIS through RPC's. In ADO, you set up a connection object with a connection string starting with "Provider=MS Remote;"

I figured this out doing a search for that string in the MSDN; got a bunch of connection strings.

It's important to know how handlers work as well, since more recent versions of MDAC require the use of a handler for security reasons.

HTH

Bob

 

[TheTuna]

Bob, I also found the information, but I wasn't sure if IIS was required to facilitate it's use. I just don't know diddly about IIS/Web servers...

I can do what I want by using code I've written before that will send the data via sockets (winsock and/or socketwrench from catalyst.) But I spotted the info on Provider = MS Remote and that got me wondering.

Thanks...

No Dolphins were harmed in the posting of this message... Dolphin Friendly Tuna!