[rt-users] RT3 Windows and ODBC for Reporting

[Helmuth Ramirez]

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: rt-users-bounces at lists.bestpractical.com on behalf of Robert Rhodes
Sent: Fri 6/22/2007 9:03 PM
To: rt-users at lists.bestpractical.com
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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070622/710a747f/attachment.htm>