Q: Access7.0, RDO 1.0b ->SQLSetConnectOption failed

Q: Access7.0, RDO 1.0b ->SQLSetConnectOption failed

Post by Franz Scha » Thu, 01 Aug 1996 04:00:00



Hi!

My Connection Code:

Public EN As rdoEnvironment
Public CN As rdoConnection

Set EN = rdoEngine.rdoEnvironments(0)
EN.CursorDriver = rdUseOdbc
strConnect = ""
Set CN = EN.OpenConnection("", rdDriverPrompt, False, strConnect)

(Tested with all 3 kind of CursorDrivers)
The ON ERROR code is not executed, but in the rdoErrors I have 4 Errors:
2Times ->
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectOption failed
S1C00: [Microsoft][ODBC Driver pack 2.0 Driver]Treiber nicht in der Lage,
                                      diese Operation auszufuehren.
(S1C00 means something like: driver does not support that operation)

Also the Update after Edit does not work. I use SQL to edit and instead of
AddNew.
Does anyone know more about that?
Thanks for taking time to answer,

Franz


here. Thanks

--- OffRoad 1.9n registered to Franz Scharf

 
 
 

1. Problem using VB 4.0, RDO 1.0b, Visigenic 32bit ODBC and ORacle 7.2

We are building an application in VB 4.0 and Oracle 7.2. We are using
Visigenic 32bit ODBC (thru RDO 1.0b) to retrieve data from Oracle.
After a given number of retrieves we get this error:

NA000:[Visigenic][ODBC Oracle Driver][Oracle]Error while trying to retrieve
text for error ORA-00000

Do anyone have a solution for this ?

Odd Martin Solem
Avenir AS

2. migration from MSSQL to MySQL

3. RDO 1 -> RDO 2 Problem

4. Tool for MSDE

5. SQL6.5 --> Access7.0

6. Q&E MultiLink VB and Paradox 5.0 for Windows

7. Complex Query Fails w/ ASP->ADO->ODBC->Oracle

8. foxpro=>visual foxpro

9. xp_sendmail: failed with mail error 0x80004005 HELP>>>PLEASE

10. rdo-->ODBC-->SQL6.0 (Errors on Addnew, Update)

11. 8.0b to 8.1a install fails on NT 4.0