I separate a website that is hosted on a Windows server. I am hoping to agitate to a Linux-based computer (probably something that runs the cPanel setup, as I am older with it).
The large supply is that the underway website has a noise database that is utilised to help up aggregation to the visitors. It’s the most favourite feature of the website, so I poverty to attain trusty the transformation is right.
This database is an MS Access file. I hit a ultimate ODBC unification to that file, and then I hit PHP cipher that peeks into the enter and lets visitors do queries.
My anxiety is that if I advise to UNIX / LAMP, I module not be healthy to attain this ultimate ODBC unification to the MS Access file, and I module requirement to modify the DB into MySQL. I would same to refrain doing this, as the database comes to me from someone added who operates in MS Access. (I am alive of the existence of converting to MySQL every time, I meet would same to refrain doing so.)
Related Blogs
- The Linux Mint Blog » Blog Archive » How to raise Linux Mint 7 …
- gruchalski.com » Archive » Flex Builder 3 Linux Alpha 5 acquirable …
- The Linux Mint Blog » Blog Archive » How to raise Linux Mint 8 …
- Jim Zemlin discourse | Linux User
- How To Install VirtualBox Guest Additions in Linux (Ubuntu, Debian …
- » How to establish weblogic server on 64 taste O.S. (Linux /Solaris …
- Set up a Linux server at bag (Ubuntu Server) – Part I | Open Blog
- Running The PHP Web Development Environment Under The Linux …
- Operations illusion cure: nightly server restarts « Sam Aparicio
- Migrating an older MS Access database to MySQL « Barbed Wire …
- Relational Database Management System and MySQL Tutorial …
- Write to MS Access 2007 Database from VB.NET - VB.NET Code …
Related Blogs
- The Linux Mint Blog » Blog Archive » How to raise Linux Mint 7 …
- gruchalski.com » Archive » Flex Builder 3 Linux Alpha 5 acquirable …
- The Linux Mint Blog » Blog Archive » How to raise Linux Mint 8 …
- Jim Zemlin discourse | Linux User
- How To Install VirtualBox Guest Additions in Linux (Ubuntu, Debian …
- fs Linux | Future System Linux | File Server Linux − Great analyse …
- fs Linux | Future System Linux | File Server Linux − La Biblia de …
- fs Linux | Future System Linux | File Server Linux − Apple iPod …
- fs Linux | Future System Linux | File Server Linux − Le frasi …
- » How to establish weblogic server on 64 taste O.S. (Linux /Solaris …
- Migrating an older MS Access database to MySQL « Barbed Wire …
- Relational Database Management System and MySQL Tutorial …
- Write to MS Access 2007 Database from VB.NET - VB.NET Code …
Yes, you can use PHP to make ODBC links.
I think you have a couple of options for keeping the data in MS Access.
You could set up the Linux box to host the static content (and any additional dynamic content you develop that does not use Access as a data source) and use the Windows server as an application server. You could do that in several ways - the easiest would be to just host the Access based web application on a different host name, e.g. have linuxbox.mydomain.com and windowsbox.mydomain.com. When someone clicks the login link for the Access application, they’re taken to the Windows box.
If you really really need ODBC access to the Windows machine from the Linux box, you can get various ODBC bridging products that are out there. Essentially they forward ODBC API calls over the network from one machine (Linux, in this case) to a Windows machine and make local ODBC calls there (to talk to Access, in this case). I haven’t seen a good free ODBC bridge.
Either way you end up needing to care for two OSes instead of one, so think about ways you could make it all work on Windows before taking on long term support for two boxes if one would suffice. Lots of Linux software is also available for Windows.
If you can afford to have two systems, one Linux box and another one Windows box, then you can do what you want.
Host your MSAccess file on windows machine and use ODBC to access it.
but what I guess is this will cost you more as compared to one time investment, convert your data from MSAccess to MySql and use it.
I do not know, but there will be a way, you can check source forge for any project if somebody has developed a MS Access support on linux, then your problem will be solved.
i hope this resolve your problem. for more help