[RESOLVED] Processing Access DB on Ftp ..

[rory]

is there a way to connect to an Access DB on an FTP and process the data ..?

Or would you first have to connect, download the database, then do what you want to the local file ..?

Thanks
Rory

[si_the_geek]

I've never seen a method of connecting via FTP, I'm pretty sure that ADO/DAO/etc.. aren't designed for it.

I'd assume that a download is the only solution.

[Krass]

Unless you absolutely need to use an FTP, couldn't you use a database on a webpage somewhere and connect thru?

I am wondering because I might just have to do something similar, so that all my friends have access to a certain database.

[rory]

Another member here posted some code which showed how to connect using MySql so that might be my only choice. Will have to see how hard it is to convert Access DBs to MySql now ..

Was saying FTP as thats the only way to Open and Write to the Access DB on IIS as far as I know. . besides Front Page .. but i guess cant just open the DB while inside FTp, have to run a script on the server to do that ..

Any other ideas ..?

[si_the_geek]

I see.. in that case take a look at this CodeBank thread, it explains how to use normal ADO code via IIS.

[rory]

thanks, will check it out and post back here on my results ..

[rory]

Nah I keep getting an Internet Server Error, Code 8447

I tried a DSN connection on my local server but still same error ..
But online Im using File Connections ... so DSN wont work anyway.

Anyways .. ill search some more ..

[rory]

Ok so basically what i came up with is this ... Sending a Post to an ASP script on the server and getting a response ... so basically the ASP script does all the database work then does a Response.Write and thats what the VB Program will get and do its work on .. havent tested on alot of data yet but it does work so far for basic queries.


I Also Edited the Post to attach a Full Example ..
Uses XML 2.0 By Default but you can switch the call to 3.0 OR 4.0 easily.
4.0 is better but not all remote servers have it installed. 3 and 4.0 support timeout settings, while 2.0 hangs the prog until it auto times out.

Only have to change the web URL and WebPage name in the form code,
Then Copy the files in the ASP folder to the Web URL Folder.
4 Buttons to test include Database Query, Update on single record,
Query on all records, and also a simple get HTML from a web page ..
Database Fields and Data must have a | around each one.

Anyone got any comments/suggestions or more info on this method please let me know .. I still need to add the delete and insert feature, but has update and retrieve.
Thanks..