Invalid operation for the current cursor position

Our developers are getting the following error posted from several Java
applications.
[Microsoft][SQLServer 2000 Driver for JDBC] Invalid operation for the
current cursor position
Is anyone familiar with this error?
Khris wrote:

> Our developers are getting the following error posted from several Java
> applications.
> [Microsoft][SQLServer 2000 Driver for JDBC] Invalid operation for the
> current cursor position
> Is anyone familiar with this error?
It can occur when you try to access result set data without ever
having called next(). If you can show us the whole original stack trace
of the exception and the code that caused it, we can probably see the problem.
Joe Weinstein at BEA Systems
|||Joe - you are correct. The developer was not validating that there was an
actual row. Thanks a bunch
"Joe Weinstein" wrote:

>
> Khris wrote:
>
> It can occur when you try to access result set data without ever
> having called next(). If you can show us the whole original stack trace
> of the exception and the code that caused it, we can probably see the problem.
> Joe Weinstein at BEA Systems
>

Invalid object name one_two_threefour_five_six11.

Hi,

I am trying to connect sql server 2005 with JDBC driver from a java program.(got from microsoft).It is simple class that retreving all the data of table.

i am doing "select * from one_two_threefour_five_six11 " . But it is giving
Exception of type 'com.microsoft.sqlserver.jdbc.SQLServerException Detail Message: Invalid object name 'one_two_threefour_five_six11'.

But the table is there in the database i given in configuration.This program is working for other tables. when i do the same query in Query analyzer it is showing data.

Please help me..

Thanks in advance.

venkateither something is wrong with your connection string or there is a ownership or permissions issue.|||Personally, I think sql server is making fun of you with a table_name like that

Check the owner|||Try this query instead:

select db_name()sql

Invalid Descriptor Index on SQL 2005 sp 1

We have an app that use ODBC and works on SQL server 2000 but
when running the same app and same ODBC driver on 2005 sp 1 we get
Invalid Descriptor Index
Why?
Regards,
DavidMaybe if you show us the actual code that is causing the issue we could make
a more informed answer.
Andrew J. Kelly SQL MVP
"David@.StreamServe" <david.svennevid@.gmail.com> wrote in message
news:1147860037.905325.193680@.j55g2000cwa.googlegroups.com...
> We have an app that use ODBC and works on SQL server 2000 but
> when running the same app and same ODBC driver on 2005 sp 1 we get
> Invalid Descriptor Index
>
> Why?
> Regards,
> David
>

Intersolv ODBC Driver

Help me!
I try to import some data from an informix 5.0 table to Sql Server 2000 with
a DTS package.
I use Intersolv ODBC driver version 03.011.0021 to connect to the database.
It works well, but i can't define a parameter in the sql statement. For
example if a try to execute :
select *
from table
where field = ?
The dts environment give me an "unspecified syntax error...."
Where is the problem?
The driver don't support parameters or these must be defined with another
syntax?
Bye
DanieleCan you post a code snippet?
SQL Server T-SQL doesn't support anything close to that syntax so I'm not
sure what you're doing exactly...
From T-SQL, you would need to build dynamic SQL or use sp_exectutesql to do
the parameterization you're talking about.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nonno Oreste" <dffdfd@.dfd.dfd> wrote in message
news:OSsw2unuDHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Help me!
> I try to import some data from an informix 5.0 table to Sql Server 2000

---

with

quote:

---

> a DTS package.
> I use Intersolv ODBC driver version 03.011.0021 to connect to the

---

database.

quote:

---

> It works well, but i can't define a parameter in the sql statement. For
> example if a try to execute :
> select *
> from table
> where field = ?
> The dts environment give me an "unspecified syntax error...."
> Where is the problem?
> The driver don't support parameters or these must be defined with another
> syntax?
> Bye
> Daniele
>

---