Problems with PostgreSQL DBI-Link / DBD-ODBC - Mailing list pgsql-general

From Pit M.
Subject Problems with PostgreSQL DBI-Link / DBD-ODBC
Date
Msg-id fg4rjg$1vp0$1@news.hub.org
Whole thread Raw
Responses Re: Problems with PostgreSQL DBI-Link / DBD-ODBC  (David Fetter <david@fetter.org>)
List pgsql-general
I have the following problem with PostgreSQL and hope you guys can help
me out in this matter: I try to get a remote connection to any database
(e.g. MS-SQL or MS Access) using DBI-Link and DBD:ODBC. My problem is,
that everything seems fine so far, however I don't know how to use the
parameters for "make_accessor_functions()". I searched the net for it,
but can only find samples for Perl-Scripting, but I need a sample for
using it directly in SQL.

This is what I've come up so far. Hope you can point me to the right
direction.

SELECT make_accessor_functions(
     'dbi:ODBC:Northwind::dbi_link.data_source,
     'sa'::text,
     NULL::text,
     '---
AutoCommit: 1
RaiseError: 1
'::dbi_link.yaml,
     NULL::dbi_link.yaml,
     NULL::text,
     NULL, ::text,
     'Northwind'::text
);


I have a ODBC connection named "Northwind".

The error message I'm always receiving (for the MS-SQL sample) is:

ERROR: error from Perl function: error from Perl function: duplicate key
violates unique constraint "dbi_connection_data_source_key" at line 94.
at line 35.
SQL state: XX000

I'm using following components under Windows XP
postgresql-8.2.5-1
pgadmin3-1.8.0
DBI-1.59
dbi-link-2.0.0
DBD-ODBC-1.05

Thanks in advance.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: I want to search my project source code
Next
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] WAL archiving idle database