I have a Microsoft access database on the web server that will get updated with new data from a front end application software based on traditional ASP. Frequently, I need to transfer the database to my local computer through FTP software to enable transferring some data to oracle database. I have written an application based on traditional VB6. Everything is working well.
Now, I want to get connected to the Microsoft Access Database on Web server from a local system through a DSN and any other method. The idea is to transfer the data directly from web server to the oracle database in my local system. I know the IP address of the web server and also the path of the database file on the web server. Is it possible to create a DSN with the web server parameters that are known to me i.e. IP address and the path of the file.