|
this question is a mixture of sql and c# windows services...
i have a windows service which connects to COM1 port(serial port) and writes the data into a sql db. i have an installer which installs the service and run it immidiatly after setup is completed , but stops very soon because of this error which appears in event log :
provide : named pipes provider . error 40 - could not connect to sql server
i have installed sql server 2005 (not express ed) and the connection string
in my service is :
string _connectionstring =
"server=" + Environment.MachineName +";Initial Catalog=myDatabase;"+
"user id=myLogin;password=myPassword;trusted_connection = true;";
i have tested this connection string in a simple windows form and it works!
please notice that this sql server and windows service are working on local computer , not a network. 
|
|
|
|
|
check that Environment.MachineName is returning the correct value you need, i.e. the SQL Server location. The other information in your connection string should be irrelevant at this time, as with the error you have the issue is usually because is pointing to wrong place
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
I think you may have a conflict in your connection string. You are providing a user name and password but also specifying trusted_connection=true. My assumption is that the service is trying to logon to the SQL server as the user the service is running under. Try changing trusted_connection = true to trusted_connection = false.
|
|
|
|
|
Would that not be an authentication error instead thou?
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Quite possibly but I couldn't count the number of error messages I've seen that don't really relate to what the problem is. 
|
|
|
|
|
very true
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
hi..
Can anyone have idea about "datafile" in ACOS3-24 smart card,
i have to write and data in it using C# SDK.
i analysed that each datafile can contain upto 255 data records,but i m confused that how much "datafile" can we make. and what is max capacity (no of bytes)each "datafile" can contain.
Plz reply anyone who have some idea,
plz provide any help regarding this whatever anyone know about this.
Thanx.
|
|
|
|
|
I'm afraid, unless you are VERY lucky, that the knowledge you want is not available here. You would be better off going to the manufacturers of the device or SDK.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
|
Hi.
Could you please guide me, how we can convert an IntPtr object to an Image object ?
thanks.
|
|
|
|
|
|
Hello,
How to check and patch your old installed program using c#?
Ex: I had installed program but after couple of months i do changes how can i check the version of the old software inruntime and how can i create patches of it?
thanks
|
|
|
|
|
ClickOnce or your install program are the best way to do this. Otherwise, you need a patcher program that runs and overwrites your exe.
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.
|
|
|
|
|
sorry, Sir what is clickonce?
|
|
|
|
|
The best way is publichingg your application with clickonce.
After completing development your application right click on your Windows application and select publish.
After that all you have to do is put published files to a location such as web site, ftp or file share that users may access.
To install users may open publish.htm and click install or double click the .application file at the root.
|
|
|
|
|
what does it mean by clickonce? Is this a software?
|
|
|
|
|
|
Sir,
How about this scenario, i have one main big application under that i have application service, web services and plugins that are all .exe and installed in client server. If i have update on my domain server for one of my .EXE file, does the main app need to be updated also o can i just update the .EXE file.
|
|
|
|
|
My app has a number of projects in it. They all use the same namespace (ClientServerTimesheet).
I need to print some grids, so I have added Printing.DataGridViewPrintProvider to the solution, without changing its namespace.
In the client part I have added a reference to it and I can print. But I have a problem with the height of the first row and so I want to look at the array of row heights.
I have a project Globals, with a class Lookup. Lookup contains a public static array of float rowHeights.
In DataGridViewPrintProvider I have added a reference to Globals.
In DataGridViewPrintProvider I use the line
global::ClientServerTimesheet.Lookup.rowHeights[row.Index] = GridView.Rows[row.Index].RowHeight(g);
but it won't build, saying that Globals does not have a strong name.
I supect that what I actually need is to qualify the above line better, or do I really need to create a strong name for Globals? Not sure how to do that with C# 2008 Express
|
|
|
|
|
What Exception are you getting?
Nothing you've said would seem to indicate a problem.
I've never found a need for global:: and I don't think it's required here. Are you somehow confusing it with your Globals project?
|
|
|
|
|
I just put the global in to see if it helped.
No exception - compile error: Assembly generation failed -- Referenced assembly 'Globals' does not have a strong name : Printing.DataGridViewPrint
But Code Completion worked when entering the line. And other places in my code I can access variables and constants in Lookup (although I don't need the ClientServerTimesheet. as they are in the same namespace.)
I renamed he project that contains Lookup to SolutionGlobals as well as its Assembly Name and the compile error follows the change.!!
If I comment out the line code compiles and runs.
I checked the Build Order and Dependencies. Printer.DataGrisViewPrintProvider is only dependant on SolutionGlobals (Lookup) which is compiled first, and only the client is dependant on it, and client is compiled later in the order.
|
|
|
|
|
Hmmm, well there are situations where an assembly needs a strong name. And as I recall, a strong-named assembly must refer to only strong-named assemblies. So, basically, if any of your assemblies will be strong-named they all must be. I use one strong name file thingy for all the projects in my solutions and that takes care of it.
|
|
|
|
|
After giving all 17 projects a strong name it now compiles!!
|
|
|
|
|
Hi Friend,
I have developed addin for outlook 2003. It installing and working fine with outlook 2003.
and it is installing for outlook 2007 but when i go to enable the addin it is not loading.
any idea ..
|
|
|
|
|
Are you using outlook InterOp services. If so, the API will be different in outlook2003 and outlook2007.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
