|
Home > Archive > MS SQL Server ODBC > April 2005 > Wrong SQLSTATE for Native Error 2727
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Wrong SQLSTATE for Native Error 2727
|
|
| Aleksey Dmitriyev 2005-04-09, 8:23 pm |
| 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
| |
| Bei Zhu [MSFT] 2005-04-18, 8:23 pm |
| Could you please provide more info? Like index_junk and table creation.
"Aleksey Dmitriyev" < AlekseyDmitriyev@dis
cussions.microsoft.com> wrote in
message news:981E61BC-DB8B-4DE3-A21A- 6FFEE2824DF2@microso
ft.com...
> 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
| |
| Aleksey Dmitriyev 2005-04-19, 8:23 pm |
| 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@dis
cussions.microsoft.com> wrote in
> message news:981E61BC-DB8B-4DE3-A21A- 6FFEE2824DF2@microso
ft.com...
>
>
>
| |
| Bei Zhu [MSFT] 2005-04-20, 8:23 pm |
| You need to create index index_junk first, then you can alter it.
"Aleksey Dmitriyev" < AlekseyDmitriyev@dis
cussions.microsoft.com> wrote in
message news:37C76DB7-59CC-4C63-BBF6- 67ED7D9C2F81@microso
ft.com...
> 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[color=darkred
]
> in ODBC on the client side and Server should not make a difference.
>
>
> --Aleksey
>
>
>
> "Bei Zhu [MSFT]" wrote:
>
in[color=darkred]
not[color=darkred]
| |
| Aleksey Dmitriyev 2005-04-20, 8:23 pm |
| Yes, I understand that. The error is expected in this case. However, I expect
different SQLSTATE. If you read my original post again, you can see that I
was expecting 42S12.
--Aleksey
"Bei Zhu [MSFT]" wrote:
> You need to create index index_junk first, then you can alter it.
>
> "Aleksey Dmitriyev" < AlekseyDmitriyev@dis
cussions.microsoft.com> wrote in
> message news:37C76DB7-59CC-4C63-BBF6- 67ED7D9C2F81@microso
ft.com...
> click
> I
> occurs
> in
> not
>
>
>
|
|
|
|
|