RE: [h-e-w] running microsoft osql from comint buffer

[Sprenger, Karel]

Andrew,

Just a wild guess: do you follow your SQL command with "go" on a new line?  If 
I do that, I get the output of the command.  For example, connecting to the 
pubs database in the local server:

  select distinct count(*) from authors
  go
  1> 2>
   -----------
            23

This is with the default isql command processor, but osql works just as well.

Cheers,
Karel

-----Original Message-----
From: Andrew Platts [mailto:address@hidden
Sent: donderdag 11 april 2002 19:44
To: address@hidden
Subject: [h-e-w] running microsoft osql from comint buffer


Does anyone know how to run microsoft osql/isql thru
the sql-ms function provided in sql.el so that
feedback is given to the buffer as commands are
executed. Under emacs 21.2  (and probably previous 
versions) you get no prompt or output until you type
exit - not quite what I was hoping for.

According to MS documentation osql is a win 32 command
prompt utility (I'm thinking like sqlplus for ORACLE )
so I'm not sure why it doesn't operate in an emacs
buffer in the same way it would from a win 2k command
propmt window.



__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/