Exporting specific SQL data to a text file or Access DB on a given FTP site

Hi All

Wonder if you could give me any pointers on the following plan:

1) I want to auto-extract a number of resultsets from an SQL 7.0 DB using
possibly 3 or 4 different queries, which in turn can use 3 or 4 different
tables each.

2) Ideally I'd like to put these resultsets into 1 Access DB, but separate
text files would be OK at a push.

3) I want to auto-upload the DB (or text files) to a given FTP site, but not
disclose the FTP login details anywhere.

The reason for this is that this plan/app is going to run on a client's
Small Business Server 4.5 machine and send the data to my FTP account, which
I don't want them to know the login details for.

Because my ASP files need to be on the same domain as the text file/Access
DB in order for me to query it, if they had my login details they would be
able to download and rip my ASP files.

If you have any pointers on how to do the above it would be very much
appreciated.

Rgds

Robbie

Re: Exporting specific SQL data to a text file or Access DB on a given FTP site

> 1) I want to auto-extract a number of resultsets from an SQL 7.0 DB using
> possibly 3 or 4 different queries, which in turn can use 3 or 4 different
> tables each.

http://www.aspfaq.com/2482

> 2) Ideally I'd like to put these resultsets into 1 Access DB, but separate
> text files would be OK at a push.

Well, you could create the database using ADOX in your ASP code, then insert
the queries directly.

Or you could try out DTS, it can easily send data to an Access DB, but I
think it's more complicated if you need to create the DB first.

> 3) I want to auto-upload the DB (or text files) to a given FTP site, but
not
> disclose the FTP login details anywhere.

Think about that. If you want it to be automated, you're going to have to
store the credentials SOMEWHERE. If they are only in your head, then no
script will be able to read your mind... you'll have to enter the
information every time it runs.

> Because my ASP files need to be on the same domain as the text file/Access
> DB in order for me to query it, if they had my login details they would be
> able to download and rip my ASP files.

This is where a good strong legal agreement helps.

Perhaps you should consider having them upload the DB to a "safe" folder on
your FTP site, then your script could run in your environment and push
things back to them.

--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.

Re: Exporting specific SQL data to a text file or Access DB on a given FTP site

On Mon, 14 Mar 2005 14:44:50 -0000, "Astra" wrote:

>Hi All
>
>Wonder if you could give me any pointers on the following plan:
>
>1) I want to auto-extract a number of resultsets from an SQL 7.0 DB using
>possibly 3 or 4 different queries, which in turn can use 3 or 4 different
>tables each.
>
>2) Ideally I'd like to put these resultsets into 1 Access DB, but separate
>text files would be OK at a push.
>
>3) I want to auto-upload the DB (or text files) to a given FTP site, but not
>disclose the FTP login details anywhere.
>
>The reason for this is that this plan/app is going to run on a client's
>Small Business Server 4.5 machine and send the data to my FTP account, which
>I don't want them to know the login details for.
>
>Because my ASP files need to be on the same domain as the text file/Access
>DB in order for me to query it, if they had my login details they would be
>able to download and rip my ASP files.
>
>If you have any pointers on how to do the above it would be very much
>appreciated.

For the last two, you'll either need to put your logic in a DLL or use
a different FTP user/password/location to be secure. You cant write
code in any language that says "Log in to a secure service but never
provide any login information or credentials".

Of course, I won't point out that if it's their server, you already
don't have control of the code...

Jeff

Re: Exporting specific SQL data to a text file or Access DB on a given FTP site

Perhaps add the ability for the user to download a CSV file which can
easily be opened in Excel.

Puzzle 5 Not much different from other solutions by Manohar Kamath
posted 1/12/99
http://www.asp101.com/puzzles/puzzle5_s7.asp

Puzzle 5 "Write delimited data to browser window" by Kirk Lockhart
posted on 12/21/98
Write the data in plain text to the browser window, and the user can
save the results as a plain text file and then import the data into
Excel or whatever application they want.
http://www.asp101.com/puzzles/puzzle5_s1.asp

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


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

Re: Exporting specific SQL data to a text file or Access DB on a given FTP site

Is it possible that the first script could be written that requires a
login/password that would then trigger a second "hidden" script that
authenticated the user and then fired a different FTP login/password to
allow the file to upload but without revealing it?

I'm a newbie and just browsing the groups in order to increase my knowledge
(and occasionally show my ignorance).

Phil

"Aaron [SQL Server MVP]" wrote in message
news:OWKvx$KKFHA.484@TK2MSFTNGP15.phx.gbl...
> > 3) I want to auto-upload the DB (or text files) to a given FTP site, but
> not
> > disclose the FTP login details anywhere.
>
> Think about that. If you want it to be automated, you're going to have to
> store the credentials SOMEWHERE. If they are only in your head, then no
> script will be able to read your mind... you'll have to enter the
> information every time it runs.
>