4 replies to this topic

[Neil Hunter]

Running 5.5r411 on Win2003 Server with SQL Server 2005.

We keep getting a 366 error (A cursor with the name 'XXXXXXX' does not exist) when adding to a data file.

I have implicit transactions set and auto close of cursors on commit has been disabled.

Anyone got any bright ideas?

[Mike Schoen]

Neil,

The only suggestion I have is that you chech the functions called for commits, and try commenting them out in a test environment to confirm that the cursors really dont get closed.

We ran into this with sql 2000, and had to restructure a few functions to deal with losing cursors on commit.

We are doing testing on sql 2005 as well, to confirm that we are able to work with it despite its "not supported with release 5.5" status.

If we run into anything like this and can solve it, I will let you know.

Mike

[fatboy996]

I suggest you put SQL_TRANSACTION_ERROR=Y in your pro4.ini (under the environment section) and then re-run your functions, this will then generate an error if you are commiting data in the wrong place which should then help you narrow down the error.

[Neil Hunter]

Neil,

The only suggestion I have is that you chech the functions called for commits, and try commenting them out in a test environment to confirm that the cursors really dont get closed.

We ran into this with sql 2000, and had to restructure a few functions to deal with losing cursors on commit.

We are doing testing on sql 2005 as well, to confirm that we are able to work with it despite its "not supported with release 5.5" status.

If we run into anything like this and can solve it, I will let you know.

Mike

Thanks Mike. Will scratch around a bit. Strange thing is that this set of boots was ported from a set of Oracle boots, where the only change has been the file defs. And it works 100% under Oracle

[Mike Schoen]

Neil,

The only suggestion I have is that you chech the functions called for commits, and try commenting them out in a test environment to confirm that the cursors really dont get closed.

We ran into this with sql 2000, and had to restructure a few functions to deal with losing cursors on commit.

We are doing testing on sql 2005 as well, to confirm that we are able to work with it despite its "not supported with release 5.5" status.

If we run into anything like this and can solve it, I will let you know.

Mike

Thanks Mike. Will scratch around a bit. Strange thing is that this set of boots was ported from a set of Oracle boots, where the only change has been the file defs. And it works 100% under Oracle

We had the exact same surprise when we added mssql support to our application.
That and sub-selects caused a few rewrites