Syntax for attributes when connecting



I'm connecting to a database using the DBI::ODBC interface. (Specifically,
I'm connecting to a Progress v9.1e running on SuSE Linux using the Merant
ODBC driver).

When opening the database handle, I know that I need to set what Progress
calls the "transaction isolation level", which sets the levels that the
SQL standard refers to as 'dirty read', etc.

And I know that I need to use the SQLSetConnectAttr to do this.

But I have yet to find an example of the syntax to use in the connection
string. Can someone help? I presume it will be something like:

$attribute_ref = { 'RaiseError' => 1,
'SQLSetConnectAttr' => '??????',
};

Many thanks in advance.

Regards, Sam Carmalt

Relevant Pages

  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • RE: Problem with connecting to an Oracle database using Perl
    ... Problem with connecting to an Oracle database using Perl ... *IS* described in the DBD::Oracle perldocs - as the perldocs are included ... I do not have a problem connecting to the remote database using the Oracle ...
    (perl.dbi.users)
  • Re: Running SQL script through VB
    ... I am connecting through a default username and my ... The error I am getting while running a script (generated by SQL server ... "A use database statement is not allowed in a procedure or trigger" ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Compact Framework 2.0 to Sql Server 2000 -- cant Open() connectio
    ... I tried connecting to a different data source on another machine: ... datasource, again using a \IERP to get to the correct database, and it failed. ... > I have XP SP 2 on the machine w/ the sql server, ...
    (microsoft.public.dotnet.framework.compactframework)