contel
asked on
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
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
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.
Perhaps you should rephrase this in terms of what you are trying to accomplish...?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.