Just as a quick start (I don't use MySQL, so I can't give an example):
What SA version are you using?
Starting with SA 11.0.0, MySQL is supported as a remote server (class "mysqlodbc"), so that should work. In older SA versions, you could use the generic remote server class "odbc".
You might have a look at the online docs. I don't know if there are particular Linux issues here (you might need to define an ODBC data source), but otherwise, proxy tables are quite easy to use.
Basically you have to do three steps:
Insert/update/delete through SA should be possible as long as you do not define the remote server as readonly and as the connected user has according table permissions.
answered 10 Mar '10, 08:39
Hi Volker and thank You for replay ... My main problem is the Remote Server definition (I've already used proxy tables with ASA remote server...). I've tried with SA11 using Sybase Central wizard and the question is: What's the right (DSN less !) "connection information" for a standard MySql connection (on Linux, of course...) ? Consider that an example of my ASA Remote Server definition is:
answered 12 Mar '10, 10:04