View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: ODBC Support
PostPosted: Wed Aug 20, 2008 1:16 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
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.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 20, 2008 1:33 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
Have a look at http://dev.mysql.com/downloads/connector/odbc/5.1.html


Top
 Profile  
 
 Post subject: Re: ODBC Support
PostPosted: Wed Aug 20, 2008 3:29 pm 
Offline
Joined: Sun Aug 28, 2005 7:07 pm
Posts: 821
Location: Melbourne, Australia
Have you seen phpmyadmin?

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 21, 2008 3:29 pm 
Offline
Joined: Sat Sep 02, 2006 9:17 am
Posts: 359
What Windows app are you trying to connect?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 21, 2008 7:10 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 22, 2008 11:55 am 
Offline
Joined: Thu Feb 12, 2004 2:54 pm
Posts: 392
Location: Beaumont, CA
I second slow2learn. I use mysql at work and use that odbc with MS Access to do reporting, etc.

_________________
ASUS A7N266 Micro-ATX Motherboard
Athlon 2200 processor
512K Kingston PC2100 Memory
MicroAtx Case
2 PVR250's w/remote
eVGA e-GeForce mx4000 (64 Ram with Tv/Out (Svideo))
Lite-on DVD cd-rw combo
120 GB Western Digital


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 22, 2008 2:14 pm 
Offline
Joined: Mon Oct 09, 2006 11:27 am
Posts: 75
Location: Raleigh, NC
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 26, 2008 2:39 pm 
Offline
Joined: Sun Mar 05, 2006 11:27 am
Posts: 44
Location: Edinburgh, Scotland
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.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 27 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu