bear with me on this one a little… I gave myself a crash course in web design several months ago, and learned a lot, but haven’t used it since and also forgot most of what I taught myself and what is possible. What I want to do is basically connect my Microsoft Access database (located on my local machine/computer) to my MySQL database that is hosted on my website. I did research, and connecting MS Access and MySQL is possible, but my problem is with my web hosting provider. I use Yahoo as the host and apparently they do not allow remote connections to my MySQL database. I did more research and figured out there are workarounds to actually allow those remote connections.
I found this website/software called RazorSQL that in short, you upload a .PHP page to the server, which connects to the MYSQL database, and then the local RazorSQL software connects to that .php page, hence “linking” to the database, allowing remote connections to that datbase. This is basically what I am loking for, but the problem is I can only use their software to connect to the MySQL database and not MS Access as I was hoping to.
The way I figured out how to connect MS Access to a MySQL database is by a driver provided from the MySQL website. It is a basic simple connection form asking for server name, user, pass and database name. The problem with using this to connect directly to my remote MYSQL database is that Yahoo doesn’t provide a server name to my MySQL database only “MySQL” which I’m assuming is the server name “AFTER” you are already connected to the main server or already on the website.
What I was thinking is (is it even possible) to create a similar .php page that opens my MySQL database and then use the MySQL driver to connect to that .php page in the same fashion that RazorSQL does it like explained above. First, without getting into details, would this be possible? And if so, what would be involved/how hard would it be to create this, keeping in mind my limited knowledge of php. Or, I will supply the php code that RazorSQL uses (which seems pretty simple, but I really dont know how to understand it) and maybe someone can assist me in simple modifications to allow it to work with the MySQL driver. Thanks in advance for your help and sugestions on this one.