Does anyone know how to get the actual error message from an ODBC driver?
What I mean is when executing a SQLEXEC command from Fox, you either get a 1 or a -1. That's fine and dandy, but if it's a -1 I would like to know WHY my SQLEXEC failed. BTW, I don't want to use the Tracing feature from the ODBC administrator because that could create some really big logs. All I want to do is grab the error and pop it up on the screen so the user knows there was an error and can call support( i.e. ME ) and read off the exact error being returned by the ODBC driver.
Thank you