Re: Problems with PostgreSQL DBI-Link / DBD-ODBC

Hi David,

I'm sorry to bother you again, but I still couldn't get it to work. Like
you suggested, I checked for successfully installed schemas. There was
one, which I deleted again because I don't know which of my countless
tries to create it was the successful one. I think the following code
should be alright, however when executing it, I receive the following
error message:
"ERROR: error from Perl function: error from Perl function:
DBD::ODBC::db column_info failed: [Microsoft][ODBC SQL Server Driver]Die
Verbindung ist mit Ergebnissen von einem anderen hstmt belegt
(SQL-HY000)(DBD: odbc_columns/SQLColumns err=-1) at line 66. at line 53.
SQL state: XX000"

"Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt" is
German and means "The connection is occupied/reserved with results from
another hstmt". I'm desperately trying to solve it, but have no idea
where to start.

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

Hope you can help me one more time. Thanks.

Regards,

Pit

> On Tue, Oct 30, 2007 at 01:12:41PM +0100, Pit M. wrote:
>> Hi David!
>>
>> Thanks for the fast reply. So you mean that I might already have
>> created a connection but am still trying to create the same one
>> again?
>
> Yes.
>
>>>> Check whether the existing one works :)
>> So how can I test it?
>
> Fire up psql and do:
>
> SELECT
> data_source_id,
> local_schema,
> data_source
> FROM
> dbi_link.dbi_conection;
>
> This gives you schemas you have created successfully. You can then
> check what's in schema foo by doing:
>
> \dv foo.*
>
>> What is the correct way of accessing this data source in a select
>> statement?
>>
>> Concerning the documents, I wouldn't say that they are unclear about
>> make_accessor_functions(). The problem is, that in the dbi-link
>> documents (quote: "Do the following, with the appropriate
>> parameters. "Appropriate parameters" come from the perldoc of the
>> appropriate DBD...") and in the dbi-odbc documents I can't find any
>> information about the correct use of the parameters for the
>> ODBC-connection. That's why I tried to create the connection so many
>> times.
>
> Ah, I see. I don't have an example of dbd-odbc just yet, but you
> should be able to write a very short perl program which connects to
> your data source.
>
> http://www.easysoft.com/developer/languages/perl/dbd_odbc_tutorial_part_1.html
>
> Once you've verified that that's working, you can set up a new
> connection. The parameters you pass into $dbh coincide, not
> coincidentally, with the first inputs to make_accessor_functions :)
>
> Cheers,
> David.