Hi, Paul.
Depends what you are doing
"Microsoft's ODBC driver for Oracle" for use with VFP.
-It works without errors except one BLOBs and CLOBs don't work
The Oracle ODBC driver
-Gives some errors on bind variables and decimal precision.
The error you are taling about means some connection attribute is set that it can't handle.
Look up the command SQLSETPROP. You have something set to default that won't work.
It is possible to ignore the error something like.
SQLSETPROP(,0"warnings",.f.)
I don't know what MS ODBC driver is but I doubt it will work out for you.
Try either the "Microsoft's ODBC driver for Oracle" or "Oracle ODBC Driver".
>
>I have been using a MS ODBC driver to connect to Oracle 8. But I'm getting this message: Connectivity Error:[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed.
>
>I'm getting the error when I try to verify the connection and when I try to create a new remote view.
>
>I switched to Oracle's ODBC driver and I can make the connection. Any ideas??
>
>I've seen many people here recommend Microsoft's ODBC driver over Oracle's. Is this still true?
>
>Thanks,
>
>Paul
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement