Thanks Jennifer


I was looking for a way to actually send SQL commands to a database from a
dos box. The answer turns out to be isql which is a command line interface
to MSSQL Server. Using some commands like

isql -D MyDB -Q "Create Database MyTable"
or
isql -D MyDB -Q "Alter Table ......"

You can interact directly with SQL server from DOS.

I needed to do this because I am working on an installation for the product
I manage called eMPower, which if installed on NT with SQLServer installed
will actually create and populate an SQL database during the installation
process and create the DSN to go with it.

Duane Boudreau
CFExperts.Com


-----Original Message-----
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 5:50 PM
To: [EMAIL PROTECTED]
Subject: Re: OT: Command Line SQL7


If by "command line" interface, you mean a section of the program that will
let you enter and edit SQL statements, there should be a button in the
toolbar that will give you that. If that's not what you mean, I don't know
how to help you.

At 12:29 PM 4/25/00 -0400, you wrote:
>Hi All,
>
>This is OT, but does anyone know of a way to get to the MSSQL7 command line
>interface? I've been thru the MSDN but can find reference to it.
>
>TIA,
>Duane
>Director, Web Technologies
>Ektron, Inc.
>http://www.ektron.com
>5 Northern Blvd, Suite 6
>Amherst, NH 03031
>Tel: 603-594-0249
>Fax: 603-594-0258
>ICQ#: 18024374
>Jobs: [EMAIL PROTECTED]
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.

----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to