Hallo there,
I really need help on this issue.
I have a perl script in which I connect to MaxDB succesfully.
Then I copy-and-paste the code to make a cgi script and it just fails. I
got an -10709 error.
I tried everything and nothing works. I could nottice (through Google)
that this error is/was common on php scripts.
Is it a common or usual error in cgi scripts?
Am I missing an environmental variable in the cgi-session which is present
in a shell session? if so, which one is it?
Have I got to change the permissions to any directory?
Is necessary any 'configuration' to SQLDBC?
My code (script):
#!/usr/bin/perl
use strict;
use DBI;
my $dbh = DBI->connect('dbi:MaxDB:123.231.132.213/TESTDB', 'USER',
'PASSWORD,
{ RaiseError => 0, AutoCommit => 0 })
or die 'Can\'t conenct: ', $DBI::err, ': ', $DBI::errstr, "\n";
print STDOUT "Connected to database'\n";
$rc = $dbh->disconnect();
print STDOUT "\n";
The output:
Connected to database
My code (CGI-script):
#!/usr/bin/perl
use DBI;
my $err
my $dbh = DBI->connect('dbi:MaxDB:123.231.132.213/TESTDB', 'USER',
'PASSWORD,
{ RaiseError => 0, AutoCommit => 0 }) or
$err = "Can't connect: " . $DBI::err . ": " . $DBI::errstr .
"\n";
...
The output is just nothing; in my httpd.log I can see:
[Wed Mar 29 15:23:20 2006] null: DBI connect('123.231.132.213/TESTDB',
'USER',...) failed: Connection failed (RTE:[EMAIL PROTECTED]) at
/var/apache/test/dbtest.pl line 4
I am working with:
Linux /Suse,
perl : This is perl, v5.8.5 built for i586-linux-thread-multi
sqldbc: SQLDBC / Linux / 32 bit/ i386 / v7.6.00.16
DBD-MaxDB: v. 7.6.00.16
DBI: 1.50
I also tried already installing Apache::DBI but still nothing.
I really need help since yesterday!
Regards,
Neidisch
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
