ODBiC Discussion Board


[Microsoft][ODBC Visual FoxPro Driver]Too many variables.

by Pramod, March 10, 2008 06:56

Hi,

I am using VFP 6. When I am trying to save huge data in database it throws following exception. If less data, it is working fine.

When I am using break-point, it saves the data successfully. It Looks like some timing issue. Can you please help me?

Here is the Exception:

Exception: System.Data.Odbc.OdbcException: ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Too many variables.

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()

at Com.Po.POManager.AddLineItem(LineItem lineItem, IDbTransaction odbcTrans) in d:\Project\GL\trunk\WebSite4\App_Code\Com\Gl\Po\POManager.cs:line 229


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.