[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Sql-Mode - getting query results from MS SQL Server 2000
From: |
Brett Kelly |
Subject: |
Sql-Mode - getting query results from MS SQL Server 2000 |
Date: |
Wed, 15 Jun 2005 12:29:35 -0700 |
User-agent: |
Mutt/1.5.9i |
Hello All,
Let me preface by saying that I'm pretty new to emacs, so I apologize in
advance if I've missed something obvious. I'm using emacs 21.3.1 on windows
xp professional.
I've read the SqlMode page on the wiki as well as the sql-help from within
emacs, but I still can't figure out how to do this.
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.
Can anybody tell me what I'm doing wrong?
Thanks!
--
Brett Kelly
inkedmn@inkedmn.com
http://inkedmn.com:8000
GPG Public Key: http://inkedmn.com:8000/stuff/inkedmn.asc
signature.asc
Description: Digital signature