Solved

ftp Odbc connection

Posted on 2011-09-06
4
435 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

679 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