-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Ambitious_Riddhi
Message 7 in Discussion
New Message on MumbaiUserGroup
"Access is Denied" Problem with system.diagnostics.start()
Reply
Reply to Sender
Recommend
Message 5 in Discussion
From:
Ambitious_Riddhi
New Message on MumbaiUserGroup
"Access is Denied" Problem with system.diagnostics.start()
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
Ambitious_Riddhi
Hi All, I am new to this group. I am currently
working with VB.NET. My problem is when i am trying to execute bcp utility from
VB.net thru System.Diagnostics.process.start(), It is giving me exception like
: "Access is Denied." Whole description of Exception is as follows.
{System.ComponentModel.Win32Exception}
[System.ComponentModel.Win32Exception]:
{System.ComponentModel.Win32Exception}
HelpLink: Nothing
InnerException: Nothing
Message: "Access is denied"
Source: "System"
StackTrace: " at
System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at Common_Sol.CE.Button3_Click(Object sender, EventArgs e) in
D:\Data_Estimates\Common_Sol\Common_Sol\CE.vb:line 1079"
TargetSite: {System.Reflection.RuntimeMethodInfo}
My code is as follows. Dim myProcess as new
System.Diagnostics.Process cmdString = "Select
ch8401,ch8402,ch7803,ch5601 from tab1,tab2,tab_master where tab_master.code =
tab1.code and tab_master.code = tab2.Code into #temptable"
myProcess.StartInfo.FileName = "D:\bcp.bat"
myProcess.StartInfo.Arguments = " " & cmdString & "
D:\Data_Estimates\CE\CE_NATION1984-2003.txt" myProcess.Start()
Actually cmdString contains too much long queries. I am extracting data from
sql server into textfile using bcp utility. I need to extract data from more
than 10 tables and it contains around 900 columns. All columns must be extrcted
at same time and only in one text file. Code is bcp.bat file is like :
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp" %1 out %2 -c -t ","
-r "\n" -P Also without batch file it is giving err : "The
specified is not found." The same command works succesfully from
command line. So what is the problem with VB.NET? Plz reply me soon.
Thanks for all replies in Advance. Riddhi
View other groups in this category.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
