Re: Wrong SQLSTATE for Native Error 2727

Steps to reproduce:

1) Execute this script using any tool
create table t1(a int)

2) Start ODBCTEST and login in to SQL Server. Run this query (I simply click
on the exclamation point)
alter index index_junk on t1 rebuild

3) Review the output:
Return: SQL_ERROR=-1
stmt:szSqlState = "42S21", *pfNativeError = 2727, *pcbErrorMsg = 73,
*ColumnNumber = -1, *RowNumber = 1
MessageText = "[Microsoft][SQL Native Client][SQL Server]Cannot find index
'index_junk'."

My configuration:
SQL Server 2005 IDW12 (I believe)
SQL Native Client dirver that comes with it.
The same error exist with I use SQL ODBC Driver that comes with MDAC 2.8. I
have not tried SQL Server 2000, but I believe this error code mapping occurs
in ODBC on the client side and Server should not make a difference.


--Aleksey



"Bei Zhu [MSFT]" wrote:

> Could you please provide more info? Like index_junk and table creation.
>
> "Aleksey Dmitriyev" <AlekseyDmitriyev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:981E61BC-DB8B-4DE3-A21A-6FFEE2824DF2@xxxxxxxxxxxxxxxx
> > I get SQLSTATE 42S21 with native code 2727 when executing this query:
> >
> > alter index index_junk on testauto rebuild
> >
> > According to ODBC documentation the SQLSTATE should be 42S12 "Index not
> > found", not 42S21 "Column already exists". Is it a bug?
> >
> > --
> > -- Aleksey Dmitriyev
>
>
>
.

Relevant Pages

  • Re: Wrong SQLSTATE for Native Error 2727
    ... You need to create index index_junk first, then you can alter it. ... > 2) Start ODBCTEST and login in to SQL Server. ... > The same error exist with I use SQL ODBC Driver that comes with MDAC 2.8. ... > have not tried SQL Server 2000, but I believe this error code mapping ...
    (microsoft.public.sqlserver.odbc)
  • RE: Using Access as Data Source for Report Server
    ... With Access trying to connect to SQL Server 2005 you should either use the ... SQL Native Client ODBC driver or make sure to turn on Named Pipes in your ...
    (microsoft.public.access.reports)
  • Re: How Can I Write a SQL Server Function that Returns a Memo Data Type in Access?
    ... Text data type. ... LONGTEXT, LONGCHAR, MEMO, and NOTE aren't recognized by SQL Server. ... For an ODBC driver, I'm ... using the one called "SQL Native Client", ...
    (comp.databases.ms-access)
  • SQLExpress
    ... shing a connection to the server. ... When connecting to SQL Server 2005, ... Sqlcmd: Error: Microsoft SQL Native Client: Login timeout expired. ...
    (microsoft.public.sqlserver.setup)
  • SQL Native Client ODBC changing connection
    ... I am using SQL Native Client in ODBC to connect to our MS SQL Server 2005 ... Named Pipes Provider: Could not open a connection to SQL Server ...
    (microsoft.public.sqlserver.odbc)
Loading