Koen Posted July 12, 2008 Share Posted July 12, 2008 Hello, For several years I'm a Ms Acces user. I'm running an application on my PC with splitted database on the same station. The problem is, that I only can use him at home. In the future, I would like to use the application on different PC's with te same database on internet. I have also knowledge of SQL en I can convert my Access tables to SQL tables. Is there anyone who can explane how I should start this operation, step by step. Tanks in advance Koen Quote Link to comment Share on other sites More sharing options...
Wizard Posted July 12, 2008 Share Posted July 12, 2008 I'm not a big expert on databases, but from a quick google search, this and this should help. Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 13, 2008 Share Posted July 13, 2008 You'll need to install MySQL server on your computer. I'm not sure, but I think MySQL is only available on Linux. You'll need to setup remote access on your computer to HelioHost. If you use a router, you'll need to do a port forward of the MySQL port (generally 3306) over to the computer running the MySQL server. Quote Link to comment Share on other sites More sharing options...
AverageJoe Posted July 13, 2008 Share Posted July 13, 2008 I used XAMPP to install mysql and php and configure it for me on windows. I don't use it anymore (I have mysql on debian now). It has good documentation and you should be able to easily set it up. Hope it helps Joe Quote Link to comment Share on other sites More sharing options...
Wizard Posted July 14, 2008 Share Posted July 14, 2008 You'll need to install MySQL server on your computer. I'm not sure, but I think MySQL is only available on Linux. You'll need to setup remote access on your computer to HelioHost. If you use a router, you'll need to do a port forward of the MySQL port (generally 3306) over to the computer running the MySQL server. They have MySQL for Windows, except only the older versions are free. The newest versions are like $200. Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 14, 2008 Share Posted July 14, 2008 Lol... I guess it makes sense. The newest versions for Linux/Apache are still free though, right? Quote Link to comment Share on other sites More sharing options...
Koen Posted July 14, 2008 Author Share Posted July 14, 2008 I read the google search from Wizard, it was interesting but I didn't found the information how to use Access as front end to a SQL database on the internet. I have installed MsSQL server on my local machine. So I can use Access as front end to the local SQL database. Therefore I found the tool "Microsoft SQL Server Migration Assistant for Access". Is there someone who knows how I can migrate my database to the SQL server on Heliohost and then use ms access as front end. Please explain how I setup a remote access on my computer to HelioHost. I use a router. Regards, Koen Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 14, 2008 Share Posted July 14, 2008 We don't offer MS SQL... sorry. You'll need to convert to either MySQL or PostgreSQL. Try exporting your MS SQL database, and then try importing it as a MySQL database. Since MS SQL's syntax is stricter, MySQL should be alright in importing. There might be some differences though - you'll have to deal with those. Quote Link to comment Share on other sites More sharing options...
Kyougi Posted July 15, 2008 Share Posted July 15, 2008 Lol... I guess it makes sense. The newest versions for Linux/Apache are still free though, right? MySQL is free for both Windows and Linux, as well as a variety of other OSes. Only the subscription-based MySQL Enterprise, which provides support and training along with a few enterprise-level tools, costs money. MySQL is licensed under the GNU GPL, so there really isn't any worry. Quote Link to comment Share on other sites More sharing options...
Koen Posted July 28, 2008 Author Share Posted July 28, 2008 I found the solution. MySQL has a connector "MySQL Connector/ODBC 5.1" http://dev.mysql.com/downloads/connector/odbc/5.1.html#win32 With this tool it is possible to use MsAcces with MYSQL. I must say, in spite of some differences, everything is working great. Quote Link to comment Share on other sites More sharing options...
Ashoat Posted July 28, 2008 Share Posted July 28, 2008 That's good to know, as some of our scripting languages/platforms (namely ASP.NET, but perhaps Perl and Ruby as well) don't have built-in MySQL libraries. They probably have ODBC libraries though. Quote Link to comment Share on other sites More sharing options...
Koen Posted July 29, 2008 Author Share Posted July 29, 2008 there are more connectors: Connector/ODBC: Standardized database driver Windows, Linux, Mac OS X, and Unix platforms. Connector/J: Standardized database driver for Java platforms and development. Connector/Net: Standardized database driver for .NET platforms and development. Connector/MXJ: MBean for embedding the MySQL server in Java applications. MySQL native driver for PHP - mysqlnd: The MySQL native driver for PHP is an additional, alternative way to connect from PHP 6 to the MySQL Server 4.1 or newer. look on the page: Connectors on Downloads. http://dev.mysql.com/downloads/connector/ Quote Link to comment Share on other sites More sharing options...
Trippin Posted July 30, 2008 Share Posted July 30, 2008 I'm sorry I'm probably not contributing to the subject, but I wanted to say another option instead of xampp would be to use Apache2triad. I just personally think it's a lot better and the web control panel it offers is a lot more robust. I just wanted to let you know as it can be a pain to install each separately (apache, mysql, ftp, etc) and might help you test everything before you make the site live. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.