Eric Frazier wrote:
> I also still don't see how a connection can be "reconnected" at such a high
> level.
It can't, unless your database specifically supports the command
"reauthenticate". Oracle does, which is what he wrote this for, but I
don't think it's a standard part of SQL syntax so it
Hi!
Thanks a lot for this. I am not sure now if I will be able to use it. I am
afraid that if I do I will suddenly become its main supporter :)
I also still don't see how a connection can be "reconnected" at such a high
level. Even when I looked into the mySQL C api I didn't see anything that
wo
On 2002-03-27, Eric Frazier <[EMAIL PROTECTED]> wrote:
> If you have any idea where to find this code I would be thankful. I can
> only find this..
[snip]
> At 04:47 PM 3/26/02 -0500, John D Groenveld wrote:
> > Jeff Horn posted this a couple years ago either here or @ dbi-users
> >
> > # Purpos
Hi,
If you have any idea where to find this code I would be thankful. I can only
find this..
http://aspn.activestate.com/ASPN/Mail/Message/perl-DBI/298774
Thanks,
Eric
At 04:47 PM 3/26/02 -0500, John D Groenveld wrote:
>> There are databases that allow you to change the current user withou
> There are databases that allow you to change the current user without
> reconnecting. In fact someone posted a module to do this a while back,
> but I can't remember which database it was for. Seems like it was
> Sybase or Informix.
Jeff Horn posted this a couple years ago either here or @
Ed Grimm wrote:
> First, I'll suggest that there are hopefully other areas you can look at
> optimizing that will get you a bigger bang for your time - in my test
> environment (old hardware), it takes 7.4 ms per
> disconnect/reconnect/rebind and 4.8 ms per rebind. Admittedly, I'm
> dealing with
Hi,
It might well be that in my particular case, I don't have anything to worry
about the connection time per each user most likely won't kill me or even
cause problems at first. But I am trying to build a system, and I don't want
to skip any reasonable efficences I can build in from the start.
On Sun, 24 Mar 2002, Andrew Ho wrote:
>>What would be ideal is if the database would allow you to change the
>>user on the current connection. I know PostgreSQL will allow this
>>using the command line interface psql tool (just do \connect
>> ), but I'm not sure if you can do this using DBI.
>>
Hello,
CH>What would be ideal is if the database would allow you to change the
CH>user on the current connection. I know PostgreSQL will allow this using
CH>the command line interface psql tool (just do \connect
CH>), but I'm not sure if you can do this using DBI.
CH>
CH>Does anyone know if any
On Fri, 2002-03-22 at 11:42, Andrew Ho wrote:
> Hello,
>
> EF>I will have many different users, users as in database users. So am I
> EF>just screwed and won't be able to keep connections open?
>
> Do you mean users as in actual RDBMS level users? In other words, when you
> say database users yo
We encountered just this situation when we started to move from a win32
application connecting to an RDBMS to a web based app. On the win32
app, the DB authenticated each user with a loginid/pw. Since some users
still use the win32 app, we can't just abandon the DB authentication, so
here's
Hello,
EF>I will have many different users, users as in database users. So am I
EF>just screwed and won't be able to keep connections open?
Do you mean users as in actual RDBMS level users? In other words, when you
say database users you mean different username/passwords used from, say,
a comman
Hi,
I was all happy and rolling along when I read this in the docs.
"With this limitation in mind, there are scenarios, where
the usage of Apache::DBI is depreciated. Think about a
heavy loaded Web-site where every user connects to the
database with a unique userid. Every s
13 matches
Mail list logo