John Scoles wrote:
>
>
>> Date: Wed, 30 Jun 2010 10:24:24 +0100
>> From: martin.ev...@easysoft.com
>> To: lvir...@gmail.com
>> CC: dbi-users@perl.org
>> Subject: Re: What is the technique to supply a list of values to a
> where clause?
>>
>> Larry W. Virden wrote:
>> > I am working on a quick to
Larry W. Virden wrote:
> I am working on a quick tool to update some records in an oracle
> database.
>
> The code is similar to some other tools I've cobbled together, but in
> this case, the where clause has a "column in list" clause. The
> relevant pieces of code are:
>
> my $aenlist = "(1127
Ashish Mukherjee wrote:
> http://search.cpan.org/~timb/DBI-1.611/DBI.pm#data_sources
>
> This is how you can check for existence of a database.
>
> - Ashish
That won't help you with some DBDs e.g., with DBD::ODBC this returns a
list of data sources and not databases. In DBD::ODBC a data source d
John Scoles wrote:
> Martin Evans wrote:
>> http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html
>>
>>
>> Look for the presentation slides.
>>
>> Martin
> Looks like the link to his s
http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html
Look for the presentation slides.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Bob McGowan wrote:
> On 06/16/2010 01:54 PM, Martin J. Evans wrote:
>> On 16/06/2010 20:22, Bob McGowan wrote:
>>> On 06/16/2010 05:14 AM, Martin Evans wrote:
>>>
>>>> Benjamin Mark wrote:
>>>>
>>>>> &quo
Benjamin Mark wrote:
> "Bob McGowan" wrote in message
> news:4c110b04.60...@symantec.com...
>> On 06/09/2010 08:43 AM, Benjamin Mark wrote:
>>> Hello,
>>>
>>> I wan't to install the DBD::Oracle package on Ubuntu 8.04 LTS.
>>> I've installed a Oracle 10gR2 database (not the client) which is runnin
Subhasis Gorai wrote:
> Hi,
>
>
>
> I just wanted to know what is the compatible version of DBI and Oracle DBD
> for perl, v5.6.1? It would be great if you can provide me with the
> information as soon as possible since it's very urgent.
>
> Thanks a lot for your time!
>
>
>
> Regards,
>
Tim Bunce wrote:
> - Forwarded message from Joe Vinod -
>
> Date: Tue, 15 Jun 2010 12:04:21 +0530
> From: Joe Vinod
> To: tim.bu...@pobox.com
> Subject: Cannot install DBI package
>
>Hi Tim,
>I am Joe and manage a test team. We use PERL extensively for our test
> automation. Re
Alexander Foken wrote:
> On 04.06.2010 15:41, Dave Rolsky wrote:
>> On Fri, 4 Jun 2010, Alexander Foken wrote:
>>> That's why I proposed to switch to DBD::ODBC: It is well tested and
>>> supports Unicode as good as the ODBC driver does.
>>
>> And as I said in private email, that's not really feasib
Due to annoying bug a few people are hitting when re-executing a
prepared statement with MS SQL Server I've uploaded 1.24_1 development
release. Changes since 1.24 are:
Corrected pod and private attributes for the odbc_SQL_DRIVER_ODBC_VER
attribute which was documented as SQL_DRIVER_ODBC_VER.
Add
White, Richard L wrote:
> I'm getting an error when I try to use a "left outer join" in my Perl program.
> I have not found anything about joins in the documentation of the DBD:Oracle
> module.
> I'm using DBD::Oracle v1.18 on Perl v5.8.5 to connect to our Oracle
> 10.02.0400 dB.
>
> If it shoul
mani kandan wrote:
> Hi,
>
>As Alex asked me why I not giving the name of the database in the
> connection string, the script I writing is basically a testing scripting.It
> will connect to the database engine then iterate over all the database
> available.If the database of my interest is ava
I have just uploaded the official 1.24 release of DBD::ODBC to CPAN.
Many thanks to everyone who has helped with this whether it was patches
or testing. Here are the changes since 1.23:
=head2 Changes in DBD::ODBC 1.24 May 14, 2010
Minor change in Makefile.PL to only use NO_META if ExtUtils::Ma
://www.easysoft.com
> Ok. I will rebuild my perl to version 64 and try again.
>
> Thanks,
> Chunmei Wu
>
>
> -Original Message-
> From: Martin Evans [mailto:martin.ev...@easysoft.com]
> Sent: 2010年5月10日 16:32
> To: Chunmei Wu
> Cc: dbi-users@perl.org
>
Chunmei Wu wrote:
> Hi Martin, Reinhard and Jens,
>
> Thanks for your advice. Following is related info you referred:
>
> 1> Are all the components in your chain (perl, driver manager, driver) all64
> bit?
> [Chunmei]: The unixODBC driver and the DB2 driver are 64bit. Seems that my
> perl is 3
Chunmei Wu wrote:
> Hi everyone,
>
>
>
> OS: AIX
>
> perl version: 5.0
>
>
>
> After installed DBD-ODBC-1.21, I run 'make test', but failed 'can't load
> library' error:
>
> t/20SqlServer...ok
> 2/65install_driver(ODBC) failed: Can't load
> '/home/en
I've just uploaded the 1.23_5 development release of DBD::ODBC. This
will hopefully be the last release before an official 1.24. Below are
the changes since 1.23. All testing welcome however, once a few smoke
testers have passed this release I am going to move to a full release
fairly quickly as I'
Larry W. Virden wrote:
> On Tue, May 4, 2010 at 12:39 PM, Martin Hall wrote:
>
>> But, you can create function based indexes, which will avoid full table
>> scans.
>>
>
> What is a function based index?
create index mycolumn_upper_idx on mytable(upper(mycolumn));
Do a search on the web for ora
Larry W. Virden wrote:
> I've a case where a function is called with a string provided by a
> user, and some legacy code then puts that string into a select
> statement for dbi. The code currently reads:
>
> my ($query) = $dbconn->prepare(
> "Select * from my_table where last_na
Jan Dubois wrote:
> On Wed, 14 Apr 2010, Martin J. Evans wrote:
>> As ActiveState do not release development builds (no criticism
>> intended) I am looking at producing a ppm for people to try.
>
> Note that everyone can also just compile the module for themselves
> with ActivePerl:
>
> cpan
http://www.easysoft.com
> On Fri, Apr 9, 2010 at 12:40 AM, Martin Evans
> wrote:
>
>> Parag Kalra wrote:
>>> Just reopening the thread.
>>>
>>> On a second thought - is it possible to connect to SQL Server from Oracle
>>> Server using Perl. :
Parag Kalra wrote:
> Just reopening the thread.
>
> On a second thought - is it possible to connect to SQL Server from Oracle
> Server using Perl. :)
>
> Cheers,
> Parag
>
You can connect Oracle to SQL Server using dg4odbc (from Oracle) and an
ODBC Driver (which you'll have to get else where).
Martin J. Evans wrote:
> Bobak, Mark wrote:
>> Hi all,
>>
>> I'm new to the list, and I'm a DBA, not really a Perl programmer, but I'm
>> running into this issue that I hope someone can help with.
>>
>> I think I'm getting dangerously close to getting this to work. But, I'm
>> just not quite get
Martin Gainty wrote:
> Hi Jeff-
>
> the short answer is yes as Multi-threaded libraries are not same as
> SingleThreaded library which usually spawn n number processes to achieve the
> same goal for handling execution units
> so if your perl script (assuming you'r running apache) is pegging the
Perl Diety wrote:
> We're trying to run a Perl program to connect to an Oracle 10 instance, on a
> RH box. From the xterm it runs fine- connects, R/W, everything is ducky. no
> issues whatsoever.
>
> Then we tried it from a browser (apache server) and it's been a nightmare
> for days. After hours
Agarwal, Gopal K wrote:
> Perl Experts,
>
> I am using DBD::ODBC connection to fire a select query and I am getting the
> following error.
>
> DBD::ODBC::db prepare failed: Unable to fetch information about the error
>
> As this message is not giving any useful information, is there any other w
Bobak, Mark wrote:
> Hi all,
>
> I'm new to the list, and I'm a DBA, not really a Perl programmer, but I'm
> running into this issue that I hope someone can help with.
>
> I think I'm getting dangerously close to getting this to work. But, I'm just
> not quite getting there.
>
> We have an ap
John Scoles wrote:
> Silly me you do need it so rare that I use it day to day.
>
> In my case I usualy use it like this
>
>$c->bind_param_inout(":p_new_id",\$p_new_id,SQL_DECIMAL);
>
I think you mean
$c->bind_param_inout(":p_new_id",\$p_new_id,$length,SQL_DECIMAL);
as the $length is comp
Steve Lynn wrote:
> On Mar 2, 2:30 am, martin.ev...@easysoft.com (Martin Evans) wrote:
>> Lynn, Steve wrote:
>>> All - I'm under Solaris using perl v. 5.8.3 and DBI v. 1.48. I can catch
>>> signals w/o a problem before I connect to the database.
>>> Howev
Alex Bernier wrote:
> Hello,
>
> I use DBI 1.605, the DBD MySQL driver 4.007, Perl 5.10.0, MySQL 5.1.41 (on a
> Debian Lenny).
>
> Here is my script :
>
>
> use DBI;
>
> $DB_name= 'xxx';
> $DB_user= 'xxx';
> $DB_pwd = 'xxx';
> my $dbh;
> $dbh = DBI->connect("dbi:mysql:dbname=$DB_n
Lynn, Steve wrote:
> All - I'm under Solaris using perl v. 5.8.3 and DBI v. 1.48. I can catch
> signals w/o a problem before I connect to the database.
>
> However after I connect, I can't catch signals anymore. If I comment out the
> "DBI->connect" and press ctrl-c in a ReadLine(0), the signa
Jenda Krynicky wrote:
> From: "Martin J. Evans"
>> I've written up some of the issues causing confusion on dbi-users (and
>> to me personally) with DBD::ODBC and MS SQL Server here:
>>
>> http://www.martin-evans.me.uk/node/58
>>
>> I encourage all feedback.
Thanks for your comments.
> SET NOCOU
I can change my procedure to return a reference cursor
(although that will be annoying) or just an empty clob. I wish I had
more time to look at this but I'm really struggling.
Martin
> On Tue, Feb 23, 2010 at 07:17:20PM +, Martin J. Evans wrote:
>> On 23/02/2010 18:48, Joh
Hi,
I'm experiencing a problem in DBD::Oracle calling a procedure which
returns a lob but sometimes the lob is not set. We use ora_auto_lob = 0
so we can retrieve the lob ourselves but I cannot see how to know the
lob is empty and calling ora_lob_length returns an error:
DBD::Oracle::db ora_lob_l
pr wrote:
>
> --- On Thu, 2/18/10, Martin Evans wrote:
>
>> From: Martin Evans
>> Subject: Re: Error during SQL Server restore fails to propagate back to DBI
>> client on Windows
>> To: "pr"
>> Cc: dbi-users@perl.org
>> Date: Thursda
pr wrote:
> Overview:
>
> Using perl+DBI+DBD::ODBC on Windows, I am connecting to a SQL Server 2005
> instance and issuing a "restore database [foo] from disk='c:\foo-backup.bak'".
>
> The restore attempt appears to succeed, and nothing calls my installed error
> handler.
>
> However, if I run
Amit.Nagpure wrote:
> Hi
> I am getting the below error while executing the perl on AIX.
> The error is below pasted.
>
> Can't locate loadable object for module DBI in @INC (@INC contains:
> /usr/opt/perl5/lib/5.8.2/aix-thread-multi /usr/opt/perl5/lib/5.8.2
> /usr/opt/perl5/lib/site_perl/5.8.2/
I have just uploaded 0.19 of DBIx::Log4perl which fixes an annoying
issue introduced in 0.18 which prevented DBIx::Log4perl capturing and
outputting errors raised by DBI.
Sorry for any inconvenience.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Prindle, Douglas E wrote:
> Hello,
>
>
>
> Being first time through this process when I did the make it was looking
> for the gcc compiler. My company has made that End Of Life due to it
> being a sunsetted product.
really?
> So I switched to the Forte 11 compiler from
> Sun which we have had
Tim Bunce wrote:
> - Forwarded message from "Prindle, Douglas E "
> -
>
> Date: Tue, 26 Jan 2010 17:03:33 -0600
> From: "Prindle, Douglas E "
> To: "'tim.bu...@pobox.com'"
> CC: "Prindle, Douglas E "
> Subject: DBD::Oracle
>
>Hi Tim,
>
>
>
>We are re-installing some of our
Just uploaded to CPAN. This is a development release as I've introduced
two significant changes which I'm waiting on feedback for.
=head2 Changes in DBD::ODBC 1.23_2 January 26, 2010
Fixed bug in Makefile.PL which could fail to find unixODBC/iODBC
header files but not report it as a problem. Tha
I've just uploaded a new release of DBIx::Log4perl to CPAN. The changes:
0.18 Mon January 22 2010
Minor speedups in bind_param, bind_param_inout and execute methods.
Thanks to Devel::NYTProf.
Minor speedups in _unseen_sth.
Thanks to Devel::NYTProf.
Fix rt 53755 (fetchrow_array ig
65pony wrote:
> I am trying to use 2 different databases within a single perl script
> running on AIX 5.3. 1 being DB2 via DBD::DB2 and the other MSSQL via
> DBD::ODBC
>
> I am able to connect to each database and get unique db handles
> however whenever I try and use the ODBC connection, for a pr
/www.easysoft.com
> Thanks
>
> 2010/1/13 Martin Evans <mailto:martin.ev...@easysoft.com>>
>
> fida aljounaidi wrote:
> > Helo
> > Thanks for your answer
> >
> > The example is with this function
> >
> >
'1331' '1149' '1594' '426'
'542' '1533' '1435' '961' '956' '498' '629' '1288' '2951' '2988' '574'
'1540' '920' '1284' &
e no difference.
As I said, it may be worth posting a small example as we cannot tell
from your description what may be going wrong.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
> 2010/1/8 Martin Evans <mailto:martin.ev...@easysoft.com>>
>
> fida a
fida aljounaidi wrote:
> Hi
>
> I have a problem whith one large select request.
>
> A connection is opened by dbi perl but ended without giving any result.
> Th perl script end with an error like
>
> "Not an ARRAY reference"
>
> When i observed mysql log, i found that the connection opened is
John Scoles wrote:
> Martin Evans wrote:
>
> If I am not mistaken RowsInCache should return the # of records left
> before another fetch (from server) takes place?
> The way I implemented it in DBD::Oracle is a simple countdown from n.
>
> So you would like it to be a co
Hi,
I was attempting to check DBD::Oracle 1.24 rc1 fixed the issue
"RowCacheSize is being ignored slowing down fetches a lot",
http://rt.cpan.org/Public/Bug/Display.html?id=46763 and came across a
possible bug/inconsistency in DBI or DBD::Oracle.
DBI says RowCacheSize is a connection attribute an
sponse if you have compared the versions of the postgres client
library - libpq.so (I think). I believe the change to output the error
you are seeing is in that library although I've not checked myself.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
>
>
> O
Yasser Shakoor wrote:
> Hi all
>
> I am trying the same code on 2 different machines on one machine it is
> running ok and on the other machine it is giving strange kind of error,
> i have tried every thing but was not able to sort thois out so i thought
> to take help from you people.
> #!/usr/bi
Tim Bunce wrote:
> Michael “Monty” Widenius, the creator of MySQL, has asked me, among many
> others, to help spread the word about an imminent decision by the
> European Commission on the Oracle merger with Sun.
>
> Why should you care? Monty’s view, along with others like
> http://keionline.org/
Tim Bunce wrote:
> On Tue, Dec 15, 2009 at 02:53:03PM +0000, Martin Evans wrote:
>> If you are using the latest DBI and Perl 5.10.0 or 5.10.1 and running in
>> taint mode (but have not set DBI's Taint, TainTIn, TaintOut) then use
>> tainted strings in the SQL you i
Martin J. Evans wrote:
> Martin J. Evans wrote:
>> Hi,
>>
>> I've spent some time on this today and I am getting nowhere. Before I
>> redouble my efforts I thought I'd post here just in case anything rings
>> a bell with someone.
>>
>> We are using the latest DBI and DBD::Oracle to get data from an
Jonas Brømsø Nielsen wrote:
> Hello,
>
> I am experiencing some issues with DBD::Oracle on OS X 10.6 Snow Leopard.
>
> I have downloaded instant client Version 10.2.0.4 (32-bit) from:
>
> http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html
>
> Namely, the
Bhingare, Pravin Baban wrote:
> Hi ,
>
> I am trying to install DBI-1.18 on HP-UX 11i v2 . Oracle DB installed is 11g
> .
>
> I am following below steps to install DBI
>
> 1)cd /opt/gpsy/dbdsource/
> (Ensure that the downloaded source code .tar.gz file is present in this
> direct
Just uploaded 1.23_1 to CPAN. This release contains:
makefile.PL changes:
some formatting changes to output
warn if unixodbc headers are not found that the unixodbc-dev package
is not
installed
use $arext instead of "a"
pattern match for pulling libodbc.* changed
warn if DBI_DSN etc
Jonathan Smith wrote:
> make test fails with many errors similar to the following:
>
> Can't locate object method "no_diag" via package "Test::Builder"
>
> Thanks in advance for any help.
>
> Full log:
What version of Test::Builder have you got?
Does it have the no_diag method (perdoc Test::B
Hi,
I am about to make a change to DBD::ODBC with respect to cygwin
environments. If you use cygwin and unixODBC instead of cygwin and MS
ODBC Driver manager could you please let me know or the next release of
DBD::ODBC may not work for you without tinkering with it.
Thanks.
Martin
--
Martin J.
David Silva wrote:
> Hi Matthew,
>
> I resolved the problem like this :
>
> # HTML::Mason
>
> if ($validar){
> my $dbcon= DBI->connect("dbi:mysql:dbname=dbcontactos","root","");
> my $sql = $dbcon->prepare("select name, pass from Utilizador where
> name=? and pass=?");
> $sql->ex
work it out or I'll need to take it step by step using you as a bit of a
remote typist.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
>
> -Original Message-
> From: Martin Evans [mailto:martin.ev...@easysoft.com]
> Sent: Wednesday, October 14, 2009
m perl Makefile.PL below.
>
>
> Shawn
>
>
> -Original Message-----
> From: Martin Evans [mailto:martin.ev...@easysoft.com]
> Sent: Wednesday, October 14, 2009 10:11 AM
> To: Shawn Zong
> Cc: dbi-users@perl.org
> Subject: Re: need help to install DBD::ODBC
I right in assuming that when using cygwin
you are still expecting to use the MS ODBC Driver manager?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
>
>
>
> -Original Message- From: Martin Evans
> [mailto:martin.ev...@easysoft.com] Sent: Wednesday, Octob
David Silva wrote:
> Hi everyone,
>
> I have a form with username and password, and when the user enter the right
> user and pass he/she go to other page. (that is my thought)
>
> What i did?
>
> my $dbcon= DBI->connect("dbi:mysql:dbname=dbcontactos","root","");
> my $sql = $dbcon->prepa
Shawn Zong wrote:
> I am having difficulty to compile on Perl V5.10.0 built with MS SQL
> server 2005. The program could not find installed ODBC Driver Manager.
>
>
>
> Here is my configuration.
>
> DBI_DSN: 'dbi:ODBC: DSN_NAME', DSN_NAME is set up in System DSN in
> ODBC Data source Ad
8 Errors returned by procedures are not unicode strings
46998 Why is RowCacheSize limited to 128
of which I believe the last 3 are now all sorted in subversion and 49818
is an enhancement. What could I do to help accelerate a 1.24 release?
>> Charles Jardine wrote:
>>> On 07
Charles Jardine wrote:
> I have encountered a problem with the 'extended' support for
> objects in DBD::Oracle. Specifically, if $dbh->{ora_objects}
> is true, any attempt to fetch a nested table of objects
> causes perl to crash with a segmentation fault.
>
> Versions:
> OS: SLES10 SP2 (64bit)
>
Stephan Austermühle wrote:
> Martin,
>
> thanks for your detailed background explanations. I really appreciate your
> posting. Viewed superficially the theme character sets seems to be simple but
> surprisingly I encounter it since my very first day in IT.
>
> I'll give unixODBC/CVS a try.
>
>
Martin Evans wrote:
> Stephan Austermühle wrote:
>> Hello Martin,
>> Martin Evans schrieb:
>>
>>> What do you mean by that? Select stops working it you stipulate your
>>> perl script is utf-8?
>> Yes: When adding "use encoding 'utf8'"
Stephan Austermühle wrote:
> Hello Martin,
> Martin Evans schrieb:
>
>> What do you mean by that? Select stops working it you stipulate your
>> perl script is utf-8?
>
> Yes: When adding "use encoding 'utf8'" the result reads like this:
>
>
Hendrik Schumacher wrote:
> At the first glance you may be using a non-unicode database connection. In
> this case
>
> $dbh->do ("set names 'utf8'");
>
> may help.
>
> Hendrik
Are you sure that is a "SQL Server 2008" statement? I thought that was a
mysql thing.
Martin
--
Martin J. Evans
Easys
Stephan Austermühle wrote:
> Hi all,
>
> maybe I do not to see the wood for the trees...
>
> All I want to do is to process strings with special characters (e.g.,
> Umlauts), i.e. INSERT and SELECT them from my database (SQL Server 2008).
>
> Querying strings with special characters works fine n
Tim Bunce wrote:
> - Forwarded message from Yuriy Tretyakov -
>
> To: tim.bu...@pobox.com
> From: Yuriy Tretyakov
> Date: Tue, 15 Sep 2009 12:31:05 +0300
>
>Hello Tim.
>
>I have a very important task, but I'm stopped now because failed to solve
> one problem.
>
>I working
I have just uploaded DBD::ODBC 1.23 to CPAN. It is a full release of all
the 1.22_x development series releases. The changes since 1.22 are:
=head2 Changes in DBD::ODBC 1.23 September 11, 2009
Only a readme change and version bumped to 1.23. This is a full
release of all the 1.22_x development re
John Scoles wrote:
> Depends on the DBD driver.
I'm not sure that is true John. I believe execute_array is implemented
in DBI for drivers which don't have their own execute_array. It may not
be as fast but it is there.
> Which one are you using?
>
> cheers
>
Martin
>
> Denis BUCHER wrote:
>
Denis BUCHER wrote:
> Hello everyone,
>
> Martin Evans a écrit :
>>>>>>>> I'm trying to simply do a SELECT from an ODBC source.
>>>>>>>> It works perfectly in PHP but not in perl !
>>>>>>>> Therefore there i
Denis BUCHER wrote:
> Hello Martin,
>
> Martin J. Evans a écrit :
>> I'm trying to simply do a SELECT from an ODBC source.
>> It works perfectly in PHP but not in perl !
>> Therefore there is no problem at source or at ODBC level, it seems to
>> reside at perl/DBI level...
>>
>
Denis BUCHER wrote:
> Hello everyone,
>
> Some precisions to my previous email...
>
>> I'm trying to simply do a SELECT from an ODBC source.
>> It works perfectly in PHP but not in perl !
>> Therefore there is no problem at source or at ODBC level, it seems to
>> reside at perl/DBI level...
>>
>>
Michael Thompson wrote:
> I am having difficulties connecting to Microsoft SQL 2005 from a Perl script.
> I am using DBI 1.609 with unixODBC 2.2.8 and freeTDS 0.82. The commands
> isql, tsql -H, and tsql -S all connect successfully and respond as expected
> to queries, but when I try to connec
col wrote:
> Consider this:
>
> my $sth = $dbh->prepare("INSERT INTO [DATATEST] ( [billingterms],
> [carrier], [class (1)], [class (2)], [class (3)], [class (4)],
> [client], [consignee], [cube (1)], [cube (2)], [cube (3)], [cube
> (4)], [description (1)], [description (2)], [description (3)],
> [
Chase Putans wrote:
> I am doing a prepare/execute/fetchrow_hashref and for columns that have
> names longer than 30 characters, the hash key is truncated to the first
> 30. Is this a known issue, and if so, is there a workaround for it? I
> am using unixODBC 2.2.11 and and DBD::ODBC 1.17 (also
Scott Stansbury wrote:
> Getting closer :)
>
> I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box:
>
> unixODBC: 2.2.14
> FreeTDS:0.82
> Easysoft: odbc-sqlserver-1.1.26-linux-x86 (this morning, thank you
> again Martin and Wez...)
>
> osql/isql work fine with both t
errors, and have confirmed that $PATH, $ORACLE_HOME and
> $ORACLE_SID etc are set correctly for these users.
>
> Any help appreciated!
> Thanks!
First get sqlplus working. Then use unixODBC's isql to get ODBC working
(isql -v orcl dbuser dbpass) and lastly work on Perl.
>
&
Dhanashri Bhate wrote:
> Hi All,
> I have been working on Windows with Oracle DB and Active Perl and done some
> DBI coding with DBD::ODBC.
> Now I need to move things over to Linux machine ( Red Hat Linux 4 and Oracle
> 10g.)
> I know this is not really a DBI question, but I thought I can get g
Jannis Kafkoulas wrote:
> Hi,
>
> I have this table:
>
> create TABLE netobj (
> name VARCHAR(100),
> type int(1),
> ip_mem VARCHAR(1100),
> mask VARCHAR(15) default "na",
> comment VARCHAR(50) default "-",
> mark int(1) default 0,
> primary key(name));
>
> (on a debian etch).
>
> After e
col wrote:
> On Fri, 26 Jun 2009 08:44:28 +0200 "John Escott"
> wrote:
>
>> (the first reply in the same page) helpful, since unixODBC 2.2.8 is
>> the default version in RHEL3 and a recent Fedora containing 2.2.11
>> worked correctly.
>
> John --
>
> Thanks for your reply. Actually, the probl
Scott Stansbury wrote:
> I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box:
>
> unixODBC: 2.2.14
> FreeTDS:0.82
> Easysoft: odbc-sqlserver-1.1.4-linux-x86 (trial for now)
>
> osql/isql worked fine with both the FreeTDS and the Easysoft drivers.
>
> Connecting to a SQ
Martin J. Evans wrote:
> col wrote:
>> First, let me assure you all I know nothing about the actual code that makes
>> all this stuff work, or compiling, or really, much of anything "hard" about
>> computing. So, this could be pure malarkey. Anyway...
>>
>> There appears to be a linking problem w
Hi,
I am sorry to have to admit to being the author of a very very silly bug
in unicode handling in DBD::ODBC. The length of UTF16 encoded data was
stored in an unsigned short and this can overflow. An unfortunate side
effect of this bug can be corruption in your perl application. I only
found thi
Jirka Novak wrote:
> Hi,
>
> I probably hit bug in DBD::ODBC when it is compiled with unicode support.
> I found that when I have table with NVARCHAR() column and try to write
> NULL (undef) value by placeholder, perl write 'Use of uninitialized
> value in subroutine entry at xxx.pl line xx.',
ranu.kum...@accenture.com wrote:
> Hi,
>
>
>
> I am trying to connect to oracle (11g) database through PERL script in
> windows using ActivePERL (5.10.0 Build 1004). But I am getting the
> following error while connection:
>
>
>
> DBD::oracle initialisation failed: Can't locate object metho
OCIDOMDocument **retDom);
>
> sword OCIXMLTypeGetFromDOM(OCIError *errhp, OCIDOMDocument *domdoc,
> OCIXMLType **retXMLType);
>
> sword OCIXMLTypeGetNS(OCIError *errhp, OCIXMLType *domdoc,
> OraText **ns, ub
I have uploaded a new development release of DBD::ODBC to CPAN.
This fixes the issue reported in
https://rt.cpan.org/Ticket/Display.html?id=46597 and represents a change
in the behavior for binding parameters as DBD::ODBC was not following
the DBI specification.
If you bind parameters and then al
col wrote:
> [x-posted to unixODBC list]
>
> Is not possible in this combination since many version updates now.
>
> I'd like to get current AND with a working configuration.
>
> Working tunnel: ssh u...@the.pub.ip.add -q -f -N -L 1799:192.168.243.140:1433
> (Yes, tsql works, no problems with t
Martin Evans wrote:
> Martin Evans wrote:
>> Dhanashri Bhate wrote:
>>>> -Original Message-----
>>>> From: Martin Evans [mailto:martin.ev...@easysoft.com]
>>>> Sent: Tuesday, June 02, 2009 5:44 PM
>>>> To: dbi-users@perl.o
Martin Evans wrote:
> Dhanashri Bhate wrote:
>>> -Original Message-
>>> From: Martin Evans [mailto:martin.ev...@easysoft.com]
>>> Sent: Tuesday, June 02, 2009 5:44 PM
>>> To: dbi-users@perl.org
>>> Subject: Re: Prepare, SQL query with to_date
Dhanashri Bhate wrote:
>> -Original Message-
>> From: Martin Evans [mailto:martin.ev...@easysoft.com]
>> Sent: Tuesday, June 02, 2009 5:44 PM
>> To: dbi-users@perl.org
>> Subject: Re: Prepare, SQL query with to_date call
>>
> Dhanashri Bhate wrote:
&
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dhanashri Bhate wrote:
> Thanks,
> Well when I tried with properly formatted string for a date field I still got
> Error - Datetime field overflow.
>
> And the $dbh->do was just to show that it works, but $sth->prepare and
> $sth->execute doesn't.
>
praveen vejandla wrote:
> I am using dbi:ODBC to connect to SQL 2005 server. program_name is not
> getting registered at SQL Server side.
>
> my $dbh = DBI->connect("dbi:ODBC:server1","user","");
>
> But when I use dbi:FreeTDS, it is registering the program_name properly.
>
> my $dbh = DBI-
1 - 100 of 304 matches
Mail list logo
