[rt-users] RT3 Windows and ODBC for Reporting

[Robert Rhodes]

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
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070622/477f981d/attachment.htm>