Srinivas Mantha
asked on
Connecting to Microsoft Access Database on the Web server from a local host
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.
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.
Shane is correct. The only thing I'll add is this:
In general, unless you can navigate to the Access database using Windows Explorer, you cannot "connect" to the Jet database. So unless your web server is on the same network segment as you, or you can somehow establish a VPN connection (which would be highly unlikely) you are out of luck in regard to a direct connection.
In general, unless you can navigate to the Access database using Windows Explorer, you cannot "connect" to the Jet database. So unless your web server is on the same network segment as you, or you can somehow establish a VPN connection (which would be highly unlikely) you are out of luck in regard to a direct connection.
ASKER
Ok. My VB application software for data migration from MS access to oracle also involves transfer of some data from oracle to MS access. Few fields simultaneously would get uptated in both the databases. Therefore, a simple XML output of MS access table data would not suffice. If I migrate totally from MS Access to MySQL database on the web server (which I plan to do any, irrespective of the current problem), would it be possible to get connected to MySQL database on the web server with a DSN connection (of course with internet on). If not a DSN, PHP coding would also be good enough. Any thoughts?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the prompt support
If you want to use VB6 and classic ASP, I would still write it the same way. It just would be a lot harder since you'd have to write the dataset<-->XML and VB6<-->web code yourself.
Shane