Error connecting Oracle with Dao/Rdo 
Author Message
 Error connecting Oracle with Dao/Rdo

Y have create a DSN with Oracle on an AIX server.

if y use a Database object and affect UseJet at the Default Type
property the connection is Ok.

If y use the same DSN et affect UseOdbc at the Default Type property
y have the message  IM006 Echec SqlSetConnectAttr

Y have this message if y use the Microsoft Odbc Driver Ver:2.0.006325

If y use the Oracle Driver Vers : 2.05.0301 the connection is stopped and y
have
any message. If y use the trace, the last line is :

VB5             ffc45ed7:ffc5540b ENTER SQLExecDirect
  HSTMT               0x01c8107c
  UCHAR *             0x026a0970 [     106] "SELECT * FROM SELECT
CODE_CLIENT FROM CLIENT WHERE CODE_CLIENT>='031000000' AND CODE_CLIENT<=
'031XXXXXXX'"
  SDWORD                   106

VB5             ffc45ed7:ffc222b7 ENTER SQLCancel
  HSTMT               0x01c8107c

VB5             ffc45ed7:ffc222b7 EXIT  SQLCancel  with return code 0
(SQL_SUCCESS)
  HSTMT               0x01c8107c

and my application is stopped.

The same application run correctly with the same DSN if y use   -UseJet- in
DefaultType Property

Please Help me

Thanks

G.Latapie.

P.S : Excuse my bad english but y am french and y dont speak (and write!!!)
very well.



Sat, 26 Aug 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. DAO or RDO for connecting to ORACLE????

2. RDO or DAO for Oracle?

3. Does anyone know what (dao,ado,odbc,rdo) can support Oracle blob columns

4. Connect to ORACLE database with VB6 RDO

5. connecting VB5 and Oracle 7.3 via RDO

6. Need help connecting Oracle DB to ActiveX DOC with RDO

7. Connecting to an oracle database with dao and odbc

8. Connecting to Oracle using ODBC and DAO

9. Connecting to Oracle thru Oracle OLE DB Provider(OraOLDDB.Oracle)

10. DAO/RDO Errors?

11. Problem : Error in Using Both DAO and RDO.

12. Error #429 Problems with RDO connect

 

 
Powered by phpBB® Forum Software