|
Walden, thank you for bringing up this point. I like to think of stored procedures as a different animal than raw ODBC. Stored procedures definitely provide a layer of insulation between the client and the host, and that's one of the main benefits of client/server programming. And given it's standard nature, I think ODBC/SP (my personal acronym for ODBC calls to stored procedures) is a valid technique, especially for query applications and simpler transactions. ODBC/SP is a little cumbersome when trying to send a large amount of data TO the stored procedure, but beyond that concern, I definitely put it in a different category than raw SQL statements passed via SQL. Again, thanks for making the distinction. Joe Pluta www.plutabrothers.com > -----Original Message----- > From: Walden H. Leverich > > Joe, > > With regard to your complaints against ODBC, can you be more specific? Are > you referring to client side code that actually updates the database (SQL > UPDATE, DELETE, INSERT) or would you include using ODBC to call stored > procedures on the AS/400? > > I'll agree that I don't want my client side code (be it JSP, ASP, VB, > Powerbuilder, Java, whatever) making direct updates into my > database, but I > don't see a problem using ODBC to call stored procedures. Use ODBC to call > stored procedures (especially through ADO) is relatively simple. Case in > point, I have an ASP-programmer in my office now calling stored procedures > on an AS/400. He wouldn't know an AS/400 if it fell on him. I say > "call this > sp" and he codes up the necessary ASP code. I could replace that > AS/400 with > a SQL Server box and his code would never know the difference. > > -Walden > > PS. Actually, ODBC is dead. OLE/DB is the new replacement. However, I see > them used interchangeably.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.