cancel
Showing results for 
Search instead for 
Did you mean: 

execute SP in ASE through ASA

Former Member
1,753

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?

Breck_Carter
Participant
0 Kudos

What is PKB? ( yes, I've looked, and I'm feeling particularly dumb, so be gentle 🙂

0 Kudos

PocketBuilder (ex-Pocket PowerBuilder).

Accepted Solutions (0)

Answers (1)

Answers (1)

MarkCulp
Participant

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