Comments by vrushali katkade (Top 107 by date)

RAMN >using database_name ; is this correct command to connect to the database

is there is any way to take backup of selected database

in this statement RMAN>backup database;
datbase is databsename or all database resides in oracle 9i

i have already check this link can you please tell me the step by step procedure to take backup of oracle database

is it possible to set time in hour

not like this i have number user can login to access the site but the same user can not access the site same time.when alrady connectd user access the site from another computer then user first disconnect the already connected session then start the new session . if session get remove or kill then user can not access the any fuctionality of the website

can you please send me the example

i already try this i have mention in my question

plz see my edited question

when i have use the session_end event to decrease the LiveSessionsCount then it will decrease after the session timeout but i want to decrease the count after the client close the browser

i have used the System.Threading.Timer in my service

i not getting your solution can you explain it again. beacause i have used the multithreading in service

can you please send me the sample project that describe the SQL remote connection

User ID is compulsory for SQL server to access in iis & i have not write the connection string in web.config acceess directly from the class file (app_code)

can you please tell where to add the milisecond in my remainder

please tell me the limitation of the datatable for one row

how to used the shrink command in vba code

but i want to access this data later from the mysql table

how to insert the multiple records in access database using one query ?

thanks for the reply ,how to specify the start time to the threading.timer like window schedular? please provide the example

how many record stored within 1 hour & time to stored the 10796246 records in to the table

thanks for the replay ,what about another columns, its only distinct the batch column

i have create msi using web setup project

thanks for the replay , but i have already checked these all pages but i not getting the exact limitation of the database size in free version

can you describe the example & my activeX control in C#.NET

thanks for reply but how to attached certificate with the setup & deplyment project

thanks for reply i already refer this code & used this code in my coding but it will show the same message

i already refer this code & used this code in my coding but it will show the same message

i already try this

but i want to test this code how to incresed the total elapsed milisecond of the code

in your article code MYSQL.data.dll file can not found & when add this file to your code it will not get the reference of this file .can you please tell me the version of the MYSQL dll file because i have 5.0.9 version

please see my edited question

Thanks for reply,

But I create a text file in same setup. its working perfectly.

see my code any suggestion to change the code

see my edited

process.start("C:\>net start MYSQL") it will be display exception as The system cannot find the file specified

i want to set dependency through coding when installing the windows service

i m not getting where i write "sc config <service1> depend= <service2>" on command prompt.

how to create the special privileged account in service

6GB disk space remaining

can you tell me how to assign privileges to the window service

but in my datatable 1000 row are stored

then how to take the data from OPCItemState[] array or Searching the data directly into this array .this array contains 16 array & each array contains 1000 items

but I have increased the number of connection size in MYSQL
& Each thread handle the unique row not repeated so i can't used one thread to write MYSQL database.
means i can reduced the number of rows from the each thread

in thread function execute find out the selected value from the array then write into the datatable then this table write to the MYSQL table
but when i will be checking the only one thread there is no issue to writing the 1000 row into the MYSQL table at 1 second i have tested this 1 thread also at 250 milisecods it works fine
then why 12 threads are not working

the same exception using this MYSQL connector 6.3.6

i will be fill the 'dt' dataset from another table then create new 'ds' dataset then copy the dataset into the ds then pass the the update
,i have also used the DataSet.AcceptChanges but there is no effect

i get the all data in the dataTable ( reading from the another SQL table)then i will be stored into the XML then fired the QUERY it will take the more time than above query

can you please tell me the how to increase the execution speed of above query

i have already set SQLcommand.timeout=120

can you give me example

actually this task done by only MYSQL not me like daily event & i want the syntax of the event

@kim Togo please tell me the answer if you known

my task is to take the data from one table & insert into another table
any example of the windows task scheduler

please help me

above application only check the serial key is valid or not.
but I want to check the serial key in setup & deployment project not in windows application.

please see my updates.

please see my updates.

i no how to start the service i want to disabled the option of the service start & stop after all work finished

i no how to start the service i want to disabled the option of the service start & stop after all work finished

then tell me which thing wrong with this code

OK i will be catch the exception but there is no exception catch

it will not update the #innodb_lock_wait_timeout = 500

but it will be takes lots of time to dequeue i wants to update the at every 250 millisecond upto the 128000 rows

can please tell how to improve the performance of the dataadapter.update() without transaction

i will be use this transaction for improve the performance of the int k = da.Update(newupdateddt); function because when the rows are increased into the datatable then it takes lots of time to update the table using the transaction it will be update the table within millisecond so i want speedup the performance also

the all process will be execute at every 1 seconds

how to set the innodb_lock_wait_timeout in MYSQL

i will be set the Max_connections =200 & command timeout =90
it will be take the process list greater than 101 but after some time it will be show another exception as "lock wait timeout exceeded try restarting transaction"

any suggestion about this when i will be delete the pooling=false then it will be shown another exception as "error connecting: 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." it will be increased the size of the processlist

i will be download the version 6.3.6 but it will be display the same exception
string ConnectionString = "Server=localhost;" +
"UID=root;" +
"DataBase=globasys;" +
"Allow Zero Datetime = false;" +
"Convert Zero Datetime=true;" +
"Pooling=false;";
my connection string given above

version 5.2.2.0

please help me

when i will be check for one connection it will be add the two process connection in process list why this will be happed.

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
solution on tis exception actually when the connection beyond the 101 connection it will be thrown exception too many connection . but when i will be create the new instance of the function of update using the thread then when the updates function finished the work it will be release the connection then why this problem is coming

i will be check the list 101 connections are in the list

in connection string i will be set the pool size & then set the pooling=false ,this exception solved but new exception is coming at
int k = da.Update(newupdateddt);this line "too many connections"

when i will be set pooling in connection string it will be throws exception "Input string was not in a correct format."

please see my updates

please see my updated

please see my comment

1.'System.DateTime' to 'MySql.Data.MySqlClient.MySqlDbType'
2.'MySql.Data.MySqlClient.MySqlParameterCollection.Add(string, MySql.Data.MySqlClient.MySqlDbType, int, string)'
this error are generated into the application in the above line changes

i will be check without this line but i will be get this exception at the fill line not this line

if we want to update the previous data is it replace the data

this event i am not handling these all things handle by MYSQL created automatically when mysql service started

you can see my this question & see comment "trying to parse Exact for converting the format of datetime in C#"

how to used DateTime.TryParse for getting the datetime format like "MM-dd-yyyy HH:mm:ss" i want get "MM/dd/yyyy HH:mm:ss tt"
i dont want the '/'& tt in the datetime format but i want to stored output in to the datetime variable

i will be check using the debugger it will be take the right value in the variable assign the ODBC command parameters value will be assigned right value there is no exception to execute the query

value is correct in the database

UpdateQuery8 = "Update parameter " + Environment.NewLine;
UpdateQuery8 += "set paramvalue=@paramvalue,date_logged1=@date_logged1,Quality=@Quality,date_logged=@date_logged" + Environment.NewLine;
UpdateQuery8 += "where groupID=9 and itemID=@itemID";
cmd8 = new OdbcCommand(UpdateQuery8, con136);
cmd8.Parameters.Add("@paramvalue", obj8.ToString());
cmd8.Parameters.Add("@date_logged1", date8);
cmd8.Parameters.Add("@Quality", OpcGroup.QualityToString(e8.sts[counter8].Quality));
cmd8.Parameters.Add("@date_logged", dt);
cmd8.Parameters.Add("@itemID",e8.sts[counter8].HandleClient);
cmd8.ExecuteNonQuery();
it will be execute but there no updation in database

but this code worked properly in windows application

please see my updates

i will be run the service successfully, but it will not display the process name ,how to start the process

which process i will be attach because there is no name of my service in process list

when i will be connected the network computer OPC server it will be connected when i will be start the datachange handler it will be display the exception Exception from HRESULT: 0x80040202(Advise Cannot Connect or Unable to open the access token of the current thread)
please tell me the solution

thanks for reply

can you please tell me the reason to don't used the InvokeRequired

but data change handler invoke continously like timer if we delete the invoke required it will not excute continously

but how can i check the system date is changed & if i got the last run date then how can i calculate the dates remining to expire license.