Providing external access to data

[Dave Navarro]

I need to provide someone access to an SQL database over the Internet.

Would I better off just setting up a username/password for them to
access the database directly? Or, should I have them access the data as
XML through HTTP?

In either case, I'm going to have to provide them with sample code.

I have a "public" database at the moment that we allow access as XML
through HTTP.

I'm not so much worried about security as I am "bandwidth". I have no
idea how much bandwidth an SQL query over the Internet takes.

--Dave

[Atrax]

I'd say you'd probably be best providing a periodic dump of XML data,
say, updated every hour (or whatever)

this is a pretty simple task which you could achieve in no time at all
with :

WSH
a FOR XML query
Windows Task Scheduler

unless of course they also need update access.




________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bullschmidt]

Here is a related idea you might want to consider:

For a "quick and dirty" generic ASP solution to putting database tables
on the Web that just requires setting up a configuration page for each
table or query and uploading the database to the Web as long as you have
an autonumber field in each table (and as a more advanced issue you'll
probably sometime in the future want to create login capabilities),
perhaps try something like this:
GenericDB by Eli Robillard
[url]http://www.genericdb.com[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!