index array out of bound - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

index array out of bound

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-15 : 09:33:53

Dear All,
i'm getting an error "index array out of bound" while saving the record.

sql server 2005 with service pack1 system is working fine.
but at client place it is sql server 2005 with SP2. there we are getting error. any help....

windows 2003 sp1 at both the places. only the difference is
in sql server. how can i handle this

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-15 : 09:36:44

Post the code which is throwing error.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-02-15 : 09:47:06

from the msg text, I'd bet that error is likely thrown by client code, not sql server.

elsasoft.org

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-16 : 02:46:42

it is not related to code i think. in the application, while saving a record, i'm getting the error.

the same record is updating with out any error on the sql server 2005 SP1 running system. problem is there with sp2 (client machine). is there any solution for this? pls help me

Vinod
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-16 : 03:05:01

is there any patch from microsoft to resolve this issue??

Vinod
Even you learn 1%, Learn it with 100% confidence.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-02-16 : 06:31:17

Could you turn on Profiler while saving record , and capture the exact statement which is throwing the error?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-02-16 : 07:42:30

i still say this is being thrown by client code, not sql server. sql server does not support arrays.

elsasoft.org

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-18 : 03:58:31

quote:
Originally posted by sunsanvin

it is not related to code i think. in the application, while saving a record, i'm getting the error.

the same record is updating with out any error on the sql server 2005 SP1 running system. problem is there with sp2 (client machine). is there any solution for this? pls help me

Vinod
Even you learn 1%, Learn it with 100% confidence.

Which application?
Debug it and see which line you are getting error

Madhivanan

Failing to plan is Planning to fail

Dilipv
Starting Member

4 Posts

Posted - 2008-02-20 : 00:48:47

hi there,

just check out your array size that you had deifned. if you had defined size of array as 5 and you are storing the values more than 5 than you will get those errors.
Just check out the following link.
http://kb.calyxsupport.com/kb/article.php?id=288

Hope this will help you
Thank you
Jitesh
Programmer
.Net Consulting

[url=http://www.intelcs.com/].Net Consulting[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources