>This is with MDAC2.5 and Oracle 7.3.
>
>In my code, I get -1 returned from both of these:
>
>
> nSet = SQLSetProp (nConnHandle, 'QueryTimeOut', 10)
> ? str(nSet)+' querytimeout'
> nSet = SQLSetProp (nConnHandle, 'ConnectTimeOut', 15)
> ? str(nSet)+' connecttimeout'
>
>
>Then I realized I am not even sure what all the options are for ORacle 7.3, let alone if I am even setting them right. :) Is there a way to make Oracle regurgitate it's SQL property types/options, or at least a doc out there enumerating "everything"?
>
>Thanks.
After re-reading this, your question does not match what you are doing with code. You need to see the VFP help for the parameters that can be set with SQLSetProp.
Your question, if I read correctly, has to do with the ODBC DSN settings which are not configured with SQLSetProp. These settings are configured with an API call, SQLConfigDataSource.
I have uploaded a file here called ODBC.EXE. Click the What's New button or do a search in the Files section for ODBC. It is in the Win32API category. I am also uploading a newer [better] version of this file later today.
Mark McCasland
Midlothian, TX USA