Hi,

I am creating a windows service in C#, it just opens an exe file that was
developed in VB, the exe file having a GUI and connects to DB using system
DSN (using login details sa/master)

I am using code:

Process p;
string FilePath = @"C:\vb_file.exe ";
string arg = " /send";
p = Process.Start(FilePath, arg);

Note : Service Interactiing with Desktop option is selected

Once I started service and checked Event Viewer -> Application log ..it is
showing below error...

Event Type: Error
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 7/13/2007
Time: 9:33:41 AM
User: N/A
Computer: xxxx
Description:
The VB Application identified by the event source logged this Application
vb_file: Thread ID: 2704 ,Logged:
vb_file Rev. 30-Apr-03T /send /RESTART
ODBC condition 18456, State=28000, RetCode=-1
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'sa'.

But If I do.... Start -> Run and

C:\vb_file.exe /send

it is working and displaying GUI....and not throwing any error...

Please help...

Thanks
--
Taduri

It looks like a credentials problem because of that Login failure. If that VB program uses its own credentials to log in toSQL then it will fail because it's most likely running with the same account as the service. I hope you're not expecting the VB program to be running with the same credentials as the logged-in intercative user.

It looks like a credentials problem because of that Login failure. If that VB program uses its own credentials to log in toSQL then it will fail because it's most likely running with the same account as the service. I hope you're not expecting the VB program to be running with the same credentials as the logged-in intercative user.