Connecting to MYSQL

[HowardHammerman]

My client has Crystal XI. He is trying to connect to an external sql database using a MYSQL driver. Someone created a system DSN for him using the driver and the correct IP address, user name and password but Crystal can't see it. I tried creating a file DSN but it wouldn't save even after it tested OK within the create DSN utility. Any help would be appreciated.


Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[briangriffin]

My first thought is that the client created a 64 bit DSN, which Crystal won't recognize. The ODBC administration dialogs look identical, so the best bet is to go Start --> Programs --> Crystal Reports --> 32 bit Data Source Administrator to make sure you're setting up a 32 bit DSN.