Re: Simply accounting 2010 and Mysql ODBC 3.51

[Isabel Maicas]

Hi Peter,

The file exists under c:\windows,

Here is the content:
[ODBC 32 bit Drivers]
MySQL ODBC 3.51 Driver (32 bit)=Installed
[MySQL ODBC 3.51 Driver (32 bit)]
Driver=C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll
Setup=C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3S.dll
32Bit=1

This is after I reinstalled the connector 3.51.30. A tad newer than the original 3.51.19 that came with Simply Accounting (SA) 2010.

I cannot seem to access any SA databases with Excel query or Mysql for Excel.
When I use the user ID and password from simply I get a connection error, failed to connect with user and password.
Is there a generic UserID and password when Mysql is started by an application?

Thank you for your help, much appreciated,

Isabel