Solved

ftp Odbc connection

Posted on 2011-09-06
4
422 Views
Last Modified: 2012-08-13
hi,

how can i open connection to access db ( mdb ) using ftp ?
my ftp is : ftp://ftp.civileng.co.il/private/DB/mainDB.mdb.

thank you,
contel
0
Comment
Question by:contel
4 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36490182
I don't believe you can do that.  FTP is File Transfer Protocol and has it's own special methods and won't support the requirements of ODBC.  You can use that link to download the MDB to your computer but you can't open there.  FTP doesn't give you access to the driver that is needed on that computer, only to the file.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36490233
Perhaps you should rephrase this in terms of what you are trying to accomplish...?
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 36490372
If you are wanting to download the file it is possible.
FTP Client functions

If you are trying to open a recordset or link to a table it is not possible.  JET is a LAN database engine. It will not work over http, ftp, etc.    I don't know of any database that will work via FTP protocol/

See:  Running an Access database over the internet

0
 
LVL 16

Expert Comment

by:AlexPace
ID: 36491861
You could roll your own using a scriptable FTP server, but it would be ugly.

On the client side you would make a little file named <filename>.sql where the <filename> part is a unique string.  The file would contain an SQL statement.  Then you would connect to the FTP site, upload the file, and start requesting a directory listing every 5 seconds or so.  The scriptable FTP server would, whenever a *.sql is received, extract the SQL statement, execute it against your Access database using ADO, persist the resulting recordset to a file, rename the persistedfile as <filename> and then delete or archive the .sql file.  At this point the FTP client will notice the new file in the directory listing and download it.  Your client will inflate the recordset back into an object for use in your code.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question