unofficial mirror of help-gnu-emacs@gnu.org
 help / color / mirror / Atom feed
From: Tim X <timx@spamto.devnul.com>
Subject: Re: Sql-Mode - getting query results from MS SQL Server 2000
Date: 17 Jun 2005 15:53:24 +1000	[thread overview]
Message-ID: <87psulpm0b.fsf@tiger.rapttech.com.au> (raw)
In-Reply-To: mailman.253.1118951199.2857.help-gnu-emacs@gnu.org

Brett Kelly <inkedmn@inkedmn.com> writes:

> Sometime around Thu, Jun 16, 2005 at 12:15:57PM -0600, Kevin Rodgers said:
> > Brett Kelly wrote:
> > > I'd like to be able to type in a sql query and have it return a 
> > resultset in a
> > > different buffer (a la Query Analyzer).  Here's what I'm doing now:
> > > - Create a new buffer, do M-x sql-ms RET, then enter the relevant 
> > connection
> > >   information (user, password, server, dbname). This gives me no errors.
> > > - Type in my SQL statement (I've tried simple "select" statements, as 
> > well as
> > >   more complicated "create proc" type stuff)
> > > - Highlight the relevant code with the mouse, and choose Send Region 
> > from the
> > >   SQL menu.
> > >
> > > Now, if I'm understanding this correctly, I should see the results in 
> > a new
> > > buffer, but I'm not.
> > 
> > From the commentary at the top of sql.el excerpted below, I guess that
> > you are typing your SQL statement directly into the sql-interactive-mode
> > *SQL* buffer.  If you enter them in some other sql-mode buffer, Send
> > Region should cause the *SQL* buffer with the results to be displayed
> > (see sql-pop-to-buffer-after-send-region).
> > 
> > ;; This file provides a sql-mode and a sql-interactive-mode.  The
> > ;; interactive mode had to provide a command-line history; the other
> > ;; mode had to provide "send region/buffer to SQL interpreter"
> > ;; functions.
> > 
> > ;; sql-interactive-mode is used to interact with a SQL interpreter
> > ;; process in a SQLi buffer (usually called `*SQL*').  The SQLi buffer
> > ;; is created by calling a SQL interpreter-specific entry function.  Do
> > ;; *not* call sql-interactive-mode by itself.
> > 
> > ;; sql-mode can be used to keep editing SQL statements.  The SQL
> > ;; statements can be sent to the SQL process in the SQLi buffer.
> > 
> > -- 
> > Kevin Rodgers
> > 
> > 
> > 
> > _______________________________________________
> > Help-gnu-emacs mailing list
> > Help-gnu-emacs@gnu.org
> > http://lists.gnu.org/mailman/listinfo/help-gnu-emacs
> > 
> 
> Kevin  - thanks for the reply.  Unfortunately, this still doesn't seem to be
> working.
> 
> Went through the followig steps:
> 
> - Opened up a .sql file in a new buffer, called TestSQL.sql
> - Checked "Pop to SQLi Buffer after Send" in the SQL menu
> - ran M-x sql-ms RET which created a new SQLi buffer called *SQL*
> - In the TestSQL.sql buffer, i chose Set SQLi buffer from the
>   SQL menu, and set it to *SQL*
> - I wrote a simple select statement in TestSQL.sql, highlighted it, and chose
>   "send region" from the sql menu.
> - In the minibuffer, it says "string sent to buffer *SQL*"
> 
> And that's it, I get no other output beside that.
> 
> -- 
> Brett Kelly
> inkedmn@inkedmn.com
> http://inkedmn.com:8000
> GPG Public Key: http://inkedmn.com:8000/stuff/inkedmn.asc

Brett,

Are you sure emacs is communicating with the SQL process? Keep in mind
that emacs cannot/does not communicate directly with the database - it
communicates with some program which then communicates with the
database. I don't know anything about MS SQL Server, but with Oracle
(as an example), Emacs SQL mode communicates with sqlplus, which is
Oracle's interface program for entering sql commands. I imagine SQL
Server has something similar. You need to ensure that emacs is
communicating with this program and the program is in turn
communicating with the SQL Server.

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!

  parent reply	other threads:[~2005-06-17  5:53 UTC|newest]

Thread overview: 8+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2005-06-15 19:29 Sql-Mode - getting query results from MS SQL Server 2000 Brett Kelly
2005-06-16 18:15 ` Kevin Rodgers
2005-06-16 19:37   ` Brett Kelly
2005-06-16 21:38   ` Brett Kelly
2005-06-16 22:35     ` Ryan Bowman
2005-06-17 15:47     ` Michael Mauger
     [not found]   ` <mailman.253.1118951199.2857.help-gnu-emacs@gnu.org>
2005-06-17  5:53     ` Tim X [this message]
2005-06-16 19:52 ` Michael Mauger

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.gnu.org/software/emacs/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87psulpm0b.fsf@tiger.rapttech.com.au \
    --to=timx@spamto.devnul.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).