Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 48)

48
9.6 Client applications
9.6.1 ODBC AutoPreCommit omitted
The ODBC AutoPreCommit option was omitted from the Adaptive Server IQ
Reference. Turning this option ON causes each statement to do a COMMIT
before execution (as opposed to a COMMIT after execution for the
AutoCommit option). The default for AutoPreCommit is OFF.
Set the AutoPreCommit option in either the Windows (NT/95) registry or the
.ini file (Windows 3.1). For example:
[Sample DSN]
UID=DBA
PWD=SQL
AutoPreCommmit=y
9.6.2 Using PC client applications
The following notes apply to PC client applications certified with Adaptive
Server IQ:
• With BrioQuery, each query requires you to connect to the database. Be
sure to close the query after processing to ensure that the connection to
Adaptive Server IQ is closed. If you leave multiple queries open, you
could consume more connections than you realize, eventually preventing
other users from connecting to Adaptive Server IQ (since the number of
configured connections would be exceeded).
• With Business Objects, you should change Password_Encryption = 1 to
Password_Encryption = 0.
9.6.3 Creating attribute tables for PowerBuilder
In order to create attribute tables for PowerBuilder properly, you need to run
the iqpb.sql script located in the Server directory on the PowerBuilder product
CD against Sybase Adaptive Server IQ v.12.0.x using the provided Adaptive
Server IQ ODBC driver. Earlier versions of PowerBuilder (6.5 and below) do
not include the script. In this case, you may obtain the script from the Sybase
FTP website. Contact your PowerBuilder support representative if you need
additional information or PowerBuilder 7.0.
9.7 Help files