Click here to Skip to main content
15,921,463 members
Home / Discussions / C#
   

C#

 
GeneralImage Pin
Gary Kirkham31-Oct-03 10:28
Gary Kirkham31-Oct-03 10:28 
GeneralRe: Image Pin
Blake Coverett31-Oct-03 11:38
Blake Coverett31-Oct-03 11:38 
GeneralConverting ASCII text to a string Pin
benglish7231-Oct-03 9:18
benglish7231-Oct-03 9:18 
GeneralRe: Converting ASCII text to a string Pin
J. Dunlap31-Oct-03 9:45
J. Dunlap31-Oct-03 9:45 
GeneralRe: Converting ASCII text to a string Pin
benglish7231-Oct-03 9:56
benglish7231-Oct-03 9:56 
GeneralSocket programming Pin
Søren Christensen31-Oct-03 8:46
Søren Christensen31-Oct-03 8:46 
GeneralRe: Socket programming Pin
Søren Christensen3-Nov-03 4:26
Søren Christensen3-Nov-03 4:26 
GeneralGDI+ Pin
rob6446431-Oct-03 5:47
rob6446431-Oct-03 5:47 
GeneralRe: GDI+ Pin
J. Dunlap31-Oct-03 9:30
J. Dunlap31-Oct-03 9:30 
Generalsetup and deployment with MDB files Pin
Anonymous31-Oct-03 5:14
Anonymous31-Oct-03 5:14 
GeneralRe: setup and deployment with MDB files Pin
Heath Stewart31-Oct-03 5:28
protectorHeath Stewart31-Oct-03 5:28 
GeneralRe: setup and deployment with MDB files Pin
31-Oct-03 6:31
suss31-Oct-03 6:31 
GeneralRe: setup and deployment with MDB files Pin
Member 44190931-Oct-03 6:52
Member 44190931-Oct-03 6:52 
Generalwindows service and SQL related problem Pin
rishikt31-Oct-03 3:50
rishikt31-Oct-03 3:50 
GeneralRe: windows service and SQL related problem Pin
Heath Stewart31-Oct-03 4:42
protectorHeath Stewart31-Oct-03 4:42 
GeneralRe: windows service and SQL related problem Pin
Terry Denham31-Oct-03 5:25
Terry Denham31-Oct-03 5:25 
GeneralRe: windows service and SQL related problem Pin
Blake Coverett31-Oct-03 7:36
Blake Coverett31-Oct-03 7:36 
Did you actually read his question?

Heath Stewart wrote:
1. If you're connecting only to SQL Server and not any other DB systems, use the System.Data.SqlClient instead of OLE DB. These are classes written specifically for SQL Server with a lot of optimizations and additional features over OLE DB.

His data access is being done from a COM dll, not a .NET component. You are answering the wrong question.

Heath Stewart wrote:
Typically, most Windows Services use the LocalSystem account. If your connection string is using SSPI and the LocalSystem (SYSTEM) account is NOT added to SQL Server as a viable user that can access the system, you'll get Access Denied.

He is very clear about the fact that he is _not_ running the service under LocalSystem.

Heath Stewart wrote:
Typically, most Windows Services use the LocalSystem account. If your connection string is using SSPI and the LocalSystem (SYSTEM) account is NOT added to SQL Server as a viable user that can access the system, you'll get Access Denied.

He's also very clear that the database is on a remote machine, in which case granting LocalSystem access won't help at all because they are two unrelated LocalSystem accounts.

Heath Stewart wrote:
You should either use a fixed User ID and Password in the connection string, as well as Trusted Connection

*sigh* I'm not even going to go there.

Fortunately Terry's answer already homes in on what is likely the real problem.

-Blake
Generalmulti thread question Pin
rod termaat31-Oct-03 3:38
rod termaat31-Oct-03 3:38 
GeneralRe: multi thread question Pin
Heath Stewart31-Oct-03 4:35
protectorHeath Stewart31-Oct-03 4:35 
GeneralRe: multi thread question Pin
Blake Coverett31-Oct-03 8:04
Blake Coverett31-Oct-03 8:04 
GeneralCOM Interop - objects cause NullReferenceExceptions at random Pin
Corinna John31-Oct-03 2:39
Corinna John31-Oct-03 2:39 
GeneralRe: COM Interop - objects cause NullReferenceExceptions at random Pin
Heath Stewart31-Oct-03 5:22
protectorHeath Stewart31-Oct-03 5:22 
Generalnoob winform question Pin
R. Thomas31-Oct-03 1:37
R. Thomas31-Oct-03 1:37 
GeneralRe: noob winform question Pin
Daniel Turini31-Oct-03 2:20
Daniel Turini31-Oct-03 2:20 
GeneralRe: noob winform question Pin
R. Thomas31-Oct-03 4:08
R. Thomas31-Oct-03 4:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.