Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Informix and ODBC

121 views
Skip to first unread message

Colin Dawson

unread,
Jun 13, 2006, 11:12:24 AM6/13/06
to inform...@iiug.org
Apologies if this has been round before.

Does anyone know a way of setting PDQPRIORITY through an ODBC connection?
I've found a way to SET ISOLATION DIRTY READ by adding a line to the
informix.sdb file.

Regards

Colin

There are 10 types of people in the world, those that understand binary and
those that don't

_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://join.msn.com/messenger/overview

Reece

unread,
Jun 13, 2006, 12:47:00 PM6/13/06
to Colin Dawson, inform...@iiug.org
Hi,

I've been working with the Informix ODBC driver, and Informix in general,
for a few years... I'm not aware of an "informix.sdb" file. Can you let
me know what that is? Do you have some reference to it?

The only way I know of setting the PDQPRIORITY is to execute the SET
PDQPRIORITY <NUM> statement after connecting. The only way I know of to
change the isolation level was to execute the appropriate statement...

> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>

Superboer

unread,
Jun 14, 2006, 1:35:43 AM6/14/06
to
put it in an spl

Superboer.

Colin Dawson

unread,
Jun 14, 2006, 4:57:47 AM6/14/06
to inform...@iiug.org
Sorry, I had the filename wrong it should be informix.sbo and is located in
C:\Program Files\Business Objects\BusinessObjects Enterprise
6\dataAccess\RDBMS\connectionServer\informix. As you can see from the path
we use Business Objects and are currently testing upgrading to V6.5. We
cannot use Informix Connect as we use on the existing version because BO no
longer support this - it is ODBC or nothing. Executing SQL after connecting
is not an option. BO has a persistent connection to the DB and submits it's
reports through a scheduler so the initial connect needs to set the PDQ
level and the ISOLATION Level.

Contents of informix.sbo

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE DriverConfiguration SYSTEM
"../sbo.dtd"><DriverConfiguration>
<Defaults>
<Parameter Name="Family">Informix</Parameter>
<Parameter Name="SQL External File">informix</Parameter>
<Parameter Name="SQL Parameter File">informix</Parameter>
<Parameter Name="Description File">informix</Parameter>
<Parameter Name="Strategies File">informix</Parameter>
<Parameter Name="Driver Level">31</Parameter>
<Parameter Name="Array Fetch Available">True</Parameter>
<Parameter Name="Array Bind Available">False</Parameter>
<Parameter Name="Max Rows Available">True</Parameter>
<Parameter Name="Binary Slice Size">30000</Parameter>
<Parameter Name="CharSet Table">informix</Parameter>
<Parameter Name="Transaction Isolation Level">READ UNCOMMITTED</Parameter>
<Parameter Name="V5toV6DriverName">{Informix 3.34 32 BIT}</Parameter>
</Defaults>
<DataBases>
<DataBase Active="Yes" Name="Informix Dynamic Server 2000">
<Aliases>
<!-- You can add an alias here if you are using some connections that
are defined with an older database engine -->
<Alias>Informix SE 7.2</Alias>
</Aliases>
</DataBase>
<DataBase Active="Yes" Name="Informix Dynamic Server 7.3">
<Parameter Name="DescribeParam Available">False</Parameter>
</DataBase>
<DataBase Active="Yes" Name="Informix XPS 8.3">
<Parameter Name="DescribeParam Available">False</Parameter>
</DataBase>
<DataBase Active="Yes" Name="Informix XPS 8.4">
<Parameter Name="DescribeParam Available">False</Parameter>
</DataBase>
<DataBase Active="Yes" Name="Informix XPS 8.5">
<Parameter Name="DescribeParam Available">False</Parameter>
</DataBase>
</DataBases>
</DriverConfiguration>

Regards

Colin

There are 10 types of people in the world, those that understand binary and
those that don't

Sheshnarayan Agrawal

unread,
Jun 14, 2006, 5:45:23 AM6/14/06
to Colin Dawson, informix-l...@iiug.org, inform...@iiug.org

Hi Colin,

Related to Isolation level recently ODBC fixed one defect 176910. Which will now allow Isolation level to be set by either in DSN or as a part of connection string itself. So here you don't have to run the SQL query to set the isolation level after your connection is established. I would suggest to touch base with your IBM Informix Tech Support to get the patch for 176910 if you think this will solve your problem. Alternatively, you can also call SQLSetConnectAttr (for more information refer MSDN) with appropriate value for Isolation Level. You can use this API before/after your connect call.

Hope this helps ..

Thanks & Regards
-Shesh


"Colin Dawson" <cjd_...@hotmail.com>
Sent by: informix-l...@iiug.org

06/14/2006 02:27 PM

To
inform...@iiug.org
cc

Superboer

unread,
Jun 14, 2006, 7:55:06 AM6/14/06
to
Hello Colin,

if you are not on xps (use sysdbopen) then go and nag to IBM/Informix
in order to get sysdbopen implemented on V10latest.
i guess it is way overdue if it is not in there.

sysdbopen allows you to execute sql when connecting to the db. check it
out
way cool.

Superboer


Colin Dawson schreef:

Gary Quiring

unread,
Jun 16, 2006, 11:14:13 AM6/16/06
to

Has anyone been able do dirty reads using MS Access with the 2.9TC4
ODBC drivers? If so how?

Thanks
Gary Quiring

Sheshnarayan Agrawal

unread,
Jun 19, 2006, 2:29:02 AM6/19/06
to Gary Quiring, informix-l...@iiug.org, inform...@iiug.org

After 2.90.TC4/TC5 (yet to release), isolation level setting can be performed as a part of DSN itself. If you are looking for immediate solution kindly touch base with your IBM Informix Tech Support to get the patch for bug number 176910.

Thanks & Regards
-Shesh


"Gary Quiring" <gqui...@gmail.com>
Sent by: informix-l...@iiug.org

06/16/2006 08:44 PM

To
inform...@iiug.org
cc

Subject
Re: Informix and ODBC
0 new messages