Click here to Skip to main content
15,896,118 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: User Control Pin
248912816-May-08 0:57
248912816-May-08 0:57 
Questionconvert names to punjabi language in vb.net Pin
aishasin15-May-08 21:37
aishasin15-May-08 21:37 
AnswerRe: convert names to punjabi language in vb.net Pin
Mogaambo15-May-08 22:57
Mogaambo15-May-08 22:57 
QuestionRe: convert names to punjabi language in vb.net Pin
Vasudevan Deepak Kumar16-May-08 0:31
Vasudevan Deepak Kumar16-May-08 0:31 
QuestionHow to publish webservice in VS 2003 Pin
Zeeshan Ahmed Memon15-May-08 20:51
Zeeshan Ahmed Memon15-May-08 20:51 
QuestionHow create .css file or .txt file dynamically Pin
Guvera15-May-08 19:41
Guvera15-May-08 19:41 
AnswerRe: How create .css file or .txt file dynamically Pin
Christian Graus15-May-08 20:48
protectorChristian Graus15-May-08 20:48 
QuestionERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor Pin
wongeva15-May-08 19:27
wongeva15-May-08 19:27 
Hi dear,

i face a problem here,

use asp.net with c#....


conConnectionOTHER= new OdbcConnection(
"PWD=; SourceType=DBC;DSN=payroll;Collate=Machine;Deleted=Yes;BackgroundFetch=Yes;Exclusive=Yes;
SourceDB=C:\\payroll\\data\\myapp.dbc;Null=Yes;UID=");

=======================================================================================
//Success
conConnectionOTHER.Open();
OdbcCommand cmdGetHistory;
OdbcDataReader dtrGetHistory;
string strGetHistory="select * from sol where employeeid='000007'";
cmdGetHistory=new OdbcCommand(strGetHistory,conConnectionOTHER);
dtrGetHistory=cmdGetHistory.ExecuteReader();
DataGrid2.DataSource=dtrGetHistory;
DataGrid2.DataBind();
conConnectionOTHER.Close();
//end

Result is success, it can bind and show in data grid
======================================================================================

//Fail Here
conConnectionOTHER.Open();
OdbcCommand cmdUpdate;
string strUpdate="Update sol set type='LEA' where employeeid='000007'";
cmdUpdate=new OdbcCommand(strUpdate,conConnectionOTHER);
cmdUpdate.ExecuteNonQuery();
conConnectionOTHER.Close();

//end

Result is fail, cannot update record

Server Error in '/linkToPayroll' Application.
--------------------------------------------------------------------------------

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.

Source Error:


Line 37: string strUpdate="Update sol set type='LEA' where employeeid='000007'";
Line 38: cmdUpdate=new OdbcCommand(strUpdate,conConnectionOTHER);
Line 39: cmdUpdate.ExecuteNonQuery();
Line 40: conConnectionOTHER.Close();
Line 41:


Source File: c:\inetpub\wwwroot\linktopayroll\webform1.aspx.cs Line: 39

========================================================================================




Please need your guideline.......help
Thank you very much


from : eva
AnswerRe: ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor Pin
eyeseetee15-May-08 21:20
eyeseetee15-May-08 21:20 
Questionpointing to the wrong DB Pin
zaimah15-May-08 16:06
zaimah15-May-08 16:06 
AnswerNote to CP members Pin
leckey15-May-08 16:53
leckey15-May-08 16:53 
GeneralRe: Note to CP members Pin
Christian Graus15-May-08 16:55
protectorChristian Graus15-May-08 16:55 
QuestionRe: Note to CP members Pin
zaimah15-May-08 17:04
zaimah15-May-08 17:04 
Questionthis is my web.config Pin
zaimah15-May-08 17:08
zaimah15-May-08 17:08 
AnswerRe: this is my web.config Pin
Christian Graus15-May-08 17:21
protectorChristian Graus15-May-08 17:21 
QuestionRe: this is my web.config Pin
zaimah15-May-08 17:25
zaimah15-May-08 17:25 
AnswerRe: this is my web.config Pin
Christian Graus15-May-08 17:35
protectorChristian Graus15-May-08 17:35 
QuestionRe: this is my web.config Pin
zaimah15-May-08 17:59
zaimah15-May-08 17:59 
AnswerRe: this is my web.config Pin
Christian Graus15-May-08 18:12
protectorChristian Graus15-May-08 18:12 
QuestionRe: this is my web.config Pin
zaimah15-May-08 20:36
zaimah15-May-08 20:36 
AnswerRe: this is my web.config [modified] Pin
eyeseetee15-May-08 21:19
eyeseetee15-May-08 21:19 
GeneralRe: this is my web.config Pin
zaimah15-May-08 21:26
zaimah15-May-08 21:26 
GeneralRe: this is my web.config Pin
Blue_Boy15-May-08 21:41
Blue_Boy15-May-08 21:41 
GeneralRe: this is my web.config Pin
Christian Graus15-May-08 23:02
protectorChristian Graus15-May-08 23:02 
GeneralRe: this is my web.config Pin
eyeseetee15-May-08 23:46
eyeseetee15-May-08 23:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.