Results 1 to 2 of 2

Thread: ODBC COnnection

  1. #1
    New Lounger
    Join Date
    Feb 2010
    Location
    Grand Junction, CO
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Greetings,
    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?

    Thanks
    Andrew

  2. 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!

    Excel 2013: The Missing Manual

    + 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!

  3. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,554
    Thanks
    2
    Thanked 614 Times in 550 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?

    Joe


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •