FYI:
This came off the DBI users group. I hope someone can make use of it.
On Mon, 08 Mar 1999, Jonathan Leffler wrote: >Steven T. Hatton wrote: >> [snip big long plea for help] How do I define/access my data source? >SE has a couple of syntaxes for connecting to the database, and they >aren't very similar to the OnLine (IDS) equivalent notations. The >DBD::Informix manuals cater rather more to the IDS case than to the >SE case, but I guess I need to fix that, too, given that SE was put >onto Linux... > I asure you I carry no bagage from past knowledge of OnLine! >Note 1: DBD_INFORMIX_DATABASE is only relevant while testing >DBD::Informix; once you've finished testing and installed the >product, it is no longer used (unless you choose to use it). Gone. > >Note 2: It is a little unusual to place Informix software under >/usr/lib/informix. Not wrong, just unusual. /usr/informix is the >default value assumed if $INFORMIXDIR is not set; /opt/informix >or /home/informix are both reasonable alternatives. I'll let the wonderful folks at SuSE know this. I agree, I'd use /opt/informix, or /usr/local/informix, etc. > >Note 3: DBPATH is used to list places where databases can be >found. With SE, the database is stored in a directory with the >name "dbname.dbs". DBPATH should be set to point to the directory >containing the "dbname.dbs" directory. That place should *not* be >$INFORMIXDIR/bin. I just used what was there. I don't remember all the details of the installation, but I don't think that was my idea. I modified the DBPATH to /usr/lib/informix and there is DATA! Thanks. > >Note 4: Given that you've set $INFORMIXSERVER, you should be able >to connect using the notation: > >$dbh = DBI->connect("dbi:Informix:/where/ever/stores"); > >or > >$dbh = DBI->connect("dbi:Informix://demo_se/where/ever/stores"); > No joy here. Not sure what was going on, but I kept getting server errors. I may revisit this latter. For now there is data! >To connect without the pathname, you have to be in the same directory >as the database, or the database directory must be on DBPATH. > >-- >Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) >Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN >#include <disclaimer.h> Thanks again, 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
