Followed the Windows XP SP2 DB Connectivity Fix.
When I go to create a database connection and then test i get:

'F:\mysite\db\info.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Settings:
Remote Info:
Access: FTP
FTP Host: ftp.mydomain.com
Host directory: wwwroot/

Testing Server:
Server model: ASP.NET VB
Access: FTP
FTP Host: ftp.mydomain.com
host directory: wwwroot/
URL Prefix: www.mysite.com/

Site folders are set up under the www.mysite.com as db (containing database), logs, and wwwroot (which contains the pages)
any help would be appreciated.