$ora_errno Reset Problem

I am running into a problem where it appears as though the $ora_errno variable isn't being properly reset after encountering an error. What I am experiencing is that once $ora_errno and $ora_errstr is set, it stays set upon additional calls to ora_bind(). The following code produces the problem:

Re: $ora_errno Reset Problem

Try chaning these two lines in Oraperl.pm *Oraperl::ora_errno = \$DBD::Oracle::err; *Oraperl::ora_errstr = \$DBD::Oracle::errstr; to: *Oraperl::ora_errno = \$DBD::err; *Oraperl::ora_errstr = \$DBD::errstr; Tim. On Wed, Sep 10, 2003 at 02:00:28PM -0500, [EMAIL PROTECTED] wrote: I am

get the messages, not the rows

Is there a way to execute an SQL command and get the messages, not the records? I mean, I'd like to run DBCC CHECKDB ('databasename') parse the output and add the result to a daily report of my servers' health. The question is how do I get the messages. I'm using DBI+DBD::ODBC and MS

Problem connecting to non-default db

Hi, I'm trying to connect to two ms sqlserver 2000 databases with the same schema (let's call them dbA and dbB) using the following code: my $connect_string = dbi:Sybase:dbname=dbA:server=MyServer; $connect_string .= ;host=192.168.0.2;port=1433; my $dbh = DBI-connect($connect_string,

Re: get the messages, not the rows

If MSSQL Server hasn't diverged too far from being a derivative of Sybase, you would trap those messages in an error or a message handler - but that only works in sybperl and DBD::Sybase AFAIK. I don't know how you would get to the those callbacks in ODBC. HTH somewhat. -- Matt

RE: [dbi] Problem connecting to non-default db

I haven't tried it in a long time (other than running make test) but from perldoc DBD::ODBC: odbc_async_exec Allow asynchronous execution of queries. Right now, this causes a spin-loop (with a small sleep) until the sql is complete. This is useful,

Re: get the messages, not the rows

From: [EMAIL PROTECTED] If MSSQL Server hasn't diverged too far from being a derivative of Sybase, you would trap those messages in an error or a message handler - but that only works in sybperl and DBD::Sybase AFAIK. I don't know how you would get to the those callbacks in ODBC. HTH somewhat.

RE: [dbi] Problem connecting to non-default db

Hi, I'm not trying to connect to the 2 db's at the same time, so I'm not sure what you mean. What I'm doing is executing the script for the 1st; editing it so that the dbname parameter in the connect string is for the other 2nd; running the script again. The problem is that it's only

RE: [dbi] Problem connecting to non-default db

On 11-Sep-2003 [EMAIL PROTECTED] wrote: Hi, I'm not trying to connect to the 2 db's at the same time, so I'm not sure what you mean. Appologies, I clicked reply on the wrong message. My reply was for Jenda Krynicky. Sorry about that. -- Martin J. Evans Easysoft Ltd, UK Development

Re: Problem connecting to non-default db

[EMAIL PROTECTED] wrote: Hi, Hello, I'm trying to connect to two ms sqlserver 2000 databases with the same schema (let's call them dbA and dbB) using the following code: my $connect_string = dbi:Sybase:dbname=dbA:server=MyServer; $connect_string .= ;host=192.168.0.2;port=1433; my

Re: Problem connecting to non-default db

Hi, Do you mean replace dbname=dbA with dbname=dbB in my connect string? I've tried that. Is there another way to switch the data source to another db? Is there any fix for this DBD::Sybase bug? Thanks, Bilal On Thu, 11 Sep 2003, Chuck Fox wrote: [EMAIL PROTECTED] wrote: Hi,

Re: Problem connecting to non-default db

Bilal, Try just executing use dbA after the connection is made. Another option is to directly reference the db in the query by using select * from dbA.dbo.array. A table can be referenced as tableName or ownerName.tableName or as databaseName.ownerName.tableName. Insofar as the bug, try

Re: Entering data in Postgres bytea field

On Tue, 9 Sep 2003, Zhivko Duchev wrote: Hello all, I'm trying to load a large amount of binary data in bytea field in Postgre table using perl. The problem is that the only way I've managed to do it was by using placeholders and binding like this: $statement=Insert into pic1 (pic,type)

Re: Help with install????

On Tue, 9 Sep 2003, Badinter, George wrote: I am trying to get perl mysql going and this is the error message I get : dbimon mysql:test:localhost ld.so.1: /usr/local/bin/perl: fatal: relocation error: file /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so:

RE: [dbi] get the messages, not the rows

From: Martin J. Evans [EMAIL PROTECTED] I haven't tried it in a long time (other than running make test) but from perldoc DBD::ODBC: odbc_async_exec Allow asynchronous execution of queries. Right now, this causes a spin-loop (with a small sleep) until

DBD Informix Install Question

I am having trouble installing the DBD::Informix (version 2003.04). I have installed a 64 bit perl and the DB1 1.35. Here is the specs: Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: Platform: osname=solaris, osvers=2.9, archname=sun4-solaris uname='sunos

Re: $ora_errno Reset Problem

Unfortunately this doesn't appear to have done the trick as I am seeing the same behavior as before. Do you have any other suggestions of things to try? Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try chaning these two lines in Oraperl.pm *Oraperl::ora_errno =

RE: [dbi] get the messages, not the rows

On 11-Sep-2003 Jenda Krynicky wrote: From: Martin J. Evans [EMAIL PROTECTED] I haven't tried it in a long time (other than running make test) but from perldoc DBD::ODBC: odbc_async_exec Allow asynchronous execution of queries. Right now, this causes a

Problems with make on unix

Title: Problems with make on unix # perl Makefile.PL Using DBI 1.38 installed in /usr/local/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using

Licence expired for DBI module

could you pls clarify i am getting this error while installing DBI module. cc -c -xO3 -xdepend-DVERSION=\1.32\ -DXS_VERSION=\1.32\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c , license error: Notice: The 60-day trial serial number has expired. In order to

Re: Licence expired for DBI module

On Thu, 11 Sep 2003 15:48:28 -0400 Vasanthu, Jitendra [EMAIL PROTECTED] wrote: could you pls clarify i am getting this error while installing DBI module. cc -c -xO3 -xdepend-DVERSION=\1.32\ -DXS_VERSION=\1.32\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c ,

Re: $ora_errno Reset Problem

Can you produce a small test script that shows ora_errno not being reset but $DBD::err being reset? Tim. On Thu, Sep 11, 2003 at 02:59:27PM -0500, David Deemer wrote: Unfortunately this doesn't appear to have done the trick as I am seeing the same behavior as before. Do you have any other

Re: Problem connecting to non-default db

On Thu, 2003-09-11 at 11:32, [EMAIL PROTECTED] wrote: Hi, Thanks, use dbA works. It doesn't work as part of a do statement (i.e. $dbh- do(use dbA)), but it looks like it's working when I prep and execute use dbA using a statement handle. If the do() doesn't work it's probably because you

Re: Licence expired for DBI module

On Thu, 11 Sep 2003 15:48:28 -0400, Vasanthu, Jitendra wrote: could you pls clarify i am getting this error while installing DBI module. cc -c   -xO3 -xdepend    -DVERSION=\1.32\ -DXS_VERSION=\1.32\ - KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c , license error: Notice:

DBD::Pg Release Candidate 1.31_5

Good day, DBD::Pg 1.31_5 is now on CPAN. The last(?) blocker was fixed by Jeremy Yoder, and Mark Stosberg was kind enough to bundle up this version. http://search.cpan.org/CPAN/authors/id/R/RU/RUDY/DBD-Pg-1.31_5.tar.gz Please try this version and report back to the list if you have any

Re: Problem connecting to non-default db

Hi, Thanks, use dbA works. It doesn't work as part of a do statement (i.e. $dbh- do(use dbA)), but it looks like it's working when I prep and execute use dbA using a statement handle. I'm using DBD::Sybase v1.01, so I guess there's still an issue with DBI only connecting to the default db.

Re: What to do with UTF-8 data?

Hi, Steve, [...] The problem is: How do I trap all input/output to/from DBI to do these conversions? [...] I've asked about this on the dbi-users mailing list, and the answer (from Tim Bunce, no less) was that it is really the responsibility of the DBD driver to perform such

Re: What to do with UTF-8 data?

On Thu, Sep 11, 2003 at 08:29:50AM +0200, Jochen Wiedmann wrote: Hi, Steve, The problem is: How do I trap all input/output to/from DBI to do these conversions? I've asked about this on the dbi-users mailing list, and the answer (from Tim Bunce, no less) was that it is really the

Re: What to do with UTF-8 data?

Tim Bunce wrote: On Thu, Sep 11, 2003 at 08:29:50AM +0200, Jochen Wiedmann wrote: Hi, Steve, The problem is: How do I trap all input/output to/from DBI to do these conversions? I've asked about this on the dbi-users mailing list, and the answer (from Tim Bunce, no less) was that

Re: What to do with UTF-8 data?

On Thu, 11 Sep 2003 12:31:52 +0100, Steve Hay wrote: It would be cool if something akin to binmode STDOUT, ':utf8'; could be applied when sending data to the driver -- i.e. my data is in Perl's internal format, whether that be Latin-1 or UTF-8 in the case of the string at hand, and it all gets