I am attempting to follow
http://www.iiug.org/techinfo/linux/Howto_DBD.html. I seem to have
stumbled through a successfull installation. I am now attempting to run
the dbitest1.pl which is embedded in the Howto. It seems that I am
talking to the DBMS because I get a message that looks to be generated
by Informix when I try to establish a connection to the data source.
The perl script returns the following:
"Engine replied: SQL: -329: Database not found or no system permission.
ISAM: -2: No such file or directory"
It seems this is comming from the lines in the perl script:
my $dbh=DBI->connect('dbi:Informix:stores', '', '');
if ($DBI::err)
{
print "Engine replied: $DBI::errstr\n</BODY></HTML>";
exit;
}
I am running the "dbaccessdemo7 stores", and I have the following
environment variables set:
bash-2.02# env | grep INFO
INFORMIXSERVER=demo_se
DBD_INFORMIX_DATABASE=stores
INFORMIXDIR=/usr/lib/informix
INFOPATH=/usr/local/info:/usr/info
INFODIR=/usr/local/info:/usr/info
bash-2.02#
bash-2.02# env | grep DBPATH
DBPATH=/usr/lib/informix/bin
bash-2.02#
When I actually go into dbaccess and connect to that database I see it
called "stores7@demo_se". I tried replacing "stores" with that in the
script and got exactly the same result.
Sinice I am a complete newbie to perl, DBI, DBD, and for the most part
Informix, I am very lost. Could someone please give me a point in the
right direction. How do I define/access my data source?
TIA,
Steve
--
http://counter.li.org -User # 79059 | I think.
http://www.suse.com | I think I am.
http://www.kde.org | Therefore I am.
http://samba.anu.edu.au | I think? - Moody Blues
-
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
