MySQL Database connection issues

[NancyM]

I'm brand new to Macro Scheduler, so bear with me. However, I've been a programmer for a lot of decades.

I'm trying to connect to my MySQL database. I downloaded and installed MySQL ODBC/Connector 5.3.6 32 bit. I'm running Windows 7 64-bit. I can connect to the database through the ODBC admin using that string, so I think the connection string is okay.

I can see the 32 bit connector using the 32bit ODBC admin. (C:\windows\SysWOW64\odbcad32.exe) however I can't seem to connect to it via MS.

Here's my connection string:

Code: Select all

    let>str=Driver={MySQL ODBC 5.3 Driver};Server=192.168.2.120;Port=3307;Database=integrations;Uid=obfuscated;Pwd=xyzzy;
    DBConnect>str,dbh
    Let>SQL=SELECT encompass_server_url as url, encompass_userid as user, encompass_password as password FROM clients where LOWER(shortname) = "evolve"
    DBQuery>dbh,SQL,c,numRecs,numFields

[Marcus Tettmar]

I think the driver name is meant to be:

{MySQL ODBC 5.3 ANSI Driver}

Or

{MySQL ODBC 5.3 Unicode Driver}

E.g.:

Driver={MySQL ODBC 5.3 ANSI Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=mydatabase;USER=myuser;PASSWORD=mypassword;OPTION=3

[NancyM]

Yup, thanks. I sure didn't see that but now I do.