Problems with PostgreSQL DBI-Link / DBD-ODBC
От | Pit M. |
---|---|
Тема | Problems with PostgreSQL DBI-Link / DBD-ODBC |
Дата | |
Msg-id | fg4rjg$1vp0$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: Problems with PostgreSQL DBI-Link / DBD-ODBC
|
Список | 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 по дате отправления: