DBD::Sybase does not handle character conversions - this is done at the
OpenClient level (i.e. FreeTDS in your case).
Make sure that the locale that is set for your two servers are the same,
and that the charset that is defined on the database server (run
sp_helpsort in a SQL command window).
Mic
All -
I am running a Solaris server with freetds and the DBI-sybase to access a
Netcool database, which is based on Sybase. This is working great. I tried
installing the exact same setup on another server and am seeing some very odd
results when I try to return any integer values. Instead of n
Hi,
Is there is any way to handle "time out requests from Database" in perl
Thanks,
Rakesh.
-
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
Forget I said anythng. The DBA explained to me that Oracle take care of
caching scripts in shared memory allon its own.
Stephen Carville wrote:
Does prepare_cached() only operate on the current DB handle or will it
cause Oracle to cache the sql in shared memory as well? For example, I
run t
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.52.tar.gz
size: 419674 bytes
md5: 57208ef6dccb3e72cf2df665983ce313
file: $CPAN/authors/id/T/TI/TIMB/DBI_WhatsNewTalk_200607.pdf
size: 313734 bytes
md5: 8168b9d931e5288b614461a7b53b8360
=head2 Changes in DBI 1.52 (svn rev 6734), 30h July 2006
Does prepare_cached() only operate on the current DB handle or will it
cause Oracle to cache the sql in shared memory as well? For example, I
run the following sql from Perl CGI programs about 30,000 time a day:
$script =
"select a.statid, b.webstatdesc, a.pendid, c.penddesc
from viewrequestm
On Tuesday 08 August 2006 10:02, Corey wrote:
> The following "quick fix" solved the issue:
>
> $values = join( ', ', map { $self->{'_vcc_dbh'}->quote( $_ || undef ) }
> @$data{ @fields } );
>
Whoops, should have been:
$values = join( ', ', map { $dbh->quote( $_ || undef ) } @$data{
On Tuesday 08 August 2006 09:08, Ronald J Kimball wrote:
> Corey [mailto:[EMAIL PROTECTED] wrote:
> > But what if, for example, there were a couple more columns added to
> > the above example - say, a couple 'integer', 'numeric' and/or 'boolean'
> > types?
> You shouldn't need to worry about th
Garrett, Philip (MAN-Corporate) wrote:
> Corey wrote:
>> Greetings!
>>
>> I'm using DBI w/ DBD::Pg, and am in the midst of attempting to
>> simplify some existing code. I happened on the following older
>> perl.com article: http://www.perl.com/pub/a/2001/03/dbiokay.html
>> which provides what seem
Corey [mailto:[EMAIL PROTECTED] wrote:
> Greetings!
>
> I'm using DBI w/ DBD::Pg, and am in the midst of attempting to simplify
> some existing code. I happened on the following older perl.com article:
> http://www.perl.com/pub/a/2001/03/dbiokay.html which provides what
> seems to be a nicely co
Corey wrote:
> Greetings!
>
> I'm using DBI w/ DBD::Pg, and am in the midst of attempting to
> simplify some existing code. I happened on the following older
> perl.com article: http://www.perl.com/pub/a/2001/03/dbiokay.html
> which provides what
> seems to be a nicely concise way of constructing
Greetings!
I'm using DBI w/ DBD::Pg, and am in the midst of attempting to simplify
some existing code. I happened on the following older perl.com article:
http://www.perl.com/pub/a/2001/03/dbiokay.html which provides what
seems to be a nicely concise way of constructing INSERT statements:
Hi,
I bought a new desktop and I installed ActivePerl 5.8.8.817, DBI 1.51,
and DBD-mysql 3.0006_1.
I install the DBI and DBD-mysql from http://theoryx5.uwinnipeg.ca/ppms.
I have a perl program which has multiple sql statements accessing my
database in Mysql 5.0.
When the program hits the seco
13 matches
Mail list logo
