Oninit cdi / Archive
Talk to an expert →

Re: Retrieving from 2 different databases via a single perl DBI::ODBC connection

Posted in 2006

Topics: Connectivity: ODBC / JDBC / .NET

bozon — — source: Usenet: comp.databases.informix

I wonder if you need to use the ODBC way to specify a database table. Is this database.table ?

↪ replying to bozon
Niall Macpherson — — source: Usenet: comp.databases.informix

bozon wrote: > I wonder if you need to use the ODBC way to specify a database table. > Is this database.table ? Thanks for ther suggestion bozon. I tried using the dot, but still got an error (albeit a different one from before) it looks like this is being interepreted as 'owner.tablename' rather than 'database.tablename'; H:\\Perl Scripts>ifxtest_remotedb.pl DBD::ODBC::db prepare failed: [Informix][Informix ODBC Driver][Informix]The spec ified table (sysmaster.syschunks) is not in the database. (SQL-07009)(DBD: st_pr epare/SQLPrepare err=-1) at H:\\Perl Scripts\\ifxtest_synonym.pl line 10.

↪ replying to Niall Macpherson
try_and_err@web.de — — source: Usenet: comp.databases.informix

When you would absolutely use DBD::ODBC: Use a second connection (for sysmaster). When you would use perl and would have only one connection: Use WIN32::ODBC or DBD::Informix, both have no problems with the syntax 'database:table'. Or use the suggested synonym/dbaccess way. Regards, try_and_err

Related threads