Re: Informix and ODBC
- From: "Superboer" <superboer7@xxxxxxxxxxx>
- Date: 14 Jun 2006 04:55:06 -0700
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:
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
From: "Reece" <informix@xxxxxxxxxxxxxxxx>
To: "Colin Dawson" <cjd_1955@xxxxxxxxxxx>,<informix-list@xxxxxxxx>
Subject: Re: Informix and ODBC
Date: Tue, 13 Jun 2006 11:47:00 -0500
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...
----- Original Message ----- From: "Colin Dawson" <cjd_1955@xxxxxxxxxxx>
To: <informix-list@xxxxxxxx>
Sent: Tuesday, June 13, 2006 10:12 AM
Subject: Informix and ODBC
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
_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://join.msn.com/messenger/overview
.
- Follow-Ups:
- Re: Informix and ODBC
- From: Gary Quiring
- Re: Informix and ODBC
- References:
- Re: Informix and ODBC
- From: Colin Dawson
- Re: Informix and ODBC
- Prev by Date: Re: alter fragment question
- Next by Date: Re: alter fragment question
- Previous by thread: Re: Informix and ODBC
- Next by thread: Re: Informix and ODBC
- Index(es):
Relevant Pages
|
