Before I forget, if any other newbie face the same problem, the source
for building the db2 driver is here:
http://www-01.ibm.com/support/docview.wss?uid=swg21385217
its inside the IBM Data Server Driver Package (DS Driver)
I think it should be inside the IBM Data Server Driver for ODBC and CLI
Hello out there,
Im trying to build a DBI driver for DB2. I followed this site:
http://www-01.ibm.com/support/docview.wss?rs=71uid=swg21297335
As well as setting the envarc DB2_HOME ...
But if I envoke make I get this error: sqlcli.h: No such file or directory.
Where can I get it?
Thank you
Hello out there,
I just want to ask if there is any solution for Adabas or Tamino and DBI?
As it seems, there is no driver for these systems available?
Gruss Christian
--
Feel free mit GMX FreeMail!
Monat für Monat 10 FreeSMS inklusive! http://www.gmx.net
http://www.google.com/search?q=DBD::Adabas returns the CPAN page for
DBD::Adabas as *FIRST* result
Ok Im blind ;-)
http://www.google.com/search?q=DBD::Tamino has only one result, stating
that there seems to be non DBD::Tamino
But this leads to an empty page!
Back to the problem with my plpgsql-procedures. I have another problem with
another procedure, with even more aguments:
$arg1 = $cookieValue . ::numeric;
$arg2 = $ueberschrift . ::text;
$arg3 = $beschreibung . ::text;
$arg4 = $system_zeit . ::timestamp;
$arg5 = 2001-11-11 11:11:11 . ::timestamp;
Christian,
As an example, I'd do the following:
$arg1 = $cookieValue . ::numeric;
...
$result = $dbh-prepare ( insert into kunden ( kid, nachname, ..., )
values ( ?, ?, ... ) );
$sqls-bind_param(1, $user_nummer);
$sqls-bind_param(2, $nachname);
...
$sqls-execute();
Christian,
As an example, I'd do the following:
$arg1 = $cookieValue . ::numeric;
...
$result = $dbh-prepare ( insert into kunden ( kid, nachname, ..., )
values ( ?, ?, ... ) );
$sqls-bind_param(1, $user_nummer);
$sqls-bind_param(2, $nachname);
...
$sqls-execute();
ah I see, in my case is it $result:
$result = $dbh-prepare ( SELECT neue_auktion ( ?, ?, ?, ?, ?, ?, ?, ? )
) or die Vorbereitung nicht durchfuehrbar!\n;
$result-bind_param ( 1, $arg1 );
$result-bind_param ( 2, $arg2 );
$result-bind_param ( 3, $arg3 );
$result-bind_param ( 4, $arg4 );
Halo Christian,
$sqls is the object returned by the prepare() method, as in:
my $sqls = $dbh-prepare( insert into table $table ( userNumber,
lastName) values ( ?, ?) );
$sqls-bind_param(1, $user_nummer);
$sqls-bind_param(2, $nachname);
but, if i understand your last message
Based on what you have here, this will bind all of the arg variables
with the respective 'positional' ?s I'd even venture to say, you can
put a little loop on a single bind_param( $i, $arg$i ); where your:
i = index counter # haven't tried that yet, but think it would work.
Thats
Ja Christian,
Ich verstehe ein bischen Deutsch, besonders startzeit :) Ich habe ein
buch ueber des Lebens Albert Schweizer gelesen, so ich kann 'basic'
Duetsch verstehen.
Wow, not bad. And you learned it just with this one book?
From one of the earlier emails I saw, your variable
Bitte kannst du das probieren fuer spass? ( English: Could you just
try this for fun :)
$arg5 = \'2001-11-11 11:11:11\' . ::timestamp;
Was werde denn passiert? (what would happen then? )
The same effect,
this is the dump on the website:
Software error:
[quote]
Abfrage nicht
See if this works:
my $sth = $dbh-prepare(EndOfSQL);
SELECT neue_auktion ( ?, ?::text, ?::text,
?::timestamp, ?::timestamp,
?, ?, ? )
EndOfSQL
$sth-execute($cookieValue, $ueberschrift, $beschreibung,
$system_zeit,
That the way:
$arg1 = $cookieValue;
$arg2 = $dbh-quote ( $ueberschrift );
$arg3 = $dbh-quote ( $beschreibung );
$arg4 = $system_zeit;
$arg5 = 2001-11-11 11:11:11;
$arg6 = $startpreis;
$arg7 = $startpreis;
$arg8 = $kategorie_nummer;
$result = $dbh-prepare ( SELECT neue_auktion ( ?, ?::text,
my $sth = $dbh-prepare(EndOfSQL);
SELECT neue_auktion ( ?, ?::text, ?::text,
?::timestamp, ?::timestamp,
?, ?, ? )
EndOfSQL
$sth-execute($cookieValue, $ueberschrift, $beschreibung,
$system_zeit, 2001-11-11 11:11:11,
I'm glad it worked.
However I'm still concerned with why you need the nonportable form of
??::text etc.
Is this because you are running a user defined function which has no
schema associated with it the way a regular table or view would?
Is there some way to make it more portable,
Vielen Glueck mit ihren Aufgabe an der Uni.
-Will
8O Who else speaks german on this list ;-) This is really funny. :-)
And this is my university
[url]http://fh-web1.informatik.fh-wiesbaden.de/go.cfm/fb/6/sprachid/2/lpid/0/sid/0.html[/url]
Other question, has anybody experences with
Hello out there,
I just try to call a PostgreSQL-function via the DBI.
The function is very simple:
CREATE OR REPLACE FUNCTION neues_suchprofil ( NUMERIC, TEXT ) RETURNS void
AS $$
BEGIN
INSERT INTO suchprofile ( kid, spname ) VALUES ( $1, $2 );
END
$$ LANGUAGE plpgsql;
It is as you can see
Thank you Greg,
I allready solf it. First I changed the code this way:
my $arg1 = $cookieValue . ::numeric;
my $arg2 = $suchprofil_name . ::text;
$result = $dbh-prepare ( SELECT neues_suchprofil ( $arg1, '$arg2' ) ) or
die Vorbereitung nicht durchfuehrbar!\n;
$result-execute() or die Abfrage
Thank you Greg,
I allready solf it. First I changed the code this way:
my $arg1 = $cookieValue . ::numeric;
my $arg2 = $suchprofil_name . ::text;
$result = $dbh-prepare ( SELECT neues_suchprofil ( $arg1, '$arg2' ) )
or
die Vorbereitung nicht durchfuehrbar!\n;
$result-execute() or die
Dear Lois,
thank you for your help.
And sorry for forgotten my pg_hba.conf, that is really important.
Here it comes:
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
---
Von: Louis Gonzales [EMAIL PROTECTED]
An: Christian Stalp [EMAIL PROTECTED]
Betreff: Re: PostgreSQL trouble
Datum: Mon, 23 Jan 2006 11:04:35 -0500
Have you tried adding ( dbname=test;*host= ) where host = either
127.0.0.1 OR localhost*
just try that before you go any further
what command are you using to start up postgreSQL?
Oh yes, this is an entry-script in init.d:
#!/bin/bash
. /usr/share/postgresql-common/init.d-functions
VERSION=8.1
case $1 in
start)
start $VERSION
;;
stop)
stop $VERSION
;;
restart)
I tried this:
my $dbh = DBI-connect(dbi:Pg:database=test2;host=127.0.01;port=5432,
postgres) or die $DBI:errstr;
test2 is the name of the database.
and got this:
Global symbol $DBI requires explicit package name at ./postgre_test_1.pl
line12.
syntax error at ./postgre_test_1.pl line 12, near
The whole script:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, postgres, sonderbar)
#my $dbh = DBI-connect (DBI:Pg:dbname=test2, *host=localhost )
# or die Keine Verbindung mit der DB!\n;
my $dbh =
Christian,
what is the result of this:
netstat -an | grep 5432
nothing ;-) The server does not here on the net. But with pure DBI, can i
do it without IP? For the first connection I mean? I mean with an
UNIX-Socket or however DBI connects to a local server?
Gruss Christian
--
Have you got
tcpip_socket = true
in postgresql.conf?
Yea, exactly. This is funny. I allready tried this. See:
venus:/home/chris# pg_ctlcluster 8.1 main restart
The PostgreSQL server failed to start. Please check the log output:
FATAL: unbekannter Konfigurationsparameter »tcpip_connections«
Christian
--- Ursprüngliche Nachricht ---
Von: Louis Gonzales [EMAIL PROTECTED]
An: Louis Gonzales [EMAIL PROTECTED]
Kopie: Christian Stalp [EMAIL PROTECTED], dbi-users@perl.org
Betreff: Re: PostgreSQL trouble
Datum: Mon, 23 Jan 2006 13:28:00 -0500
Christian,
THIS WILL WORK:
my $dbh = DBI
Hello,
I have some trouble connecting my PostgreSQL-Server.
When I execute this small script:
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
my $dbh = DBI-connect (DBI:Pg:dbname=test2, postgres, wunderbar)
or die Keine Verbindung mit der DB!\n;
exit;
I get this error:
DBI
anybody know what the problem is, and is there a possibility to install
DBI whitout connection to ActiveState?
Gruß,
Ming
--
Christian Stalp
Institut für Medizinische Biometrie, Epidemiologie und Informatik
Johannes-Gutenberg-Universität Mainz
Tel.: 06131 / 17-3107
E-Mail: [EMAIL PROTECTED]
Hello,
Im involved in a project to setup a tamino -XML-Database for the web. My
problem is now, that I cannot find any Tamino-Driver for DBI. Is there any
workarround or solution I can use for this?
Gruss Christian
--
Christian Stalp
Institut für Medizinische Biometrie, Epidemiologie und
no
documentaion here and SoftwareAG is not responding to my questions. :-(
Can you give me an example how to connect to the database via the UnixODBC?
$dbh = DBI-connect ( ? )
Thank you very much.
Gruss Christian
--
Christian Stalp
Institut für Medizinische Biometrie, Epidemiologie
Hello there,
one brief question: needs UnixODBC the DBI or is it totally indipendent?
Gruss Christian
--
Christian Stalp
Institut für Medizinische Biometrie, Epidemiologie und Informatik (IMBEI)
Obere Zahlbacher Straße 69
55131 Mainz
Tel.: 06131/ 17-6852
E-Mail: [EMAIL PROTECTED]
Internet
-0.32/UnixODBC.pm
And so I ask, is there a way to combine these?
Gruss Christian
--
Christian Stalp
Institut für Medizinische Biometrie, Epidemiologie und Informatik (IMBEI)
Obere Zahlbacher Straße 69
55131 Mainz
Tel.: 06131/ 17-6852
E-Mail: [EMAIL PROTECTED]
Internet: www.imbei.de
++, $_ for @INC'
0 /usr/local/lib/perl5/5.8.3/PA-RISC2.0
1 /usr/local/lib/perl5/5.8.3
2 /usr/local/lib/perl5/site_perl/5.8.3/PA-RISC2.0
3 /usr/local/lib/perl5/site_perl/5.8.3
4 /usr/local/lib/perl5/site_perl
5 .
Why perl don't except the module?
Gruss Christian
--
Christian Stalp
Institut für
Hello again,
I still have the problem to build a ODBC-Driver for Adabas.
I got a last chance to manage it with perl, next week I have to do it with c.
Im sure this has something to do with the bad installation of Adabas, but the
person who made this, is no longer available. So I have to fix it.
no type or storage class )
FAR is a hangover of 16bit times, and my gcc don't know it.
Do I have to hack it manualy into the code, or should I include another
header which visualise this type?
Is this somethink for the [EMAIL PROTECTED] - list?
Gruss Christian Stalp
I'm still hanging at my Adabas-Driver problem. Because nobody can help so
far, I try it step by step.
First I wonder about the message:
Multiple copies of Driver.xst found in:
/usr/local/lib/perl5/5.8.3/PA-RISC2.0/auto/DBI
/usr/local/lib/perl5/site_perl/5.8.3/PA-RISC2.0/auto/DBI at
Subject: Re: Fwd: dbi:Adabas
Date: Tue, 3 Aug 2004 13:42:24 +0200
From: Christian Stalp [EMAIL PROTECTED]
To: Jonathan Leffler [EMAIL PROTECTED]
I still have a problem with my DBD:Adabas-Module
Sorry, I don't think I can help -- I don't see what the trouble is.
I would suggest upgrading from
I still have a problem with my DBD:Adabas-Module
Sorry, I don't think I can help -- I don't see what the trouble is.
I would suggest upgrading from DBI 1.38, but I'm not convinced that's
a critical part of the problem.
Is there anybody else, who can help me? I now tryed to install the
Going back to my problem with DBI:Adabas
Now I rebuild the DBI-Module again and found some failures while testing.
I put the whole dump into the small_output.txt and the perl -v into the
perl-v.txt -file.
Is it possible that the problem caused by the fact, that I installed another
I still have a problem with my DBD:Adabas-Module
Versions:
Perl v5.8.3 built for HPUX-10.20
DBI v1.38
DBD:Adabas-0.2003
And I have forgotten to write about the problems while building the
Adabas-Driver:
I tryed as usual with:
blockquote
# perl Makefile.PL
/blockquote
And I gut this
I still have a problem with my DBD:Adabas-Module
Versions:
Perl v5.8.3 built for HPUX-10.20
DBI v1.38
DBD:Adabas-0.2003
my script:
#!/usr/local/bin/perl -w
use DBI;
print Test\n;
my $user = somebody;
my $password = anything;
my $data_source = dbi:Adabas:refdb; # TBD
$dbh = DBI-connect (
Am Mittwoch, 16. Juni 2004 16:22 schrieben Sie:
Christian Stalp wrote:
Which posibilities I have to call an Adabas Database via DBI. There is a
driver for Adabas in the CPAN? But which this driver consists of? Is it
only another perl-module or a shared-lib? And why it is so difficult
Which posibilities I have to call an Adabas Database via DBI. There is a
driver for Adabas in the CPAN? But which this driver consists of? Is it only
another perl-module or a shared-lib? And why it is so difficult to install
this driver?
Gruss Christian
45 matches
Mail list logo