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:
00393311
Views:
16
>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.

Create an Oracle73 DSN throguht the ODBC Administrator. Then run REGEDIT. Drill down to HKEY_CURRENT_USER\Software\ODBC\ODBC.INI and find the DSN you just created.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform