I am trying to use DBD::Informix to query a remote database.

I am connected to a local database and then issuing a remote sql query:

select * from perf_info@roushprod:archive_info

roushprod is in the sqlhosts file.  The statement works correctly outside of the 
DBD/DBI functions.

When I try to run the statement from perl, I get the following error:

DBD::Informix::db prepare failed:  SQL:  -569: Cannot reference an external database 
with logging.  at test.old line 18.

How can I correct this problem?

Thanks,

Craig A. Sharp
Unix Systems Administrator
DNS Administrator
Roush Industries
Office: 734-779-7282
Cell: 734-231-6769
Fax: 734-779-7807
[EMAIL PROTECTED]
====================================================
I have not lost my mind, it's backed up on tape somewhere!
====================================================

Reply via email to