Re: SQLState Error Codes

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 06/25/04


Date: Fri, 25 Jun 2004 17:46:58 +0400

In your DBMS documentation - just search for 42000. For example, for MS SQL
Server it is: "Syntax error, permission violation, or other nonspecific
error".

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Bill N" <billnielsen@hotmail.com> сообщил/сообщила в новостях следующее:
news:40dc21e1@newsgroups.borland.com...
> Anyone have a link or information regarding what SQLState is and what are
> its codes (eg. ADOConnection1.Item[0].SQLState=42000)?
>
> Thanks,
> Bill N
>
>



Relevant Pages

  • Re: JET Database errors
    ... I checked the sql of the page and it appears to be correct. ... to edit any records in any databases on my server give the same error). ... a copy of JET Database update 4.0, but I'm not going to install it until I ... > The first thing I would check for is a syntax error in the UPDATE ...
    (microsoft.public.frontpage.programming)
  • Re: SQL 2005 - Backup Maintainance Plan Failed
    ... I see that the last part of this says "syntax error". ... If step 1 is a TSQL step such as Check Database Integrity or Backup ... We have a new instance of SQL Server 2005 and have created a backup ...
    (microsoft.public.sqlserver.setup)
  • Re: Inserting new records into a large ADO table
    ... Regards, ... Vassiliev V. V. ... >> executes one SQL statement for each change in the CDS.Delta property. ... >> If you insert 1,000 rows the DSP will create and send to the server ...
    (borland.public.delphi.database.ado)
  • Re: Host Variable
    ... However, a variable in SQL ... Server is done via a DECLARE: ... get a syntax error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Heterogeneous joins ?
    ... linked server in MS SQL ... Look sp_addlinkedserver in BOL for more info. ... Vassiliev V. V. ...
    (borland.public.delphi.database.ado)