Connections via Windows service
I created a service in C# that opens a connection to SQL and continually reads from a table...I now need a second independent process to do the same thing to a different table (either same or different database, doesn't matter). The first service runs like a charm, but the second one won't complete the open...I assume because the PC already has a connection open... Is there a way to do this?
John WiesePosted May 17, 2010, 4:33 PM
That said, you should be able to do what you are trying to do. You should be able to get multiple connections into the SQL Server from your service server. How did you create the code for the second service? Is it a copy of the project with changes made? Did you start from scratch? What error message are you getting back?