We have not tested out this exact combo at Appeon so I cannot say what are the tips and tricks to watch out for. But theoretically it should work if you use ODBC. Hopefully, somebody else can chime in here.
But I will add that from a security perspective it is not recommended to do this, and you could also introduce significant performance issues or you would need to make some noticeable changes to your source code.
From a security perspective you generally don't want to open up the database to the world. Over the Internet typically you want to keep it to HTTP communication to the Web server and lock down your database.
From a performance perspective, PB roundtripping to the database over an Internet connection has much more latency than the same transmission over a LAN connection. If you have a couple roundtrips to complete some action then that should be tolerable, but in our experience it's common for an app to have at least some areas that make dozens or hundreds of calls.
Glad to hear you.
Thank you for getting back to me.
I been ask: can we do it?
That's number one and number two is the fact, that we using ado.net connecting to mssql and in the past, i newer figure out how to use ODBC without creating datasource, connection syntax wise, for example:
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = True
SQLCA.DBParm = "ConnectString='DSN=mysql-aws;UID=username;PWD=userpassword',StripParmNames='Yes'"
where "mysql-aws" it is a datasource i need to create first.
There is some references that it is possible to substitute this with driver name, but i newer figure out how to make it work.
Sincerely
Vlad
Driver=;
For example, a DNSLess SQL Anywhere 17 connection would be
Driver=SQL Anywhere 17;eng=MyDbSrv;dbn=DbName;uid=dba;pwd=sql;....
The value for the Driver can be determined in the Drivers tab of the ODBC administer or the Driver column for the DSN mysql-aws.
I did work: mysql_trans.DBParm ="ConnectString='Driver={MySQL ODBC 8.0 ANSI Driver};Server=iwtest.............
Greatly appretiated.
Sincerely
Vlad