|
 |
asp_databases thread: downloading records in a database
Message #1 by "Suzanne M. Haig" <smhaig@t...> on Mon, 23 Apr 2001 15:48:04 -0400
|
|
Hello:
I have a vb/sql server 7.0 app that is running at a client site. (There is
no IIS server at the local site, no intranet at the local site--only on the
ISP)
In order to get info from people not at this office, we have set up a form
on a web site with asp/ado/access 2000. We are using a ISP. There is no
inhouse web server. The person in the field fills in the info and it gets
stored in Access 2000 on the internet. An email is sent to the home office
letting them know someone has entered data via the web.
Now here is my problem. That data in Access 2000 has to end up in the local
in house sql server database. How can I get it there?
The primitive thought I had was that I would manually have them FTP the
Access table to a local directory and then my vb app would have a button
that would import the data into sql server from the Access table.
There has to be a better way.
Is there any way to use the ADO connect string with the URL of the web site
from the VB project to get the data directly from the Access table without
FTPing it.
Or is it possible thru an asp page to select the records to be downloaded
and send them to the local directory. At that point, there is no problem.
The in house user would press a button on the vb app and get the data
already nicely placed in another Access database on the local directory.
Thanks for any suggestions.
Suzanne Haig
Message #2 by Kyle Burns <kburns@c...> on Mon, 23 Apr 2001 15:35:58 -0500
|
|
You could set up an ASP page on the server that returns formatted data
instead of HTML. This could even be SQL insert statements. The VB App on
the client side could retrieve that "page" (really just a string containing
commands) and execute the SQL on the local SQL Server.
>> -----Original Message-----
>> From: Suzanne M. Haig [mailto:smhaig@t...]
>> Sent: Monday, April 23, 2001 2:48 PM
>> To: ASP Databases
>> Subject: [asp_databases] downloading records in a database
>>
>>
>> Hello:
>>
>> I have a vb/sql server 7.0 app that is running at a client
>> site. (There is
>> no IIS server at the local site, no intranet at the local
>> site--only on the
>> ISP)
>>
>> In order to get info from people not at this office, we have
>> set up a form
>> on a web site with asp/ado/access 2000. We are using a ISP.
>> There is no
>> inhouse web server. The person in the field fills in the
>> info and it gets
>> stored in Access 2000 on the internet. An email is sent to
>> the home office
>> letting them know someone has entered data via the web.
>>
>> Now here is my problem. That data in Access 2000 has to end
>> up in the local
>> in house sql server database. How can I get it there?
>> The primitive thought I had was that I would manually have
>> them FTP the
>> Access table to a local directory and then my vb app would
>> have a button
>> that would import the data into sql server from the Access table.
>>
>> There has to be a better way.
>>
>> Is there any way to use the ADO connect string with the URL
>> of the web site
>> from the VB project to get the data directly from the Access
>> table without
>> FTPing it.
>>
>> Or is it possible thru an asp page to select the records to
>> be downloaded
>> and send them to the local directory. At that point, there
>> is no problem.
>> The in house user would press a button on the vb app and get the data
>> already nicely placed in another Access database on the
>> local directory.
>>
>>
>> Thanks for any suggestions.
>>
>> Suzanne Haig
>>
>>
>> ---
>> SoftArtisans helps developers build robust, scalable Web
>> applications!
>> Excel Web reports, charts:
http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
$subst('Email.Unsub')
Message #3 by "S. M. Haig" <smhaig@t...> on Tue, 24 Apr 2001 10:33:41 -0400
|
|
Could you elaborate on this a bit. Not sure what formatted data means.
Thinking only of things like formatted ascii text, but then that would mean
a text file.
The thing that surprises me (I have posted this problem before), is that
downloading records in a table seems like something that would need to be
done alot, yet there doesnt seem to be any standard way of doing this. I
wonder is I am not posing the question properly or if there are other
alternatives to solving this problem that I just don't know about.
Thanks
Suzanne Haig
-----Original Message-----
From: Kyle Burns [mailto:kburns@c...]
Sent: Monday, April 23, 2001 4:36 PM
To: ASP Databases
Subject: [asp_databases] RE: downloading records in a database
You could set up an ASP page on the server that returns formatted data
instead of HTML. This could even be SQL insert statements. The VB App on
the client side could retrieve that "page" (really just a string containing
commands) and execute the SQL on the local SQL Server.
>> -----Original Message-----
>> From: Suzanne M. Haig [mailto:smhaig@t...]
>> Sent: Monday, April 23, 2001 2:48 PM
>> To: ASP Databases
>> Subject: [asp_databases] downloading records in a database
>>
>>
>> Hello:
>>
>> I have a vb/sql server 7.0 app that is running at a client
>> site. (There is
>> no IIS server at the local site, no intranet at the local
>> site--only on the
>> ISP)
>>
>> In order to get info from people not at this office, we have
>> set up a form
>> on a web site with asp/ado/access 2000. We are using a ISP.
>> There is no
>> inhouse web server. The person in the field fills in the
>> info and it gets
>> stored in Access 2000 on the internet. An email is sent to
>> the home office
>> letting them know someone has entered data via the web.
>>
>> Now here is my problem. That data in Access 2000 has to end
>> up in the local
>> in house sql server database. How can I get it there?
>> The primitive thought I had was that I would manually have
>> them FTP the
>> Access table to a local directory and then my vb app would
>> have a button
>> that would import the data into sql server from the Access table.
>>
>> There has to be a better way.
>>
>> Is there any way to use the ADO connect string with the URL
>> of the web site
>> from the VB project to get the data directly from the Access
>> table without
>> FTPing it.
>>
>> Or is it possible thru an asp page to select the records to
>> be downloaded
>> and send them to the local directory. At that point, there
>> is no problem.
>> The in house user would press a button on the vb app and get the data
>> already nicely placed in another Access database on the
>> local directory.
>>
>>
>> Thanks for any suggestions.
>>
>> Suzanne Haig
>>
>
|
|
|
View Cart
