If I remember correctly MySQL does NOT allow for remote connections out of the box, you'll have to enable this in the config file. Although this link doesn't mention Windows, it will be very similar
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html DISCLAIMER: I am not a MySQL expert, the information provided above was a best effort answer, no guarantees are made on its accuracy or its results :) -----Original Message----- From: [EMAIL PROTECTED] on behalf of Robert Rhodes Sent: Fri 6/22/2007 9:03 PM To: [email protected] Subject: [rt-users] RT3 Windows and ODBC for Reporting I'm trying to use the MySQL ODBC driver to connect to my server [on the same IP backbone - no firewalls] so I can pull data and create some reports from RT3. This is the RT3 Windows port. I'm not sure if that makes a big difference on reaching it via the ODBC driver, though. I can install the ODBC driver on the same system and reach the database, but not on another computer. I've tried setting up the "server" field with the IP address of the server hosting RT3/MySQL, and making sure the port is set to 8285. The settings have successfully worked when installed/setup on the server (localhost). But all I receive when I do this from another computer is a SQL_ERROR. Does anyone have any idea what newbie cheeseball thing I've forgotten to do? Any help appreciated as always. RLR -------------------------------------------------------------------- This Electronic message contains information from CompuPay which may be privileged. The information is intended to be for the use of the addressee only. If you are not the addressee, or the employee or agent responsible to deliver it to the intended recipient, note that any disclosure, copy distribution or use of the contents of this message is prohibited. If you have received this Electronic Message in error, please promptly notify the sender by return e-mail. For more information regarding our company please visit www.compupay.com http://www.compupay.com/
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
