On 6/12/06, Ron Savage [EMAIL PROTECTED] wrote:
Using a DSN of dbi:ODBC:xyz, the DBI - connect(...) call takes 16 (sic)
seconds
with both the Perl script and Oracle running on the same PC under Windows.
You have been warned :-(.
I've occasionally seen similar outrageously long connection
On Mon, 12 Jun 2006 23:04:04 -0700, Jonathan Leffler wrote:
Hi Jonathan
We, I know Oracle has been criticized for taking up to 7 secs to
connect in a non-Win evironment, so I assume this is the same, just much worse.
Of course, it could indicate the Oracle developers has a
On Mon, Jun 12, 2006 at 03:24:55PM +0100, Martin J. Evans wrote:
Hi,
DBI documentation says execute on a an active statement should imply a finish
call but DBD::DB2 does no appear to do this - see example below.
This issue is now causing me a severe amount of grief as we have no finish
Ron Savage wrote:
On Mon, 12 Jun 2006 23:04:04 -0700, Jonathan Leffler wrote:
Hi Jonathan
We, I know Oracle has been criticized for taking up to 7 secs to
connect in a non-Win evironment, so I assume this is the same, just much worse.
Of course, it could indicate the Oracle
On 13-Jun-2006 Ron Savage wrote:
On Mon, 12 Jun 2006 15:24:55 +0100 (BST), Martin J. Evans wrote:
Hi Martin
This seems to fall into the category of the first quote from the
I saw the original post, and expected someone else to answer.
I don't agree that it falls in the first category.
On Tue, 13 Jun 2006 10:28:00 +0100 (BST), Martin J. Evans wrote:
Hi MArtin
When I add the dbd_st_finish call it works and I cannot as yet see
any side effects other than making DBD::DB2 do what the DBI docs
say.
OK. Fair enough.
I was really trying to provoke you to reassess your
On 13-Jun-2006 Tim Bunce wrote:
On Mon, Jun 12, 2006 at 03:24:55PM +0100, Martin J. Evans wrote:
Hi,
DBI documentation says execute on a an active statement should imply a
finish
call but DBD::DB2 does no appear to do this - see example below.
This issue is now causing me a severe
I would like to voice some frustration at the advice to ask
'support' for assistance in this situation. It has been a problem for years
now. Too many requests for help dealing with the PERL/ODBC/Windows problem
with slow connections are dead-ended.
I believe a major hurdle is that
I can understand frustration but your request is too nebulous for those who
do have the skills to help you troubleshoot. I connect to Oracle from many
different Windows installs daily and have never seen the problems you have
described without other identifiable machine configuration issues (as in
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Monday, June 12, 2006 9:22 PM
To: List - DBI users
Subject: Speed test for connecting to Oracle for Windows via ODBC
Hi Folks
Using a DSN of dbi:ODBC:xyz, the DBI - connect(...) call takes 16
(sic) seconds with
Apologies, I was making a general observation. I was more interested in
making the exercise easier for others, as my own situation is probably an
obsolete issue. All those technical aspects necessary to obtain a solution
were provided during 2004, and some would no longer be valid (e.g.
esoftmatic
- Original Message -
From: Kevin Moore [EMAIL PROTECTED]
To: DBI List dbi-users@perl.org
Sent: Monday, June 12, 2006 5:50 PM
Subject: Displaying fetched values in html form
I'm not sure if this is the right forum so i'd appreciate pointers to
the correct place if i'm wrong.
I've
On Tue, 13 Jun 2006 09:57:38 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
Hi Philip
Control Panel
- Administrative Tools
- Data Sources (ODBC)
- (Your DSN)
- Configure
- Test Connection
How long does that take to acknowledge success?
It's 16 seconds after clicking Test before the
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 13, 2006 6:11 PM
To: List - DBI users
Subject: RE: Speed test for connecting to Oracle for Windows via ODBC
On Tue, 13 Jun 2006 09:57:38 -0400, Garrett, Philip \(MAN-Corporate\)
wrote:
- Test
On Tue, 13 Jun 2006 18:37:49 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
Hi Philip
How long does it take to connect via sqlplus? tnsping?
sqlplus user/pass responds in 0.5 sec.
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
On Tue, 13 Jun 2006 18:37:49 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
Hi Philip
How long does it take to connect via sqlplus? tnsping?
I should mention the MySQL ODBC connector V 3.5 when tested responds
immediately.
The Postgres connector does not have a test button.
--
Ron Savage
On Tue, 13 Jun 2006 18:37:49 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
Hi Philip
How long does it take to connect via sqlplus? tnsping?
Took me a while to work out what the command line option for tnsping was. Its
XE.
So: tnsping XE responds immediately.
--
Ron Savage
[EMAIL PROTECTED]
On Tue, 13 Jun 2006 18:37:49 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
Hi Philip
It's 16 seconds after clicking Test before the dialog box pops up
That testing was under Win2K at home.
Now at work (Monash University) with WinXP and a network, response is immediate
(referring to the Test
On Fri, 09 Jun 2006 16:08:53 +1000, Ron Savage wrote:
Hi Ron
OK. I got this working.
I created a user thru the Oracle web interface http://127.0.0.1:8080/apex.
This allows setting:
o Username
o Password its expiry (Y/N)
o Account status (Locked/Unlocked)
o User privileges
These are fixed:
o
19 matches
Mail list logo