devxlogo

VB5-to-SQL 7.0 Connection Problem

Why Trust Us

Question:
I need your assistance to solve the following:

I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique to get data and update it. The problem is, whenever I do a RollBack and try to check the cursor, I receive a message?”ODBC Error – cursor is not open”?as if the cursor is closed automatically. I did not have this problem with SQL 6.5.

Answer:
Is there a particular reason you chose to use RDO instead of ADO?

Check the cursor declaration for the type of cursor you’ve created. Maybe you are dealing with a FORWARD only? Did you try to throw an order by on your cursor?

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  How Engineering Leaders Spot Weak Proposals
Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More