Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

ftp Odbc connection

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
contel
Asked:
contel
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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
 
Jeffrey CoachmanCommented:
Perhaps you should rephrase this in terms of what you are trying to accomplish...?
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
AlexPaceCommented:
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now