Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLSetConnectAttr Failed
Message
From
22/11/2000 02:40:59
 
 
To
22/11/2000 00:02:01
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00444483
Message ID:
00444498
Views:
11
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform