Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't Set Oracle Connection Attribs
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00393295
Message ID:
00393419
Views:
18
>>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.


Thanks. I am doing everything 'dsnless', so knowing how to go low-level is the best way for me, currently. :)
Previous
Reply
Map
View

Click here to load this message in the networking platform