C# Discussion Boards - CodeProject

Tamer Oz27-Jul-09 21:34

Tamer Oz

27-Jul-09 21:34

I think first you have to make an impersonation to a user that have rights on remote server.

Yo can find it here how to make.
Windows Impersonation using C#[^]

Kushi Bobby27-Jul-09 21:44

Kushi Bobby

27-Jul-09 21:44

HI thanks for the reply,

Firstly i need to access the remote system based on IP address and then need to traverse the drives.

As u suggested,i used getfiles() and able to access,but the problem is, as the system is password protected, am unable to connect programatically.

so is there any way to pass the User id and password and access the remote system Harddisk drives

thanks in advance

Have a Nice Day Dudes

Tamer Oz28-Jul-09 1:01

Tamer Oz

28-Jul-09 1:01

For getting drive informations of a remote computer with wmi Windows Management Instrumentation (WMI) Implementation[^] will help.

For password protection of files issue only solution that comes to my mind is impersonation(Working the application under credentials of an user that has access to that files.

Kushi Bobby28-Jul-09 15:25

Kushi Bobby

28-Jul-09 15:25

HI Tamer,

Thanks for the reply.

But my intention is i just want to access remote system from my Window application.as its password protected,is there any way to send User name and password and then access system

Have a Nice Day Dudes

Error..

mjawadkhatri27-Jul-09 20:15

27-Jul-09 20:15

please read this and tell me my mistake.

cn.Open();
cmd.CommandText = "Select ATT_DATE,DEP_ID,to_char(timein,'HH:MI'),to_char(timeout,'HH:MI'),EMP_NAME from attandance where emp_id = '" + id.Text + "' and shift = '" + shift.SelectedItem + "'";

odr = cmd.ExecuteReader();
while (odr.Read())
{
ename.Text = odr["emp_name"].ToString();
dept.Text = odr["dep_id"].ToString();
timein.Text = odr["timein"].ToString();
timeout.Text = odr["timeout"].ToString();
Dte.Text = odr["att_date"].ToString();

}

Christian Graus27-Jul-09 20:26

Christian Graus

27-Jul-09 20:26

That depends. what is going wrong ? Is there an error message ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

mjawadkhatri27-Jul-09 20:32

27-Jul-09 20:32

Error Message is
INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED

Mbah Dhaim27-Jul-09 20:52

Mbah Dhaim

27-Jul-09 20:52

that because you dont specify return field name for time in
try change your query in "to_char('timein',...) as timein"

hope it helps

dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support

mjawadkhatri27-Jul-09 21:00

27-Jul-09 21:00

I change my query like;

"to_char('timein','HH:MI')as timein"

now Error Message Change

ERROR [22018] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number

Mbah Dhaim27-Jul-09 21:09

Mbah Dhaim

27-Jul-09 21:09

then try to follow this link
ORA-01722: invalid number[^]

hope it helps

riced27-Jul-09 20:30

riced

27-Jul-09 20:30

mjawadkhatri wrote:
tell me my mistake.

Not telling us what the error message says and which line it occurs on? Smile | :)

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

mjawadkhatri27-Jul-09 20:36

27-Jul-09 20:36

Error Message is
INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED

line of Error is
timein.Text = odr["timein"].ToString();

Christian Graus27-Jul-09 21:01

Christian Graus

27-Jul-09 21:01

So, there is no column called 'timein'. I suspect you need to read a few basic books before doing any more work, the error message is pretty self documenting, and googling it would have got you a ton of info

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Blikkies27-Jul-09 23:09

Blikkies

27-Jul-09 23:09

In your select statement set "to_char(timein,'HH:MI')" to "to_char(timein,'HH:MI') AS 'timein'"
same with "to_char(timeout,'HH:MI')"

0x3c027-Jul-09 23:12

0x3c0

27-Jul-09 23:12

In addition to your missing columns, your code is vulnerable to SQL injection. You might want to look into stored procedures

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

PIEBALDconsult28-Jul-09 8:15

PIEBALDconsult

28-Jul-09 8:15

"You might want to look into ~~stored procedures~~ parameterized statements."

(Regardless of whether or not the statement executes a stored procedure.)