It has been a while since I connected a non-Microsoft data base... You may need to set up Windows ODBC data source (ODBC Administrator). You may also need a My SQL ODBC driver to make it all happen. RSSQL should be able to talk to any ODBC data connection.
That's part of the issue. I have a ODBC connection (System DSN) setup to connect to my MySQL database. It works correctly and I can connect to the database. There's 2 or 3 other MSSQL conenctions setup as well and RSSQL doesn't see any ODBC connections.
Have you looked at the number of MS Windows Server CALs (Client Access Licenses) required? Is it user based or connection based that you have set up versus what does the software require? I am not an expert but know that stopped me before with SQL databases using connection based licenses.
Just as a follow up; we were finally able to get RSSQL talking to MySQL through an ODBC connection. It seems to be working perfectly. It turns out we just had the data connection configured incorrectly.
We're having a similar problem to the original poster, as we're trying to make RSSQL communicate with our MySQL database. When setting everything up in RSSQL, we are able to see the procedures stored on the MySQL database in the "ODBC Data Object Definition" window within RSSQL, but RSSQL cannot see any of the procedures' parameters. I have a feeling this may be because unlike in MSSQL, parameters in MySQL are not declared using the '@' symbol, but that's only a guess. Any suggestions ?!
We tried getting stored procedures to work as well, but we were never successful. I don't think it's possible, like you said, due to the way parameters are defined.