We are creating a package (written in Caché Object Script) that will provide access to an external DB (MySQL). Because applications that use our package will be run from machines with various, potentially unexpected, operating systems, we’d like to establish a connection to the external DB without using DSNs (we’ve heard that setting up DSNs on certain non-Windows machines can be cumbersome and problematic).
Does anyone know of way to create a connection to an external DB without using a DSN? We have the ip address of the MySQL DB server, port number, the name of the database and the proper credentials (username and password). I was hoping for a flavor of a %SQLGatewayConnection “new” method that took the parameters listed above (as separate fields or as a connection string) and returned a handle to the database’s SQL processing engine (I couldn't find any). I was further hoping that we could then send queries and receive results using that handle.
Please let me know if you have any ideas or if the only way is using ODBC with DSNs and we'll bite that configuration bullet.
Thanks in advance,