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=71&uid=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
/ch
> 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!
> http://search.cpan.org/
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
> 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 PL
> 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 porta
>
> my $sth = $dbh->prepare(<<"EndOfSQL");
> SELECT neue_auktion ( ?, ?::text, ?::text,
> ?::timestamp, ?::timestamp,
> ?, ?, ? )
> EndOfSQL
>
> $sth->execute($cookieValue, $ueberschrift, $beschreibung,
> $system_zeit, "2001-11-11 1
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, ?
> See if this works:
>
> my $sth = $dbh->prepare(<<"EndOfSQL");
> SELECT neue_auktion ( ?, ?::text, ?::text,
> ?::timestamp, ?::timestamp,
> ?, ?, ? )
> EndOfSQL
>
> $sth->execute($cookieValue, $ueberschrift, $beschreibung,
> $syste
> 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 nich
> 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 variab
> 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.
> 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 me
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 );
$re
> >
> 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);
> ...
>
> $sq
> 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->
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" . "::t
> 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-
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 "
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 ma
Hello out there,
has anybody experience with the DBD-PgSPI-Modul (also know as APILOS ) of
Alex Pilosov? Its a Modul not for access the database from outside the
server via DBI but from inside the server with PLperl-Funktions.
The question now is, how to import such a module in to the server?
Than
> --- 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
>
Gruss 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:
> 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_connection
> 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
--
Telefoni
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 = DBI->connect("dbi:Pg:database=
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, ne
> 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)
T 2006 i686 GNU/Linux
Gruss Christian
> --- Ursprüngliche Nachricht ---
> 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=&q
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
#
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 conne
ror)
Does 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
d of it. I have virtually 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
Institu
[imserv03]/home/STALP > perl -e 'printf "%d %s\n", $i++, $_ 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 do
also a perl-Module.
http://search.cpan.org/~rkies/UnixODBC-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
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
on has
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
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.
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 Makefile.PL
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 w
> >
> >>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
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
perl-Version
> 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:
# perl Makefile.PL
And I gut this dumped:
Configuring
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->connec
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 w
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
47 matches
Mail list logo
