OSQL UserName and PWd

[gopal]

Hi,

I have a console application whose purpose is to run the OSQL utility
from
my console application.
When my application is run, the OSQL utility is started and it has to
prompt for Database UserName & Password [Database Name & SQL files will

be provided as other options for this OSQL].
But i am having problems in getting from the prompt, Database -
UserName & Password
Once I get userName & Password, i already have the Database Server Name

& SQL file
Now i will install the SQL files on the particular database

Here is the code
static void Main(string[] args)
{
String[] sConnectionStri ng;
try
{
ProcessStartInf o psi = new ProcessStartInf o("osql.exe", "-Usa
-Psa");
psi.RedirectSta ndardOutput=fal se;
psi.RedirectSta ndardInput=fals e;
psi.RedirectSta ndardError=fals e;
psi.UseShellExe cute=false;
psi.CreateNoWin dow=true;
Process proc = Process.Start (psi);
ProcessOutputRe ader por = new ProcessOutputRe ader (proc);
por.Start();
proc.StandardIn put.WriteLine (@"go");
Console.ReadLin e();
proc.StandardIn put.WriteLine ("Hello");
proc.StandardIn put.WriteLine ("there");
}
catch (Exception e)
{
Console.WriteLi ne("{0}",e.ToSt ring());
}
}
class ProcessOutputRe ader
{
Process proc;
public ProcessOutputRe ader (Process proc)
{
this.proc = proc;
}
public void Start()
{
new Thread (new
ThreadStart(Rea dAll)).Start();
}
void ReadAll()
{
StreamReader reader =
proc.StandardOu tput;
string line;
while ((line =
reader.ReadLine ())!=null)
Console.WriteLi ne ("Process
output: {0}", line);
}
}
}

[PS]

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .

Hi,

I have a console application whose purpose is to run the OSQL utility
from
my console application.
When my application is run, the OSQL utility is started and it has to
prompt for Database UserName & Password [Database Name & SQL files will

be provided as other options for this OSQL].
But i am having problems in getting from the prompt, Database -
UserName & Password
Once I get userName & Password, i already have the Database Server Name

& SQL file
Now i will install the SQL files on the particular database

Here is the code
static void Main(string[] args)
{
String[] sConnectionStri ng;
try
{
ProcessStartInf o psi = new ProcessStartInf o("osql.exe", "-Usa
-Psa");

You want to use -U sa -P sa with the spaces.

PS

psi.RedirectSta ndardOutput=fal se;
psi.RedirectSta ndardInput=fals e;
psi.RedirectSta ndardError=fals e;
psi.UseShellExe cute=false;
psi.CreateNoWin dow=true;
Process proc = Process.Start (psi);
ProcessOutputRe ader por = new ProcessOutputRe ader (proc);
por.Start();
proc.StandardIn put.WriteLine (@"go");
Console.ReadLin e();
proc.StandardIn put.WriteLine ("Hello");
proc.StandardIn put.WriteLine ("there");
}
catch (Exception e)
{
Console.WriteLi ne("{0}",e.ToSt ring());
}
}
class ProcessOutputRe ader
{
Process proc;
public ProcessOutputRe ader (Process proc)
{
this.proc = proc;
}
public void Start()
{
new Thread (new
ThreadStart(Rea dAll)).Start();
}
void ReadAll()
{
StreamReader reader =
proc.StandardOu tput;
string line;
while ((line =
reader.ReadLine ())!=null)
Console.WriteLi ne ("Process
output: {0}", line);
}
}
}

[PS]

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .

Hi,

I have a console application whose purpose is to run the OSQL utility
from
my console application.
When my application is run, the OSQL utility is started and it has to
prompt for Database UserName & Password [Database Name & SQL files will

be provided as other options for this OSQL].
But i am having problems in getting from the prompt, Database -
UserName & Password
Once I get userName & Password, i already have the Database Server Name

& SQL file
Now i will install the SQL files on the particular database

Here is the code
static void Main(string[] args)
{
String[] sConnectionStri ng;
try
{
ProcessStartInf o psi = new ProcessStartInf o("osql.exe", "-Usa
-Psa");

Also I think you will need to specify server -S and database name -d

so you end up with the equivalent of

osql -S myServer -d myDatabase -U user -P password

psi.RedirectSta ndardOutput=fal se;
psi.RedirectSta ndardInput=fals e;
psi.RedirectSta ndardError=fals e;
psi.UseShellExe cute=false;
psi.CreateNoWin dow=true;
Process proc = Process.Start (psi);
ProcessOutputRe ader por = new ProcessOutputRe ader (proc);
por.Start();
proc.StandardIn put.WriteLine (@"go");
Console.ReadLin e();
proc.StandardIn put.WriteLine ("Hello");
proc.StandardIn put.WriteLine ("there");
}
catch (Exception e)
{
Console.WriteLi ne("{0}",e.ToSt ring());
}
}
class ProcessOutputRe ader
{
Process proc;
public ProcessOutputRe ader (Process proc)
{
this.proc = proc;
}
public void Start()
{
new Thread (new
ThreadStart(Rea dAll)).Start();
}
void ReadAll()
{
StreamReader reader =
proc.StandardOu tput;
string line;
while ((line =
reader.ReadLine ())!=null)
Console.WriteLi ne ("Process
output: {0}", line);
}
}
}

[Willy Denoyette [MVP]]

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .
| Hi,
|
| I have a console application whose purpose is to run the OSQL utility
| from
| my console application.
|
|
| When my application is run, the OSQL utility is started and it has to
| prompt for Database UserName & Password [Database Name & SQL files will
|
| be provided as other options for this OSQL].
|
|
osql will not prompt for the password, you have to pass all arguments to the
osql command before strting osql.
That means you prompt the user to enter the arguments, read them using
ReadLine(), parse them and pass them to the argument string in your
Process.Start command.

Willy.

[gopal]

Hi Willy,

Is it something

1. call the OSQL with parameters of User, Password, Server, SQL files
[any order I guess]

2. Once the authentication is done, get the User & Pwd from, prompt the
user
as thogh he is entering the U & Pwd, then start installing the SQL
files?

Are these two steps in right order? Can you if you can send me the
possible code. I would be greatful to learn about this.

Thanks
JP

Willy Denoyette [MVP] wrote:

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .
| Hi,
|
| I have a console application whose purpose is to run the OSQL utility
| from
| my console application.
|
|
| When my application is run, the OSQL utility is started and it has to
| prompt for Database UserName & Password [Database Name & SQL files will
|
| be provided as other options for this OSQL].
|
|
osql will not prompt for the password, you have to pass all arguments to the
osql command before strting osql.
That means you prompt the user to enter the arguments, read them using
ReadLine(), parse them and pass them to the argument string in your
Process.Start command.

Willy.

[Willy Denoyette [MVP]]

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
| Hi Willy,
|
| Is it something
|
| 1. call the OSQL with parameters of User, Password, Server, SQL files
| [any order I guess]
|
| 2. Once the authentication is done, get the User & Pwd from, prompt the
| user
| as thogh he is entering the U & Pwd, then start installing the SQL
| files?
|
| Are these two steps in right order? Can you if you can send me the
| possible code. I would be greatful to learn about this.
|
| Thanks
| JP
|

No, the right order is:
1. Prompt the user and password ...
2. Use the values from above to connect to SQL server using osql.

Something like this to get you started...

string server = "someSQLInstanc e";
string user, password;
// Prompt user to enter user and password
Console.Write(" Enter User:");
user = Console.ReadLin e();
Console.Write(" Enter Password:");
password = Console.ReadLin e();
string osqlArgs = String.Format(" /S {0} /U {1} /P {2}", server, user,
password);
....

ProcessStartInf o psi = new ProcessStartInf o("osql.exe",os qlArgs);
// rest of your code
//....

Willy.

[gopal]

Willy

I had tried the foll code, seems its working okay, but i have couple of
points to be clarified, the following is the code, can you pls verify
the code..

I want the password to be entered as ******, not as actual characters,
i am getting the output as

Enter User:sa
Enter Password:sa
Process output: 123(1 row affected)
Process output: (1 row affected)

i want to supress the 1>2>3 and want to display only the number of rows
affected as
1 row affected

using System.IO;
using System.Diagnost ics;
using System;
using System.Threadin g;

public class class1
{
static void Main()
{
string server;
string user, password,SQLFil e;
SQLFile = "tbContact.sql" ;

Console.Write(" Enter User:");
user = Console.ReadLin e();
Console.Write(" Enter Password:");
password = Console.ReadLin e();
string osqlArgs = String.Format(" /S {0} /D {1} /U {2} /P {3} /i {4}",
"local","mySVR" ,user,password, SQLFile);
ProcessStartInf o psi = new ProcessStartInf o("osql.exe",os qlArgs);
psi.UseShellExe cute=false;
psi.CreateNoWin dow=true;
psi.RedirectSta ndardOutput=tru e;
Process proc = Process.Start (psi);
ProcessOutputRe ader po = new ProcessOutputRe ader(proc);
po.Start();
}

class ProcessOutputRe ader
{
Process proc;
public ProcessOutputRe ader (Process proc)
{
this.proc = proc;
}

public void Start()
{
new Thread (new ThreadStart(Rea dAll)).Start();
}

void ReadAll()
{
StreamReader reader = proc.StandardOu tput;
string line;
while ((line = reader.ReadLine ())!=null)
Console.WriteLi ne ("Process output: {0}", line);
}
}
}

Willy Denoyette [MVP] wrote:

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
| Hi Willy,
|
| Is it something
|
| 1. call the OSQL with parameters of User, Password, Server, SQL files
| [any order I guess]
|
| 2. Once the authentication is done, get the User & Pwd from, prompt the
| user
| as thogh he is entering the U & Pwd, then start installing the SQL
| files?
|
| Are these two steps in right order? Can you if you can send me the
| possible code. I would be greatful to learn about this.
|
| Thanks
| JP
|

No, the right order is:
1. Prompt the user and password ...
2. Use the values from above to connect to SQL server using osql.

Something like this to get you started...

string server = "someSQLInstanc e";
string user, password;
// Prompt user to enter user and password
Console.Write(" Enter User:");
user = Console.ReadLin e();
Console.Write(" Enter Password:");
password = Console.ReadLin e();
string osqlArgs = String.Format(" /S {0} /U {1} /P {2}", server, user,
password);
....

ProcessStartInf o psi = new ProcessStartInf o("osql.exe",os qlArgs);
// rest of your code
//....

Willy.

[Willy Denoyette [MVP]]

"gopal" <go*********@gm ail.comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
| Willy
|
| I had tried the foll code, seems its working okay, but i have couple of
| points to be clarified, the following is the code, can you pls verify
| the code..
|
| I want the password to be entered as ******, not as actual characters,
| i am getting the output as
|

In this case you'll have to turn-off the console echo mode. There is no
support for this in the FCL, so you'll have to PInvoke some console API's.
Following is a sample.

using ...
using System.Runtime. InteropServices ;
public class class1
{
[DllImport("Kern el32")]
extern static IntPtr GetStdHandle(in t inp);
[DllImport("Kern el32")]
extern static bool GetConsoleMode( IntPtr handle, ref uint mode);
[DllImport("Kern el32")]
extern static bool SetConsoleMode( IntPtr handle, uint mode);
static uint ENABLE_ECHO_INP UT = 0x0004;
static void Main() {
...

password = GetPasswordFrom Console();
string osqlArgs = String.Format(" ....
...
} // end Main

static string GetPasswordFrom Console() {

IntPtr hCon = GetStdHandle(-10);
uint oldMode = 0;
GetConsoleMode( hCon, ref oldMode);
uint newMode = oldMode & ~ENABLE_ECHO_IN PUT;
SetConsoleMode( hCon, newMode);
// Prompt user to enter password
Console.Write(" Enter password: ");
string pwd = Console.ReadLin e();
Console.WriteLi ne();
SetConsoleMode( hCon, oldMode);
return pwd;
}
| Enter User:sa
| Enter Password:sa
| Process output: 123(1 row affected)
| Process output: (1 row affected)
|
| i want to supress the 1>2>3 and want to display only the number of rows
| affected as
| 1 row affected
|
Well, just parse the returned string, but I'm affraid you will have to do it
yourself. Hint take a look at the String.Index and String.IndexOf and
String.Substrin g methods.

Willy.

Willy.