| LinHES Forums http://forums.linhes.org/ |
|
| ODBC Support http://forums.linhes.org/viewtopic.php?f=5&t=18830 |
Page 1 of 1 |
| Author: | gatorback [ Wed Aug 20, 2008 1:16 pm ] |
| Post subject: | ODBC Support |
I am interested in attaching a Windows app to the database to view the tables and fields. My search did not yield much. That being said, if anyone has had experience with setting up ODBC in this app, I would be very interested in hearing your story. Thanks. |
|
| Author: | slowtolearn [ Wed Aug 20, 2008 1:33 pm ] |
| Post subject: | |
Have a look at http://dev.mysql.com/downloads/connector/odbc/5.1.html |
|
| Author: | manicmike [ Wed Aug 20, 2008 3:29 pm ] |
| Post subject: | Re: ODBC Support |
Have you seen phpmyadmin? Mike |
|
| Author: | jmckeown2 [ Thu Aug 21, 2008 3:29 pm ] |
| Post subject: | |
What Windows app are you trying to connect? |
|
| Author: | tjc [ Thu Aug 21, 2008 7:10 pm ] |
| Post subject: | |
There's almost got to be several mysql clients for MS-Windows. All you should need to do is enable remote access like you would for a SBE or FE only system on the server end, and tell the client program the hostname (or IP address) and port for the mysql server. |
|
| Author: | elgordo123 [ Fri Aug 22, 2008 11:55 am ] |
| Post subject: | |
I second slow2learn. I use mysql at work and use that odbc with MS Access to do reporting, etc. |
|
| Author: | craigtv [ Fri Aug 22, 2008 2:14 pm ] |
| Post subject: | |
If you're trying to query or import into other apps, the connector is the way to go, but if you just want to peer into the database and/or update values, you can use MySQL's Query Browser (part of their GUI Tools) here ... http://dev.mysql.com/downloads/gui-tools/5.0.html Functionality is similar to phpmyadmin, but it's in a nice gui. |
|
| Author: | babblefish [ Tue Aug 26, 2008 2:39 pm ] |
| Post subject: | |
It is also possible to connect using the windows tools through an ssh tunnel. http://www.vbmysql.com/articles/security/connecting-the-mysql-gui-tools-to-a-remote-server-through-a-firewall This has the advantage of not requiring a port to be opened to the mysql server. This method does not require any configuration changes on the KnoppMyth box to allow access. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|