-3010 on Open Cursor

[ttate]

I'm new to NetExpress. I'm trying to get msAccess data via ODBC. I can connect and do singleton selects with no problem, but when I try an Open Curosr I'm getting a -3010 SQL code. An ODBC trace shows that the failing statement is SQLExecute, immediately following a successful SQLPrepare for the cursor.

Can anybody shed some light on this?

 

[KidHoss]

There are a couple of things to check.

1) What drivers are you using to process the ACCESS database? If you are using the Microsoft drivers, try changing to the drivers supplied by Merent for use with NetExpress. They (Merent) says there can be problems if you don't use their drivers.

2) I am assuming you are using a Microsoft (WINTEL) platform. Either way, you need to verify that your implementation of ODBC supports the SQL statement you are trying to use. If SQLPrepare is not supported in you ODBC support you will receive an error.

 

[ttate]

As it turns out the problem was a misspelled column name in the cursor declaration. Go figure.