Manager Sql Server Developer It .Net Time Enterprise
Resume:
Grokbase Groups Perl dbi-users December ****
Groups
Users
Badges
[DBI-users] [OT] SQL console for MSSQL
Extern Lars Oeschey
Dec 17, 2002 at 1:17 pm
Hi,
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements
regards, Lars
reply
Tweet
Search Discussions
All Groups Perl dbi-users
12 responses
Nested Oldest
Kris Wolff Why not direkt Via ssh, or Phpmyadmin ( webbased ) Or just Mysql/bin/mysql -h ipadress of host -u username kris On 17.12.2002 14:16 Uhr, "******.****.*******@****.**" wrote:
Kris Wolff at Dec 17, 2002 at 2:06 pm
Why not direkt
Via ssh, or
Phpmyadmin ( webbased )
Or just
Mysql/bin/mysql -h ipadress of host -u username
kris
On 17.12.2002 14:16 Uhr, "******.****.*******@****.**"
wrote:
Hi,
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements
regards, Lars
reply permalink
Extern Lars Oeschey of course I do that with my Linux-Box and MySql. Problem here is, that MSSQL usually runs on Windows machines without ssh or anything else ;) Lars
Extern Lars Oeschey at Dec 17, 2002 at 2:08 pm
Mysql/bin/mysql -h ipadress of host -u username
kris
of course I do that with my Linux-Box and MySql. Problem here is, that MSSQL
usually runs on Windows machines without ssh or anything else ;)
Lars
reply permalink
Kris Wolff Ah sorry mssql ... 2 ways: VNC or Odbc over Access. Or a perl client I always done the vnc thing. kris On 17.12.2002 15:08 Uhr, "******.****.*******@****.**" wrote:
Kris Wolff at Dec 17, 2002 at 2:10 pm
Ah sorry mssql ...
2 ways:
VNC or
Odbc over Access.
Or a perl client
I always done the vnc thing.
kris
On 17.12.2002 15:08 Uhr, "******.****.*******@****.**"
wrote:
Mysql/bin/mysql -h ipadress of host -u username
kris
of course I do that with my Linux-Box and MySql. Problem here is, that MSSQL
usually runs on Windows machines without ssh or anything else ;)
Lars
reply permalink
Extern Lars Oeschey hm, sounds like much overhead... I thought there's some easy Dosbox tool like for DB2 for a few quick statements... cause even with vnc I'd have to click me through that Enterprise Manager until i see some contents of a table... Lars
Extern Lars Oeschey at Dec 17, 2002 at 2:13 pm
VNC or
Odbc over Access.
kris
hm, sounds like much overhead... I thought there's some easy Dosbox tool
like for DB2 for a few quick statements... cause even with vnc I'd have to
click me through that Enterprise Manager until i see some contents of a
table...
Lars
reply permalink
Kris Wolff I worked a lot on mssql but I have to say, I do not know much, because I do not like it ! I ve I need a comercial fast sql server I buy sybase And not this silly slow up // hard ministratiing tool. Anyway if you just need the results from a mssql server table why not build up a perl client ( 5 lines ) // contect .. Ask for sql Print out results Loop. Isn't that easy,hm If you have some time and want a nicer tool in the future you can build a tk araund this... I build up a lot of
Kris Wolff at Dec 17, 2002 at 2:23 pm
I worked a lot on mssql but I have to say, I do not know much, because I do
not like it ! I ve I need a comercial fast sql server I buy sybase And
not this silly slow up // hard ministratiing tool.
Anyway if you just need the results from a mssql server table why not build
up a perl client ( 5 lines )
// contect ..
Ask for sql
Print out results
Loop.
Isn't that easy,hm If you have some time and want a nicer tool in the
future you can build a tk araund this...
I build up a lot of these litle helpers, but sorry I can't send because I am
not in my office this week. But I am sure you can do it by your own, are you
kris
On 17.12.2002 15:13 Uhr, "******.****.*******@****.**"
wrote:
VNC or
Odbc over Access.
kris
hm, sounds like much overhead... I thought there's some easy Dosbox tool
like for DB2 for a few quick statements... cause even with vnc I'd have to
click me through that Enterprise Manager until i see some contents of a
table...
Lars
reply permalink
Kris Wolff By the way. Theere is a ADO out. Why using ODBC in a win2win net You will just need it if you work on a unix or mac box. ADO is more faster and better to handle with. I supose you can do Ado-Connections with Accsess Viwe the docs. Kris n 17.12.2002 15:23 Uhr, "Kris Wolff" wrote:
Kris Wolff at Dec 17, 2002 at 2:32 pm
By the way. Theere is a ADO out. Why using ODBC in a win2win net You
will just need it if you work on a unix or mac box. ADO is more faster and
better to handle with.
I supose you can do Ado-Connections with Accsess Viwe the docs.
Kris
n 17.12.2002 15:23 Uhr, "Kris Wolff" wrote:
I worked a lot on mssql but I have to say, I do not know much, because I do
not like it ! I ve I need a comercial fast sql server I buy sybase And
not this silly slow up // hard ministratiing tool.
Anyway if you just need the results from a mssql server table why not build
up a perl client ( 5 lines )
// contect ..
Ask for sql
Print out results
Loop.
Isn't that easy,hm If you have some time and want a nicer tool in the
future you can build a tk araund this...
I build up a lot of these litle helpers, but sorry I can't send because I am
not in my office this week. But I am sure you can do it by your own, are you
kris
On 17.12.2002 15:13 Uhr, "******.****.*******@****.**"
wrote:
VNC or
Odbc over Access.
kris
hm, sounds like much overhead... I thought there's some easy Dosbox tool
like for DB2 for a few quick statements... cause even with vnc I'd have to
click me through that Enterprise Manager until i see some contents of a
table...
Lars
reply permalink
Edwards, Mark (CXO) osql comes with the client tools. If you have Enterprise Manager, then you've got it. H:\>osql / usage: osql [-U login id] [-P password] [-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout] [-h headers] [-s colseparator] [-w columnwidth] [-a packetsize] [-e echo input] [-I Enable Quoted Identifiers] [-L list servers] [-c cmdend] [-D ODBC DSN name] [-q "cmdline query"] [-Q "cmdline query" and exit] [-n remove numbering] [-m errorlevel]
Edwards, Mark (CXO) at Dec 17, 2002 at 3:19 pm
osql comes with the client tools. If you have Enterprise Manager, then
you've got it.
H:\>osql /
usage: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted
Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-O use Old ISQL behavior disables the following]
batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[- show syntax summary]
Original Message
From: ******.****.*******@****.**
Sent: Tuesday, December 17, 2002 7:14 AM
To: ***-*****@****.***
Subject: RE: [OT] SQL console for MSSQL
Importance: Low
VNC or
Odbc over Access.
kris
hm, sounds like much overhead... I thought there's some easy Dosbox tool
like for DB2 for a few quick statements... cause even with vnc I'd have
to click me through that Enterprise Manager until i see some contents of
a table...
Lars
reply permalink
Extern Lars Oeschey I thought that there should be something with it... though the enterprise manager is on the server, can I install it also locally Lars
Extern Lars Oeschey at Dec 17, 2002 at 3:47 pm
osql comes with the client tools. If you have Enterprise
Manager, then
you've got it.
I thought that there should be something with it... though the enterprise
manager is on the server, can I install it also locally
Lars
reply permalink
Aine Quoth : : > osql comes with the client tools. If you have Enterprise : > Manager, then : > you've got it. : : I thought that there should be something with it... though the enterprise : manager is on the server, can I install it also locally Yes, you can install MS SQL client tools on WinNT workstation or XP of any varient (not sure about 9x.) If installing on XP, it'll give you the option to install SQL Server components, as well, as you can run a SQL Server on XP, so mind that in the
Aine at Dec 17, 2002 at 5:23 pm
Quoth :
: > osql comes with the client tools. If you have Enterprise
: > Manager, then
: > you've got it.
:
: I thought that there should be something with it... though the enterprise
: manager is on the server, can I install it also locally
Yes, you can install MS SQL client tools on WinNT workstation or XP of any
varient (not sure about 9x.) If installing on XP, it'll give you the option
to install SQL Server components, as well, as you can run a SQL Server on
XP, so mind that in the install.
~ A.
reply permalink
K. Brian Kelley The MS SQL Server client tools install on any build from 9x up and from NT 4.0 up (two different paths). Win2K and XP are part of the NT kernel line. Enterprise Manager is okay, but it's a lot of overhead. You'll probably want to use Query Analyzer (isqlw.exe). It's GUI, but it's easier to use than isql or osql, mainly because if you need to modify a query just slightly and re-run it, it's loads easier... and this is coming from a sworn command-line junkie (hence the reason I also use Perl). --
K. Brian Kelley at Dec 24, 2002 at 5:20 am
The MS SQL Server client tools install on any build from 9x up and from NT
4.0 up (two different paths). Win2K and XP are part of the NT kernel line.
Enterprise Manager is okay, but it's a lot of overhead. You'll probably want
to use Query Analyzer (isqlw.exe). It's GUI, but it's easier to use than
isql or osql, mainly because if you need to modify a query just slightly and
re-run it, it's loads easier... and this is coming from a sworn command-line
junkie (hence the reason I also use Perl).
--
K. Brian Kelley
Author: Start to Finish Guide to SQL Server Performance Monitoring
(http://www.netimpress.com)
SQLServerCentral.com Columnist
http://www.truthsolutions.com/
--
"[ nI" wrote in message
news:004801c2a5f0$e8eee6a0$6cd0bdd1@idoru...
Quoth :
: > osql comes with the client tools. If you have Enterprise
: > Manager, then
: > you've got it.
:
: I thought that there should be something with it... though the
enterprise
: manager is on the server, can I install it also locally
Yes, you can install MS SQL client tools on WinNT workstation or XP of any
varient (not sure about 9x.) If installing on XP, it'll give you the option
to install SQL Server components, as well, as you can run a SQL Server on
XP, so mind that in the install.
~ A.
reply permalink
Michael Peppler Go to http://www.freetds.org to get open source client libraries that will work with MS-SQL. Then you can use ODBC or sqsh (www.sqsh.org) (or DBI/DBD::Sybase) to connect to the MSSQL server. Michael -- Michael Peppler Data Migrations, Inc. ********@*******.*** http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
Michael Peppler at Dec 17, 2002 at 4:54 pm
On Tue, 2002-12-17 at 05:16, ******.****.*******@****.** wrote:
Hi,
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements
Go to http://www.freetds.org to get open source client libraries that
will work with MS-SQL. Then you can use ODBC or sqsh (www.sqsh.org) (or
DBI/DBD::Sybase) to connect to the MSSQL server.
Michael
--
Michael Peppler Data Migrations, Inc
.
********@*******.*** http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html
reply permalink
Thomas A. Lowery Check out
DBI:
:Shell or dbish. A basic version is installed with DBI. A more advanced version is available from CPAN (requires additional modules). I often use it with to test
DBD:
:ADO. (Actually I use it with every database I work with that DBI talks with, on MS Windows, Linux, and Solaris). Tom -- Thomas A. Lowery See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
Thomas A. Lowery at Dec 18, 2002 at 12:54 am
Check out
DBI:
:Shell or dbish. A basic version is installed with
DBI. A more advanced version is available from CPAN (requires
additional modules).
I often use it with to test
DBD:
:ADO. (Actually I use it with
every database I work with that DBI talks with, on MS Windows,
Linux, and Solaris).
Tom
On Tue, Dec 17, 2002 at 02:16:04PM +0100, ******.****.*******@****.** wrote:
this is a bit offtopic: I don't want to run to the server each time I want
to check contents of some table: Is there a sqlconsole where I can just
connect to the server via ODBC and do some SQL statements
--
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
reply permalink
Related Discussions
Perl Error
[OT] Microsoft SQL Server (MSSQL) support forums
MSSQL: INSERT into table with TRIGGER
Need advice on unintended and unwanted integer conversion to decimal.
Strange results returned using Linux to MS SQL 2005 through Sybase and FreeTDS
Recovering records from corrupted MSSQL tables
ODBC w/ MS SQL
MsSQL DBD::ODBC IsNull and undef
Newbie needs help on stored procedures
Dbi and LockType ReadOnly
Discussion Navigation
view thread post
Discussion Overview
group dbi-users @
categories perl
posted Dec 17, '02 at 1:17p
active Dec 24, '02 at 5:20a
posts 13
users 7
website dbi.perl.org
Preferences
responses expanded Hotkey: s
font variable Hotkey: f
user style avatars Hotkey: a
7 users in discussion
Kris Wolff (4)
Extern Lars Oeschey (4)
Michael Peppler (1)
Thomas A. Lowery (1)
K. Brian Kelley (1)
Edwards, Mark (CXO) (1)
Aine (1)
Content
Home
Groups & Organizations
People
Users
Badges
Support
Welcome
F.A.Q.
Contact Us
Translate
site design / logo c 2012 Grokbase
Contact this candidate