in reply to Re: Re: DBI Not working
in thread DBI Not working

Hi Michael, great to see you here!

Now to the problem:

Perhaps it's not that hard. You filter three informal messages (5701, 5703, 5704) comming from the server.
AFAIK one of them is an 'environment' message, telling the client that the current database has changed.
You could use this message, to determine whether the database has changed.

btw. I could use this message too in a small project i'm doing at the moment. :-)
It's not hard to change DBD::Sybase, but it's not easy to have DBD::Sybase compiled in some win32 environments, so i have to wait for activestate :-(

Replies are listed 'Best First'.
Re: Re: Re: Re: DBI Not working
by mpeppler (Vicar) on Oct 19, 2001 at 22:01 UTC
    Ah, yes, good idea.

    I'll take a look to see how hard that might be, and how correct it would be.

    Also - I'd have to be reasonably sure that MS-SQL returns the same message number for this...

    Michael

Re: Re: Re: Re: DBI Not working
by mpeppler (Vicar) on Sep 09, 2003 at 16:01 UTC
    Well - it's only taken two years :-(, but this is finally fixed in DBD::Sybase 1.01, which should be on CPAN now.

    Michael