Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't Set Oracle Connection Attribs
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00393295
Message ID:
00393321
Vues:
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.


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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform