Article:		Open Database Connectivity in Jaguar
Subject:		remote server ?
Date:		2003-12-15 06:45:40
From:		anonymous2
Hi, Can odbc be used to connect to a mysql database on a remote machine? What if the remote machine is not a linux box? I need to write an excel macro that would update the content of a worksheet by retrieving data from a mysql database. Any suggestions please...I am struggling with thing. Thanks for any help. Siva

Showing messages 1 through 2 of 2.

• remote server ?
  2003-12-15 06:47:57  anonymous2 [View]
  
  
  I mistyped:
  What if the remote server IS a linux box
  
• remote server ?
  2003-12-15 07:06:52  anonymous2 [View]
  
  
  While I have not tested this, I do not see any reason why it should not work. The type of the server (Windows, Linux, OS X, whatever) should not matter as well.
  
  You would need to set the host parameter to whatever the remote server is and verify that the remote server can be accessed remotely.
  
  I would check out MySQL's Connector/ODBC manual at:
  http://www.mysql.com/products/myodbc/manual.html
  
  Andrew