[Info-Ingres] FW: Ingres ODBC Driver Support REPETED ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralph E. Loen - 28 May 2008 17:47 GMT

Hello Thiago,

The Ingres ODBC driver does not support repeated queries at the present time. I recommend instead using SQLPrepare() and SQLExecute(), as these provide even better improvements in performance than repeated queries.

I'm not sure what an "Ingres 2.6 Administrator" is. We do support an Ingres ODBC Administrator, but only for non-Windows platforms on Ingres 2006 GA and later. Microsoft provides an ODBC Administrator as part of the MDAC SDK package. The Microsoft ODBC Administrator allows you to configure data source definitions for drivers named "Ingres" and "Ingres 2.6". See the Ingres Connectivity Guide for more information.

Ralph Loen
Senior Software Engineer
Ingres Corporation
Ralph.Loen@ingres.com

PHONE: +1 650.587.5528
FAX: +1 650.587.5550

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of thiagomz
Sent: Wednesday, May 28, 2008 7:07 AM
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] Ingres ODBC Driver Support REPETED ?

Hi Guys !

I´ve a doubt, can I use REPETED with Ingres ODBC Driver, is it supported ? If, yes, how can I use that ?

I´m using 'Ingres 2.6 ODBC Administrator', is this a driver or a manager for microsoft odbc ?

Att.

Thiago Zerbinato
Ingres Newbie
Brazil
_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Reply to this Message

thiagomz - 28 May 2008 20:44 GMT

> Hello Thiago,
>
[quoted text clipped - 32 lines]
>
> - Show quoted text -

Ralph,

"The Ingres ODBC driver does not support repeated queries at the
present time. I recommend instead using SQLPrepare() and
SQLExecute(), as these provide even better improvements in performance
than repeated queries."

I´m using Powerbuilder 10.5 with ODBC and Ingres 2.6 Database, could
you tell me, how use this functions... Where can I get informantion
about that. I´m searching on google, but I can´t find too much.

tkz ! ;-)

Reply to this Message

Jonah H. Harris - 28 May 2008 22:49 GMT

> I´m using Powerbuilder 10.5 with ODBC and Ingres 2.6 Database, could
> you tell me, how use this functions... Where can I get informantion
> about that. I´m searching on google, but I can´t find too much.

While I haven't used PowerBuilder for quite awhile, you can forcibly
prepare and execute a statement using dynamic SQL.

INT empno = 7654
PREPARE SQLSA FROM "DELETE FROM emp WHERE empno = ?";
EXECUTE SQLSA USING :empno;

Last time I checked, PowerBuilder implicitly translated this to
SQLPrepare and SQLExecute for ODBC depending on the ODBC driver's
handling of SQL_CURSOR_ROLLBACK_BEHAVIOR and
SQL_CURSOR_COMMIT_BEHAVIOR (retrieved via SQLGetInfo).

Hope that helps.

-Jonah

Reply to this Message