Thread: ODBC COnnection
2010-03-09, 16:39 #1
- Join Date
- Feb 2010
- Grand Junction, CO
- Thanked 0 Times in 0 Posts
I have a firewall problem with Win7.
I have a MySQL database running on my win7 box, and I am trying to get Crystal reports to generate reports from that DB. Crystal is running on an XP machine, and is on the same network.
I Have the odbc connection setup using the MySQL connector. When I totally disable the FIrewall on Win7 - the ODBC works, and I can generate the reports. Turn it back on and nothing. I have setup 2 rules for port 3306 (TCP & UDP) on the incoming side, but I am still blocked. 3306 is the port that Mysql talks on. Do I need to setup outgoing rules too?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2010-03-09, 19:52 #2
- Join Date
- Mar 2001
- St Louis, Missouri, USA
- Thanked 595 Times in 532 Posts
Are you sure you set the firewall on the Windows 7 machine to allow port 3306?
Are you sure the firewall rule matches the network type for your network?