Windows Service using C# to Transfer data between SQL Server and Oracle
hi
have developed windows service connects sql server 2000, reads data , writes 2 oracle 9i tables. have tested functionality placing code in asp.net 2.0 button click event. works good.
have moved code function , placed in windows service application , called method in service_start(). elapsed_time() methods , set correctly. service process installer --> account set 'user', allowing user enter user name , password during service start up. build successful.
but when run service services console, getting message "the service on local computer stared , stopped. service stop automatically if have no work do, example, performance logs , alert service". applicatin event log 'service cannot started. system.invalidoperationexception: executereader requires open , available connection. connection's current state closed.
@ system.data.sqlclient.sqlconnection.getopenconnection(string method)'.
please note connecting remote sql server(in company domain) from pc using connection string below reading app.config
2) what files need to send client site , allowing client use app.config alter database connectionstrings , interval time.
3) can send myservice.exe , app.config? changing database connections , interval time in app.config going reflect in myservice.exe?
your , insight appreciated.
apriori algorithm [association rule]
have developed windows service connects sql server 2000, reads data , writes 2 oracle 9i tables. have tested functionality placing code in asp.net 2.0 button click event. works good.
have moved code function , placed in windows service application , called method in service_start(). elapsed_time() methods , set correctly. service process installer --> account set 'user', allowing user enter user name , password during service start up. build successful.
but when run service services console, getting message "the service on local computer stared , stopped. service stop automatically if have no work do, example, performance logs , alert service". applicatin event log 'service cannot started. system.invalidoperationexception: executereader requires open , available connection. connection's current state closed.
@ system.data.sqlclient.sqlconnection.getopenconnection(string method)'.
please note connecting remote sql server(in company domain) from pc using connection string below reading app.config
<
add key="sqlconnstr" value="data source=mysource;initial catalog=mycatlog;integrated security=true" />1) know fix above bug2) what files need to send client site , allowing client use app.config alter database connectionstrings , interval time.
3) can send myservice.exe , app.config? changing database connections , interval time in app.config going reflect in myservice.exe?
your , insight appreciated.
apriori algorithm [association rule]
has been resolved. due windows network user name , password. windows service couldnt allow me connect sql server.
thats help.
apriori algorithm [association rule]
thats help.
apriori algorithm [association rule]
Archived Forums A-B > ASMX Web Services and XML Serialization
Comments
Post a Comment