5 replies to this topic

[lastenia_rojas]

We want to access a MS SQL table from ProIV. The MS SQL database is the default database. Unless we specify the SQL select statement ourselves, we get an 'Invalid cursor position' error as soon as we move into any of the table columns. The function is a paging screen. Scrolling up/down works fine. Moving into any of the columns is what is causing the grief. I was wondering if other people have experienced the same problem, and if so, any info with regards to the cause of the problem and how to resolve it are greatly appreciated. Thanks.

[Lewis Mccabe]

Never seen that before. Is this a new installation? Do other PRO-IV functions work fine?
What versions of PRO-IV and MSSQL are you on? We need more info to help you.

Lew

[Neil Hunter]

I have seen this before, but for the life of me can't remember too well how to fix it.

Is there an option on the database for implicit cursors or something like that ?

Have you tried using a simple file browser from ProIV side ?

[Joseph Bove]

lastenia_rojas,

Compare your ProIV table defintion with the actual SQL table itself. If the ProIV definition has more columns than the actual table (or a column of greater length than the actual table), you can get an error like this.

hth,

Joseph

[lastenia_rojas]

Thanks for the pointers. We are using ProIV 5.5 312, and SQL Server 2000 with all available service packs. The OS
is Windows 2K. The same application runs ok in Oracle. The file definition seems to match the table definition -- there
are only two (alpha) columns in the table. Although we have experience with ProIV/Oracle the ProIV/MS-SQL combination
is new to us. We are in contact with ProIV support and we'll post the solution as soon as we know what is wrong.

[lastenia_rojas]

... no longer getting this error after upgrading to ProIV 5.5r5.1.8