SqlOpen works in our old code using SQLBase 9.x and seems to work in a test app with SQLBase 11.5.
However, migrating the code to use Microsoft SQL Server (via a System DSN and SQL Server Native Client) results in the following SQL error:
This error does not occur on the call to SqlOpen. It occurs on the SqlExecute of the prepared UPDATE statement containing the WHERE CURRENT OF clause.(20034) Microsoft SQL Server:16916[Microsoft][SQL Server Native Client 10.0][SQL Server]A cursor with the name 'SQLOPENTEST' does not exist.
I have tried to follow the Team Developer 5.2 Documentation sections below with no luck.
- Connecting SQLWindows Objects to Databases : Connecting to Microsoft SQL Server : Positioned updates https://support.guptatechnologies.com/Do ... .html#3847
- Connecting SQLWindows Objects to Databases : Overview : Positioned updates https://support.guptatechnologies.com/Do ... .html#3928
Currently using Team Developer v5.2-SP3 Build 24308 and Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 Express Edition with Advanced Services on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)