perl.dbi.users...Re: rt.cpan.org 36395 by Bart Lateur- June 25, 2008 On Wed, 25 Jun 2008 03:12:42 -0400, ronsavage.net.au via RT wrote:> Queue: DBI> Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >>>Hi Tim>>On Tue, 2008-06-24 at 17:17 -0400, Tim_Bunce via RT wrote:>> Queue: DBI>> Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >>> >> The DBI is acting as defined. It&39;s not a bug.>> You should avoid using an array to pass arguments to execute().>>I can&39;t image why I...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33017.html rt.cpan.org 37092 Bogus RT e-mail updates by adrianhquietstars.com via RT- June 25, 2008 Wed Jun 25 12:31:40 2008: Request 37092 was acted upon.Transaction: Ticket created by adrianhquietstars.com Queue: DBI Subject: Bogus RT e-mail updates Broken in: (no value) Severity: (no value) Owner: Nobody Requestors: adrianhquietstars.com Status: new Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=37092 >I too am getting RT updates on something that (to the best of my knowledge) I have nothing to do with :-)Cheers,AdrianOn 25 Jun 2008, at 08:12,...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33016.html Re: Error While Trying to Fetch a row by Hardy Merrill- June 25, 2008 2 things might be wrong here, and the error message iscorrect. Notice this: Can&39;t locate object method "fecth"... You want to use "fetch"...not "fecth" - notice the spelling. The other thing that might be wrong is this: $dbh = DBI -> connect ("dbi:Sybase:server=DB1;database=fights;timeout=240", "opns","flights") or die ("Cannot connect: DBI::errstr");Looks like you are trying to connect to database...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33015.html Re: rt.cpan.org 36395 by ronsavage.net.au via RT- June 25, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >Hi TimOn Tue, 2008-06-24 at 17:17 -0400, Tim_Bunce via RT wrote:> Queue: DBI> Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >> > The DBI is acting as defined. It&39;s not a bug.> You should avoid using an array to pass arguments to execute().I can&39;t image why I received this email. I have not received any otherson DBI. I suggest you report it to the managet of RT.-- Ron...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33014.html Re: Cannot run INSERT statement over odbc connection to postgres db by Greg Sabino Mullane- June 25, 2008 -----BEGIN PGP SIGNED MESSAGE-----Hash: RIPEMD160> "DBD::ODBC:db prepare failed: unixODBCConnection is readonly, only select> statements are allowed. (SQL-HY000)"Check your odbc.ini file for a ReadOnly setting.- --Greg Sabino Mullane gregturnstep.comEnd Point CorporationPGP Key: 0x14964AC8 200806251215http:biglumber.comxwebpk=2529DF6AB8F79407E94445B4BC9B906714964AC8-----BEGIN PGP...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33013.html RE: Cannot run INSERT statement over odbc connection to postgres db by Stewart Anderson- June 25, 2008 Well I know you can use DBI and ODBC to insert fine, I was doing that from Win 32 very recently.I know the platform is different, but DBI is still the underlying interface with a different ODBC connection. I don&39;t suppose the option for the cursor type makes a difference does it I know it says its for concurrent sql statements but I used the option for some reason, just can&39;t recall the specifics.my $dbh = DBI->connect("dbi:ODBC:$DSN",user,user_password,.http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33012.html Cannot run INSERT statement over odbc connection to postgres db by Alexander Medina- June 25, 2008 Hi Everyone;I&39;m new to this list... Here&39;s what I&39;m trying to do:I have a postgresql database running on a Mac G5 tower. I have a perlscript that is making a ODBC connection to a MSSQL database, extracting along list of users and email addresses and then making a database connectionto the postgres database, and inserting them into a table.I have verified that each of these individual statements work, and the MSSQLconnection works, as I have printed the results to a file. However,...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33011.html rt.cpan.org 36395 by Tim_Bunce via RT- June 24, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >The DBI is acting as defined. It&39;s not a bug.You should avoid using an array to pass arguments to execute().http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33010.html Re: Problem with DBD::Oracle on OS X by Karen Hoofnagle- June 24, 2008 An important factoid I left out:This is a DBD::Oracle install that has the patch that paco over at macosxhints.com wrote applied to it. It&39;s an Intel Mac.http:www.macosxhints.comarticle.phpstory=20061021211559813--- dbdimp.c.orig 2007-12-21 11:03:55.000000000 -0500+++ dbdimp.c 2008-01-31 14:19:37.000000000 -0500 -56,7 +56,6 static sql_fbh_t ora2sql_type _((imp_fbh_t fbh)); void ora_free_phs_contents _((phs_t phs));-static void dump_env_to_trace(); static sb4 oci_error_get(OCIError...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33009.html Re: Problem with DBD::Oracle on OS X by Karen Hoofnagle- June 24, 2008 The first thing I tried was being sure I didn&39;t have any characters in the file that I couldn&39;t see.The second thing I tried was adding white space though I knew it shouldn&39;t matter.KarenOn Jun 24, 2008, at 1:00 AM, Amit Saxena wrote:> Hi !>> I don&39;t know whether it will work or not, but try putting some > spaces on the> both sides of "=" sign in e.rsuid=>> Regards,> Amit Saxena>> On Tue, Jun 24, 2008 at 2:35 AM, Karen Hoofnagle...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33008.html |