[aclug-L] Re: Using SQL in a C program

[Larry Bottorff <mrprenzl@xxxxxxxxxx>]

John Reinke wrote:
> 
> So, if I write a program in C that uses SQL, should I be able to use the
> same code for Oracle via Pro C, and via another DBMS (MySQL or Postgres)
> using its own precompiler? As long as I can work on my project at home and
> don't have to make major changes to my code for Oracle, I don't mind using
> multiple precompilers.
> 
> BTW, I've got cable modem access, but only 96MB. I probably don't have the
> time or nerves for an Oracle install.
> 
> John
> 
> >That won't fly at all. Pro C is its own beasty only on the Oracle
> >platform. Most SQL DBMS's have an embedding scheme, but they're all
> >unique to that DBMS. You can download O8/O8i from Oracle. It's rather
> >large, though, so do it "at work", i.e. on a T1 connection. I might be
> >able to get you a CD copy if all else fails. You have to have 128mb
> >memory and nerves of steel, as Oracle installs are the sequel to Dante's
> >Inferno.
> >
> >Lars Von Dem Ast
> 
> -- This is the discussion@xxxxxxxxx list.  To unsubscribe,
> visit http://tmp2.complete.org/cgi-bin/listargate-aclug.cgi

No, I'm saying you probably CANNOT use embedded syntax good on
Postgres/MsSQL and expect it to work with ProC/Oracle. Unless you can
verify to the contrary, I wouldn't count on it. Sorry if this
inconveniences you. . . .

Lars Von Dem Ast

-- This is the discussion@xxxxxxxxx list.  To unsubscribe,
visit http://tmp2.complete.org/cgi-bin/listargate-aclug.cgi