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.3Creating 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
48
