Re: Open Client vs Embedded SQL
- From: Michael Peppler <mpeppler@xxxxxxxxxxx>
- Date: Mon, 19 Dec 2005 07:06:34 +0100
On Sat, 17 Dec 2005 16:43:50 +0100, jeremy wrote:
> Hello,
>
> I'm new to Sybase.
> I'm an Oracle/Pro*C developer.
> It seems there is 2 ways to access Sybase database in C : Open Client and
> Embedded SQL.
> I know Embeded SQL (= Pro*C) but I just saw Open Client code on the Net
> : it's horrible !!!
> So, why using Open Client against Embedded SQL ? As Emb. SQL is a lot
> simpler to write and maintain, is Open Client faster (execution) ?
I guess it depends on your point of view. As a C programmer the first time
I saw Embedded SQL I found it horrible to look at, and I figured that
debugging that kind of code would be tricky (because of the precompile
stage, etc).
OpenClient is a little tricky to get started with, but it is quite
straightforward once you have the hang of it. I usually have a few
home-grown helper functions that take a few short-cuts and make the code
writing a bit easier.
Michael
--
Michael Peppler [TeamSybase] mpeppler@xxxxxxxxxxx - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
.
- References:
- Open Client vs Embedded SQL
- From: jeremy
- Open Client vs Embedded SQL
- Prev by Date: Re: bcp into syslogins
- Next by Date: Re: Charset 'cp437' not found on ASE 11.0.3 for linux
- Previous by thread: Open Client vs Embedded SQL
- Next by thread: dbcc rebuild_text results in full tranlog
- Index(es):
Relevant Pages
|
