| From: | "Pit M(dot)" <fmi-soft(at)gmx(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problems with PostgreSQL DBI-Link / DBD-ODBC |
| Date: | 2007-10-29 14:44:05 |
| Message-ID: | fg4rjg$1vp0$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2007-10-29 14:56:37 | Re: [HACKERS] WAL archiving idle database |
| Previous Message | davidrboyer | 2007-10-29 14:02:41 | postgresql in PHP |