We're considering a PKB implementation against our ASE DB. As it stands now, there's not a native ASE Driver for PKB. All the literature I see recommends using a direct connection to ASA, with proxies to the source ASE system. Is there a way to directly execute a procedure in the ASE database? Or, does this configuration mean that only table level access via the proxys is available?
asked 16 Dec '09, 20:09
Once you create a proxy server in SA to connect to your ASE server, you can issue a
to send the sql-statement to the server-name (i.e. ASE) server. In your scenerio, your sql statement would be the call to the ASE procedure.
This is discussed in the SQLAnywhere docs which you can view here: http://dcx.sybase.com/index.html#1101en/dbreference_en11/forward-to-statement.html
answered 17 Dec '09, 02:10