f



Running sql.el 2.0.1 (from CVS) on Emacs 21.3.1 on Windows XP

I downloaded sql.el from savannah, and tried to run it on Emacs 21.3.1
(from the fullbin tarball). It compiled with some warnings, see below.
When I tried to sql-ms all I got was an empty buffer, no prompt 
and no error message.


 
Compiling file h:/emacs/sql.el at Mon Jun 14 13:07:46 2004
  ** define-abbrev called with 6 arguments, but accepts only 3-5
  ** reference to free variable font-lock-preprocessor-face

While compiling sql-query-placeholders-and-send:
  ** reference to free variable comint-input-sender-no-newline

While compiling sql-escape-newlines-and-send:
  ** reference to free variable comint-input-sender-no-newline

While compiling the end of the data:
  ** The following functions are not known to be defined:
    set-keymap-parents, set-keymap-name, font-lock-mode-internal,
    ange-ftp-read-passwd

-- 
Fredrik Stax\"ang | rot13: sfgk@hcqngr.hh.fr
0
u (3)
6/14/2004 11:52:38 AM
comp.emacs 4822 articles. 1 followers. Post Follow

4 Replies
736 Views

Similar Articles

[PageSpeed] 31

Hi Fredrik,


Fredrik Staxeng <fstx+u@update.uu.se> writes:
> When I tried to sql-ms all I got was an empty buffer, no prompt and
> no error message.

Probably your SQL shell does run, it just doesn't say anything.  The
most common problems in my experience:

Buffering

  See <http://www.gnu.org/software/emacs/windows/faq7.html> about
  that.

Subprocess doesn't run in "interactive" mode

  Many shells have a special "interactive" mode, showing prompts and
  having their I/O line buffered.  But they only switch that on when
  they detect that a terminal is connected to their stdin/stdout.  On
  Unix pseudo-ttys are used to tell a subprocess that Emacs is a kind
  of terminal, but Windows doesn't have that concept.  Some tools have
  a command-line switch to force "interactive" mode.


benny
0
Benjamin
6/14/2004 2:19:46 PM
Benjamin Riefenstahl <Benjamin.Riefenstahl@epost.de> writes:

>Hi Fredrik,
>
>
>Fredrik Staxeng <fstx+u@update.uu.se> writes:
>> When I tried to sql-ms all I got was an empty buffer, no prompt and
>> no error message.
>
>Probably your SQL shell does run, it just doesn't say anything.  The
>most common problems in my experience:

Perhaps, but I did not change the defaults (from sql.el):

(defcustom sql-ms-program "osql" ...)
(defcustom sql-ms-options '("-w" "300" "-n") ... )

Presumably it did work for the person who did the change to use osql.

-- 
Fredrik Stax\"ang | rot13: sfgk@hcqngr.hh.fr
This is all you need to know about vi: ESC : q ! RET
0
Fredrik
6/15/2004 5:16:42 AM
>>>>> "Fredrik" == Fredrik Staxeng <fstx+u@update.uu.se> writes:

 Fredrik> I downloaded sql.el from savannah, and tried to run it on
 Fredrik> Emacs 21.3.1 (from the fullbin tarball). It compiled with
 Fredrik> some warnings, see below.  When I tried to sql-ms all I got
 Fredrik> was an empty buffer, no prompt and no error message.


 
 Fredrik> Compiling file h:/emacs/sql.el at Mon Jun 14 13:07:46 2004
 Fredrik> ** define-abbrev called with 6 arguments, but accepts only
 Fredrik> 3-5 ** reference to free variable
 Fredrik> font-lock-preprocessor-face

 Fredrik> While compiling sql-query-placeholders-and-send: **
 Fredrik> reference to free variable comint-input-sender-no-newline

 Fredrik> While compiling sql-escape-newlines-and-send: ** reference
 Fredrik> to free variable comint-input-sender-no-newline

 Fredrik> While compiling the end of the data: ** The following
 Fredrik> functions are not known to be defined: set-keymap-parents,
 Fredrik> set-keymap-name, font-lock-mode-internal,
 Fredrik> ange-ftp-read-passwd

Well, I don't know if I can provide much help. However, the warning
about abbrev being called with too many arguments is something I
reported to Alex as a bug quite sometime ago (like over a year). It
could be the sql.el in CVS is not his latest version. I would
recommend checking out sql.el at the emacs wiki site, as Alex also
runs that site and his most recent code is likely to be there.

I've not used sql.el with MS, but have found apart from the abbrev
error that it works very well with Oracle and Postgres and MySQL. I've
not used it for a while now, but the version I was using was from the
emacs wiki site at http://www.emacswiki.org

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!
0
Tim
6/15/2004 8:50:55 AM
Tim X <timx@spamto.devnul.com> writes:

>>>>>> "Fredrik" == Fredrik Staxeng <fstx+u@update.uu.se> writes:
>
> Fredrik> I downloaded sql.el from savannah, and tried to run it on
> Fredrik> Emacs 21.3.1 (from the fullbin tarball). It compiled with
> Fredrik> some warnings, see below.  When I tried to sql-ms all I got
> Fredrik> was an empty buffer, no prompt and no error message.
>
>
> 
> Fredrik> Compiling file h:/emacs/sql.el at Mon Jun 14 13:07:46 2004
> Fredrik> ** define-abbrev called with 6 arguments, but accepts only
> Fredrik> 3-5 ** reference to free variable
> Fredrik> font-lock-preprocessor-face
>
> Fredrik> While compiling sql-query-placeholders-and-send: **
> Fredrik> reference to free variable comint-input-sender-no-newline
>
> Fredrik> While compiling sql-escape-newlines-and-send: ** reference
> Fredrik> to free variable comint-input-sender-no-newline
>
> Fredrik> While compiling the end of the data: ** The following
> Fredrik> functions are not known to be defined: set-keymap-parents,
> Fredrik> set-keymap-name, font-lock-mode-internal,
> Fredrik> ange-ftp-read-passwd
>
>Well, I don't know if I can provide much help. However, the warning
>about abbrev being called with too many arguments is something I
>reported to Alex as a bug quite sometime ago (like over a year). It
>could be the sql.el in CVS is not his latest version. I would
>recommend checking out sql.el at the emacs wiki site, as Alex also
>runs that site and his most recent code is likely to be there.
>
>I've not used sql.el with MS, but have found apart from the abbrev
>error that it works very well with Oracle and Postgres and MySQL. I've
>not used it for a while now, but the version I was using was from the
>emacs wiki site at http://www.emacswiki.org


Thanks anyway. 

I solved my immediate problem, to connect using a trusted connection,
by cutting a few lines from the savannah version, and pasting it 
into the version that came with my emacs. The version numbers 
of the different versions I found are as follows:

emacs 21.3       1.6.3
emacswiki        1.7.0
savannah         2.0.1



-- 
Fredrik Stax\"ang | rot13: sfgk@hcqngr.hh.fr
This is all you need to know about vi: ESC : q ! RET
0
Fredrik
6/16/2004 7:38:23 AM
Reply: