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 D
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 Tes
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
> 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?
sqlplus user/pass responds in < 0.5 sec.
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
-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 Con
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 be
- Original Message -
From: "Kevin Moore" <[EMAIL PROTECTED]>
To: "DBI List"
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 got DBI r
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: 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 wit
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
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
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
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 assumpti
On Tue, 13 Jun 2006 09:54:41 +0100, Martin Hall wrote:
Hi Martin
> I have to say that it doesn't sound right to me. I agree that
Perhaps you mean unbelievable? I agree.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 13/06/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an
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
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 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 finis
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 (twist
19 matches
Mail list logo