I have the same topic als a user last year. Is there any solution?
I am playing around with this module to connect to various databases and I can get it working for a pure mysql connection, but when I try the ODBC option to connect to our MS SSL server all I get is “Connection failed: SQLSTATE[IM002] SQLDriverConnect: 0 [unixODBC][Driver Manager]Data source name not found and no default driver specified”
I’ve made sure ODBC is setup and I can connect on the DSN using isql and get a prompt and perform queries.
Only thing I can think is that the host box needs the DSN in a specific format, anyone got any insight into this?