DBFetchRandom() causing 'General Protection'

[mmaddox]

When querying the MS SQL DB with DBFetchRandom(lastRecord) -lastRecord being the last record in the SQL DB- I get 'General Protection' fault at 001B:00407582.

This only happens in release mode-everything works great without warning or error in debug mode.

I am using labwindows/cvi 7.1 (build: 314) and the SQL toolkit.

Please help!

Thanks,

Mark

[Wendy L]

Hello Mark,

If your version of MySQL ships with a .lib and .h file for making direct C calls, you might want to go down that route instead of using the ODBC driver.  Another customer ran across a similar issue, on the following post.  I would suggest taking a look at the directions posted by Philippe.

Hope that helps.

[mmaddox]

I am not using MySQL I am using Microsoft's SQL Server 2000