How do I download records from my online database

It seems that we can easily put data into our online database, but how do we download records from the online database, to our local machine?

 

Hi,
Like this..
http://www.dasptv.com/avc-view.aspx?videoid=17&categoryid=1

 

Hi WiseMX, Thanks for the quick reply. I can see how this would work for SQL databases, does the same apply for MS Access Db with the DiscountAsp.Net control panel? Also, is there an automatic way, that you could build into the website, to 'push' data down to the local machine when the user selected a record and pressed a button?

 

Hi,
With an Access DB the best way would be to D/L it and use a local Access IDE.
The way I used to do it with Access was with code pages.
Back at that time I used Dreamweaver, which creates code for Access for you.
The current versions may do the same..I don't mess with Access any more unless requested but I used to use it on-line for things like a Shoutbox.
All the best,
Mark

 

Hi, yes, I tried to download the .mdb file, but the DiscountAcp site rules would not allow me to download this type of file.

 

Hi,
With your sites FTP login you should be able to snatch the file.
(I do know if can be difficult to get a file manager to "see" the '_database' folder.)
What are you using to manage the files?
Something handy and free for this sort of thing is:
http://www.dasptv.com/avc-view.aspx?videoid=20&categoryid=1
All the best,
Mark

 

Hi WiseMX, I am using CuteFTP for uploading files to my site. When I try to FTP files, then there is a problem with doing this from the /_database folder. Even when I move the MS Access Db outside that folder, the FTP is blocked for the type of content (.mdb). The system, however, does not check files that have been renamed (ex .doc) - but that is not a very elegant solution.

Is there a way I can ask DiscountASP.Net to relax the rules for certain named files?

Regards,

HandiDataco

 

Hi,
You can ask but I have no idea: [email protected]
All the best,
Mark

 

No it isn't. You must be having some other kind of problem.

Check your FTP log to see what it says when you try to upload/download an .mdb file. Also check your firewall/router settings. No one ever thinks about those, but they can be the cause of some mystery problems with FTP activity.

 

Hi Mark,
Thank you for the video, but I am using Visual Web Developer 2008 Express. Do you have a recipe for downloading a database from the DASP server to VWD on a local machine? Any help would be greatly appreciated.
With best regards,
Eric (alias Greek)

 

Hi,
Do you have the Express version of SQL Server 2008 installed?
All the best,
Mark

 

Hi Mark,

I have SQL 2008 Express installed, but I use it from within Visual Web Developer.

Eric

 

Hi,
This does confuse many developers. . .
SQL Express comes in many flavors now.
The best solution for you will be to D/L the free updated versions that have the management tools.
That way you can work with SQL Server by itself and still be able to use it in VWD.
If you need a D/L link let me know, I'm guessing you know the drill. ;-)
All the best,
Mark

 

Hi Mark,

Thank you for the tip. I do have the program, but haven't used it directly until now. I will watch the video again and try to put it into practice.

Thank you again for your trouble.

---

Although SQL Server seems to work fine for me in VWD, it doesn't work properly as a standalone application. I'm not sure what the problem is.

Is it possible to use the database backup file to copy the database with its data from the remote (DASP) server to a local machine?

Thank you again for your trouble.

Eric

 

Hi,
If your local SQL Server Express isn't working well use Bing and you'll find some tips, such as allowing it on your system, i.e. Firewall, etc.
The backup tool can only be used as is, I don't think there is a way to get that locally.
You can however use the on-line tool provided to run scripts that can.
https://sqlwebadmin.discountasp.net/

I'm way behind in Webcasts but this is something I plan on covering in webcasts.
http://www.mylittleadmin.com/en/tour6.aspx
All the best,
Mark

PS Sorry if this way quick but my kids are bouncing off the walls right now. ;-)
http://www.msftwise.com/assets/whackywisecarverkids.jpg

 

Hi Mark,

Thank you very much for the fast response and for the tips. I'll experiment with them a bit.

Thank you also for the picture of your children. They look charming.

I greatly look forward to the videos.

With best regards,

Eric

 

...Thanks for the kind words ;-)