on 2009 Dec 16 8:09 PM
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?
Once you create a proxy server in SA to connect to your ASE server, you can issue a
FORWARD TO server-name { sql-statement }
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.