Sorry to hear about the lack of FLUSHMESSAGE in MS. I assumed that this command was still hanging around, after all, the code base for MS was originally Sybase.( many moons and version ago).
Chuck
[EMAIL PROTECTED] wrote:
On Wed, Sep 17, 2003 at 05:10:21PM -0700, "David L. Good" <[EMAIL PROTECTED]> wrote:
On Tue, Sep 16, 2003 at 02:21:54PM -0400, Chuck Fox <[EMAIL PROTECTED]> wrote:
Dave,
The command is for the dataserver that you are using. I assumed that the DBCC command was directed at a MS or Sybase Sql Server. Whether you are using DBD:ODBC or DBD:Sybase the effect is the same, it causes the dataserver to flush its buffers out to the application. DBD:ODBC is just a transport mechanism for the dbcc command or whatever command you are passing.
OK, but it works fine (no buffering) using DBD::Sybase on Unix platforms without using the 'SET FLUSHMESSAGE ON', but doesn't when using DBD::ODBC on Win32. I'll see if I can give your suggestion a try, though. It'd be great if it works!
Hmmm. Sybase has FLUSHMESSAGE, but MS-SQL Server 2000 does not. Since I don't have Sybase's ODBC driver installed (and don't really need to access Sybase from Windows) I'm kinda stuck.
In any case, I was interested in a solution for SQL Server, so I guess I'm out of luck :-(