|
 |
asp_databases thread: Getting SQL7DB subset downloaded to client
Message #1 by "Alec Moss" <alec_moss@b...> on Sun, 29 Apr 2001 17:05:42
|
|
Hello all,
I working on an app just now that has a simple SQL7 db on the webserver
that is working for around 50 different people.
I need to allow them to periodically download the data collected relevant
to that individual into a mirror db at stored on the client.
I'm wondering if my best best to to write a comma delimited text file and
offer that for download. then use the download to import into SQL7 at the
client. Bit messy - anyone got any suggestions?
-Alec
Message #2 by "Dallas Martin" <dmartin@z...> on Mon, 30 Apr 2001 08:14:32 -0400
|
|
Use SQL70 extended stored procedure "xp_sendmail"
Check BooksOnline for additional help
Dallas
----- Original Message -----
From: "Alec Moss" <alec_moss@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Sunday, April 29, 2001 5:05 PM
Subject: [asp_databases] Getting SQL7DB subset downloaded to client
> Hello all,
>
> I working on an app just now that has a simple SQL7 db on the webserver
> that is working for around 50 different people.
>
> I need to allow them to periodically download the data collected relevant
> to that individual into a mirror db at stored on the client.
>
> I'm wondering if my best best to to write a comma delimited text file and
> offer that for download. then use the download to import into SQL7 at the
> client. Bit messy - anyone got any suggestions?
>
> -Alec
>
Message #3 by "Blake, Shane" <Shane.Blake@p...> on Mon, 30 Apr 2001 10:43:20 -0400
|
|
if there's not too many clients, set up a publication of the data on your
sql server and have the clients just subscribe to it...
or set up a dts to transfer the data and use asp to run the dts as needed...
shane
raleigh, nc
-----Original Message-----
From: Alec Moss [mailto:alec_moss@b...]
Sent: Sunday, April 29, 2001 1:06 PM
To: ASP Databases
Subject: [asp_databases] Getting SQL7DB subset downloaded to client
Hello all,
I working on an app just now that has a simple SQL7 db on the webserver
that is working for around 50 different people.
I need to allow them to periodically download the data collected relevant
to that individual into a mirror db at stored on the client.
I'm wondering if my best best to to write a comma delimited text file and
offer that for download. then use the download to import into SQL7 at the
client. Bit messy - anyone got any suggestions?
-Alec
|
|
|
View Cart
