title: Connect to mySQL over LAN
body: <p>Hey all, i am having problems with connecting to a PC on my local LAN thats running the mySQL database.</p>
  
  <p>The code in VB6 i have is:</p>
  
  <pre><code>.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=\\SERVERPC;DATABASE=lstoredb;UID=root2;PWD=thepassw;OPTION=3"
  </code></pre>
  
  <p>If i put "localhost" then it works just fine (i have mysql running on my DEV system as well) But once i put it on the other machine it doesn't ever connect.</p>
  
  <p>I can access the SERVERPC in my network but for some reason VB6 can not find it? I've even tried the IP address:</p>
  
  <pre><code>.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=192.168.1.9;DATABASE=lstoredb;UID=root2;PWD=thepassw;OPTION=3"
  </code></pre>
  
  <p>And it still does not work. Turned off all firewalls and still nothing... Even added port 3306 to my router for the 192.168.1.9 IP and nothing still!</p>
  
  <p>The DEV computer is Windows XP SP3 and the mySQL server is on Vista Home Prem. 32-bit.</p>
  
  <p>Any help would be great! Thanks! :o)</p>
  
  <p>David</p>