Re: I think I need a DB with no shared memory

Bren, I haven't used DBD::Informix, but the error and readme file look alot like an esqlc application I have used which required a tcp connection instead of shared memory. From your sqlhosts file, it looks like you may have a tcp connection available. Check your onconfig file for a DBSERVERALIASES tli_on reference. And check your services file for a line that looks something like cracker_on 1526/tcp If you have these, try changing INFORMIXSERVER=tli_on and rerun the process. HTH, Dave Griffen "dimonex" <dimonex.news.invalid@web2news.net> wrote in message news:47083N395@web2news.com... > Whilst installing DBD::Informix, I encountered the following problem > > > bash-2.03# esql -o esqlbasic esqlbasic.ec > bash-2.03# ./esqlbasic > $DBI_DBNAME unset - defaulting to 'stores'. > $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'. > Testing connection to stores > > SQL: -25588: The appl process cannot connect to the database server > shm_on. > ISAM: 4: Interrupted system call > > You cannot use stores as a test database. > You do not have sufficient privileges. > SQL: -25588: The appl process cannot connect to the database server > shm_on. > ISAM: 4: Interrupted system call > > > *** Your Informix environment is not usable > *** You must fix it before building or testing DBD::Informix > > > > The following is in the README under 'what I need'. > > A 'stores' database to which you can connect without specifying username > or password and in which you can create tables. Ideally, the connection > should not use shared memory (neither olipcshm nor onipcshm), and you > should have DBA privileges in the database. > > I believe that the problem lies here as stores is created on shm_on. > The following is what is in the /apps/informix/etc/sqlhosts file > > demo_on onipcshm on_hostname on_servername> demo_se seipcpip se_hostname sqlexec > shm_on onipcshm cracker cracker_shm > tli_on ontlitcp cracker cracker_on> > > > Am I doing something wrong here?? > > Thanks, > > Bren, > > Dimonex Technologies > -- > Direct access to this group with http://web2news.com > http://web2news.com/?comp.databases.informix