Thank you. I was able to solve that problem. My socket was time based(timeout) and not databased. I had to make some correction in the code so that it recevies the data till the last byte. Sri

Hi All, I have developed an FTP client. When I try to download some of the files I get the error "dst_dataconn ended unexpectedly" with error code 550. Does any one know why this error pops. Sri

Hi All, I have developed an FTP client. When I try to download some of the files I get the error "dst_dataconn ended unexpectedly" with error code 550. Does any one know why this error pops. Sri

Hi Y don't you change this line of code for (int x = 0; x < anArray3; x++) to for (int x = 0; x < 10; x++) and see. Sri

Thank you. I need to process all these records. Just Imagine for every 50 records from Table1, I need to insert 1 record to Table2. There are calculation to be done on these 50 records first and then I have to insert that into database. For getting 7000 records from DB it takes ~1hr 20mins. So you can just Imagine how many records are there in DB. Instead of processing these on DB using proc, I thought bringing the records on client side and processing them would reduce load on DB. If I regularly update the dataset and data adapter by methods AcceptChanges and Update methods resepectively would the memory usage would reduce ? Can please suggest an good way of solving my problem ? Srinath

Does any one knows how many records can be inserted/fetched to datatable with in dataset ? I am getting few millions of records from oracle database, and when I use DataAdapter.Fill(dataset) method or Dataset.Tables.Rows.Add(datarow) method i get "Exception of type System.OutOfMemoryException was thrown." Does any one has idea on this ? Srinath

Yes.. :) Srinath

Does any one of you have an example to connect to Oracle DB on Unix machine using C# service application ? Any hint or idea would be of great help.... Srinath

Do i have to impersionate the user...while accessing the data base ? Srinath

Do u mean to say you need to collect the time stamp ? before and after query execution ?

Actually all those dlls are picked up from my env path variables. So that seems to be ok....:) But the acutal problem still exists. Srinath

Your are right. If I log into machine as a local user i am not able to access the database. Another strange problem, I right click on my console application and then select "Run As" option. Here I am using loginID and PWD, which I have been using so far and working fine. But the application throws an error OCI.DLL The specified module could not be found. Could not create an environment: OCIEnvCreate returned -1. But the same application if double clicked returns the correct answere from the procedure. Srinath

Code is very much the same. I am executing that in a console application. While carrying out your previous instruction I was given the permission to execute services(Log on services). So I restarted the machine and then carried out your instruction. Now I have strong feeling that some permission has to be given to my USERID and PWD on the local machine. And the serive was installed using "LocalSystem" property. More over I am logging to a domain. Keeping this in mind I asked you about those question. Let me know if you need more info from my side. Srinath

Even this did not help me. Is there any initial setup that has to be done on my system even before accessing the database from service applications ? like user creation, giving persmissions etc..etc...? Srinath

Thanks for the reply. Your hint did not help me. This is a strange behaviour, If I connect to the same database from a desktop application developed in C# with the same connection string, it does executes the procedure. But the same tried from C# service application it hangs for a min and then throw this exception. Let me know if am doing somthing wrong... :(. I am in a pretty bad state with this exception. Srinath

Hi All, I am trying to connect to Oracle database via C# service application. When I try to open the connection i get the exception "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." This happens at very first instance(not after some interval...) I have tried to search this on the net, but all in vain. Most of them have given the answere as to check with the connection. Below is the code snippit I am using to connect to database. string csQuery = "prc_ins_sample"; string strConnection = "User ID=xxxx;Password=xxxx;Data Source=xxxxx;"; OracleConnection OraConn = new OracleConnection(); try { OraConn.ConnectionString = strConnection; HMLog.WriteEntry("OraConn.Open();"); OraConn.Open(); OracleCommand OraCmd = new OracleCommand(csQuery, OraConn); OraCmd.CommandType = CommandType.StoredProcedure; HMLog.WriteEntry("OraConn.Open()"); OracleParameter arg_month = new OracleParameter(); arg_month.OracleType = OracleType.Number; arg_month.Direction = ParameterDirection.Input; arg_month.ParameterName = "arg_month"; arg_month.Value = 10; OraCmd.Parameters.Add(arg_month); arg_month = new OracleParameter(); arg_month.ParameterName = "arg_mybal"; arg_month.Direction = ParameterDirection.Output; arg_month.OracleType = OracleType.Number; OraCmd.Parameters.Add(arg_month); HMLog.WriteEntry("Before execution"); int iRecordCount = OraCmd.ExecuteNonQuery(); if ( iRecordCount > 0 ) { } OraConn.Close(); OraConn.Dispose(); } catch(Exception ex) { HMLog.WriteEntry(ex.Message); if (OraConn.State != ConnectionState.Closed ) OraConn.Close(); OraConn.Dispose(); } Does any one know to get out of this problem. Srinath

Question 1. I am not able to set CLIENT_EDGE for the dialog programmatically. I used modifyEx() to set the style. But this did not work. Can any one tell how to go abt to get this done. Qusestion 2. I have written a DLL, in which a variable of type CString is set to some value. Setting the value for the variable is through an exe. This exe also displays the value of the string. Can i display the value of the variable in the second instance of the exe i,e i have an exe by name Display.exe, i will run this Display.exe and set the value for the string. Again i will run another Dispaly.exe(Now i will have two similar exe on my desktop.) through which i want to display the contents of the string. I should use thread for this. Srinath