richard

I need to write a C++ progam that allows the sybase isql.exe program
to connect to it and send it sql commands such as "select getdate()".
The program would respond in a way that isql.exe would think it's a
sybase server 12.0. The reason for this is that I have legacy scripts
that use isql.exe to communicate with a sybase server. I have to
intercept the commands that they send and send the reply that they
expect from the sybase server. Any Ideas?


thanks

richard shariff

rob verschoor

This strikes me as a rather bizarre requirement. Why not just use a
*real* 12.0 server ?

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

richard

I need to write a C++ progam that allows the sybase isql.exe program
to connect to it and send it sql commands such as "select getdate()".
The program would respond in a way that isql.exe would think it's a
sybase server 12.0. The reason for this is that I have legacy scripts
that use isql.exe to communicate with a sybase server. I have to
intercept the commands that they send and send the reply that they
expect from the sybase server. Any Ideas?


thanks

richard shariff

slappy

This is what Sybase Open Server is all about. You provide functions to
handle events for connect, language, rpc, etc, and the Open Server
library handles the rest.

I hope you only have a small subset of functionallity you want to
emulate though. "emulating" a full featured relational database might
take alot of work.

rob verschoor

This strikes me as a rather bizarre requirement. Why not just use a
*real* 12.0 server ?

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

slappy

This is what Sybase Open Server is all about. You provide functions to
handle events for connect, language, rpc, etc, and the Open Server
library handles the rest.

I hope you only have a small subset of functionallity you want to
emulate though. "emulating" a full featured relational database might
take alot of work.

richard

What we are doing is replacing a Sybase Open Server real-time server.
This server was written to handle thousands of SQL transactions a day
and notify C++ clients about each transaction. The Sybase Open Server
library has a capacity problem at about 17 notifications a second for
20 or more C++ clients. We're going to replace the Open Server library
with a real-time notification mechanism that C++ clients could
subscribe to. Throughput should increase to over 120 notifications a
second for 20 or more C++ clients.

The Sybase Server emulation will only be used for a small subset of
functionality.

Any ideas on how best to accomblish this?
thanks richard shariff

richard

What we are doing is replacing a Sybase Open Server real-time server.
This server was written to handle thousands of SQL transactions a day
and notify C++ clients about each transaction. The Sybase Open Server
library has a capacity problem at about 17 notifications a second for
20 or more C++ clients. We're going to replace the Open Server library
with a real-time notification mechanism that C++ clients could
subscribe to. Throughput should increase to over 120 notifications a
second for 20 or more C++ clients.

The Sybase Server emulation will only be used for a small subset of
functionality.

Any ideas on how best to accomblish this?
thanks richard shariff