Table append problem in SQL Server but OK in Access

I got a table has Primary key field defined as IDENTITY field in SQL Server,
other fields are NULLABLE, and 2 fields are bit fields which are not
NULLABLE.

The same table structure in Access, primary key field is Autoincrement,
others are NULLABLE.

When I call:
table1.Append;

I gave me an exception about:
myapp.exe raised exception class EConvertError with message ''' is not a
valid integer value'.
Process stopped. Use Step or Run to continue.

This exception happened when I connect to SQL Server.

I did not get any problem when connecting to MS Access.

Any idea?


.

Relevant Pages

  • Re: ASP.NET 2.0 - a newbie question
    ... the exception can be identified using the exception stack trace below. ... established connection failed because connected host has failed to ... connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& ... Microsoft SQL Server? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Authentication problem continued
    ... This is the exception I get if on my test box if I haven't run ... I have a SQL Server login established now and I can log in on my ... SQL Server is configured for Windows Authentication only and not ... I'm still having trouble getting my app to authenticate correctly. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP: IIS 5.1 und Datenbankzugriff mit Web-Control: CreateUserWizard
    ... Damit kam die ursprüngliche Exception nicht mehr. ... Setzen des Properties "User-Instance" auf false der richtige Weg? ... Du verwendest anscheinend keine Datenbank, die fix im SQL Server ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: Logreader access violation
    ... Windows and System Admin rights for SQL Server. ... Microsoft SQL Server Replication: Exception Stack Dump ...
    (microsoft.public.sqlserver.replication)
  • Driver corrupts prepared statements in pool.
    ... This test case demonstrates a bug in the Microsoft SQL Server 2005 JDBC ... cause an exception the next time it is used. ... Microsoft SQL Server 2005 JDBC driver 1.0.809.102 ... // A connection will NOT work properly until it has been ...
    (microsoft.public.sqlserver.jdbcdriver)