Ok I'm sorry about that, i thought that you were mapping a local network share. The net use works for local network but it will not work onto your server if the server is not a windows box, has a firewall between you and the server, or you don't have the correct user account and permissions on the server, that is assuming that the server is a windows server and does not have a firewall. If you are looking to download a copy of the mdb from the ftp server using standard windows nt/2000 then you can either set up a batch script:
>>Start Of Batch<< @echo off rem Transmits all in commandline specified files if %1%. == . goto end set ftpascii=c:\ftpascii.txt set destinationDir=/ echo open ftpserveraddress> %ftpascii% echo useraccount>> %ftpascii% echo userpass>> %ftpascii% rem echo ascii>> %ftpascii% rem echo binary>> %ftpascii% rem echo hash>> %ftpascii% :start if %1%. == . goto send @echo %ftpascii% @echo get %1>> %ftpascii% REM ----------------------------------- shift goto start :send @echo quit %1>> %ftpascii% @echo on ftp -s:%ftpascii% del %ftpascii% @echo off :end pause >>End of Batch<< Or you can use a windows explorer integration program that will allow you to use the ftp site as a mapped drive locally. Something like Internet neighbourhood from www.deerfield.com if you just want to run queries on the database without downloading it (Which is what both of these suggestions will do) then you will need something more powerful that can accept proper TCP/IP traffic (I.e. Oracle, etc) rather than reading the file that the data is stored in (Access). I hope that this is more help. Alex Elger Micronage Ltd [EMAIL PROTECTED] -----Original Message----- From: jake williamson [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 12:07 PM To: ActiveServerPages Subject: Re: online odbc connection for word & website hi alex, the drive is an ftp site (not local). found the info for mapping a network drive but it wont let me select the shortcut i made to the ftp site! almost there... will look into the help thing, cheers, jake On Wednesday, August 14, 2002, at 11:17 am, Alex Elger wrote: > Is what you are trying to map to on your local network? > There is more help if you type in net use /? at a command prompt. > The mapping will appear in the My Computer window as a disk with a > network > connection symbol. > This drive is visible from the whole computer, i.e. word command line, > ftp, > etc. > Alex Elger > Micronage Ltd > [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
