Re: Multi RDBMS queries...

Jeff Zucker wrote: $dbh->ad_import('fruit_name' ,'DBI',DBI->connect( $dsn{odbc} )); $dbh->ad_import('fruit_color','DBI',DBI->connect( $dsn{sqlite} )); I forgot to mention that if you pass SQL queries to the ad_import() calls, you can import only the rows and columns you are interested in, rathe

Re: Multi RDBMS queries...

Tim Howell wrote: Does anyone know of a module that allows queries to be executed across databases running on multiple RDBMSs? One option I've thought of is to do really simple parsing of the SQL, and then building a temporary DB in memory on one of the DBMSs, then running the query, unmodifi

Re: Passing complete SQL scripts thru DBI...

> From: amonotod <[EMAIL PROTECTED]> > Date: 2004/07/29 Thu PM 07:25:02 GMT > > So, I've got these heavy duty, complicated T|PL-sql > scripts, that I have to pass through to my DB, After doing some more Googling, I've come up with a question: Is this what DBI::Shell is for? Thanks, amonoto

Re: threads and caching of DBI-handels

> My Problem is, that my script starts the thread every 2 Minutes by the cron-module. > So I open at the moment every 2 Minutes a DBI-connection. This is not very nice for > the DB. > >>> If you are worried about the expense of connects to the database every two minutes, then perhaps the Perl

Passing complete SQL scripts thru DBI...

Howdy, So, I've got these heavy duty, complicated T|PL-sql scripts, that I have to pass through to my DB, after I finish populating it. They come complete with temporary tables, EXEC statements, stored procedure create/drop statements, select into's, nested cursors and procedures, you name, I

Multi RDBMS queries...

Does anyone know of a module that allows queries to be executed across databases running on multiple RDBMSs? It's not terribly elegant, but I have situations where I need to run a query that pulls information from a people table, and then grabs addresses and stuff either from MySQL or MSSQL Se

RE: Different types of prepare statements

Technically the question and answer is OT (off topic) because the difference has to do with Perl quoting features and is not specific to DBI. However, it does illustrate some techniques that can make the SQL passed to DBI calls more readable (IMHO) than when you use conventional quotes ("" or '').

Re: Re: DBD::ADO and TEXT datatypes

> From: "Steffen Goeldner" <[EMAIL PROTECTED]> > Date: 2004/07/29 Thu PM 02:38:34 GMT > > Sadly, I have no SQL Server to test with. Feel free to download and play with Microsoft Data Engine 2.0 (MSDE), which is, for all intents and puposes, Sql Server 2000. Or, get the 1.0 version, which is eq

RE: Oracle database link error - ppm upgrade problem

Tony, Go to http://metalink.oracle.com and look up this error there. - Ron Reidy Senior DBA Array BioPharma, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 10:06 AM To: Martin Hall Cc: [EMAIL PROTECTED] Subject: Re

Re: Oracle database link error - ppm upgrade problem

Hi All, Found the problem (for anyone interested!) I have two ORACLE_HOMEs on my PC perl was built against 8.1 and I have a 9.2.0.5 environment setup! Thanks Martin and Ron for you help, Regards Tony Hi Martin (& Ron), I should never have doubted you must be the pressure/heat/

Re: Oracle database link error - ppm upgrade problem

Tony Adolph o2 (Germany) GmbH & Co.OHG Georg Brauchle-Ring 23-25, D80992 München Tel +49 (0)89 2442 6167 Mobil +49 (0)179 509 0840 Fax +49 (0)89 2442 4162 This electronic message contains in

Re: Different types of prepare statements

My comments(HM>>) are below. Sorry for the poor message quoting - thanks to Groupwise on Windoze XP. >>> "Robert" <[EMAIL PROTECTED]> 07/29/04 11:51AM >>> I have seen: my $sth = $dbh->prepare( <> I've never used this method but there's no reason it shouldn't work. This uses what perl calls "Her

threads and caching of DBI-handels

Hello, I have a question, about ithreads and the DBI-module. I use threads in a perl-script which is a Monitor for an other Aplication, so my script runs as daemon and starts threads which connect to the DB collect some data and come back. My Problem is, that my script starts the thread every 2

Different types of prepare statements

I have seen: my $sth = $dbh->prepare( prepare(qq{ SELECT blah FROM blah WHERE blah = blah }); What is the difference? I am new to Perl/DBI stuff. Robert

Oracle database link error - ppm upgrade problem

Hi Ron, Thanks for the feedback, but the queries are only: select * from [EMAIL PROTECTED] and select object_name FROM [EMAIL PROTECTED] WHERE object_type ='SYNONYM' which obviously work from sqlplus, so that's why I suspect the DBI/DBD-Oracle. There are no alert logs errors,

Re: DBD::ADO and TEXT datatypes

Joaquin Perez wrote: > Hello, > > I have a table with a TEXT field with a size of 16. Theoretically it > could hold up to 2 gigs or something like that. > > I've done the following: > > $dbh->{LongReadLen} = 2 ** 20 + 8; > $dbh->{LongTruncOk} = 1; > $sth = $dbh->prepare(); > $sth->execute() Curre

RE: Oracle database link error - ppm upgrade problem

ORA-03113 is a generic type error. To start debugging this error, you need to look in the instance's alert log for the real issue (usually ORA-07445) and any trace files that may have been created. IMHO, upgrading DBI and DBD::Oracle is the wrong place to start. - Ron Reidy Sen

Re: DBD::ADO and TEXT datatypes

I have a table with a TEXT field with a size of 16. Theoretically it could hold up to 2 gigs or something like that. [...] Have you tried the same thing with a different driver? Say, DBD::ODBC? See recent previous posts by myself for a DSN-less ODBC connection string construct (probably stolen

Oracle database link error - ppm upgrade problem

Hi all, A couple of problems Firstly an ORA-03113: end-of-file on communication channel problem: - my perl script is running from a win2000 box using perl v5.8.0 built for MSWin32-x86-m