Hi,

this my code :

************************************************** **********
Public Function LoadTableContent(strTable As String, cnx As ADODB.Connection) As ADODB.Recordset

Dim rs As ADODB.Recordset
Dim strSQL As String

On Error GoTo LoadTableContent_Err

strSQL = "select * from " & strTable

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.LockType = adLockReadOnly

rs.Open strSQL, cnx, , , adCmdText

LoadTableContent_End:
On Error GoTo 0
Set LoadTableContent = rs
Exit Function
LoadTableContent_Err:
Set rs = Nothing
Resume LoadTableContent_End
End Function
************************************************** **********

A have an E_FAIL error with "rs.Open strSQL, cnx, , , adCmdText".
I use ODBC driver 8.1.7.

When i connect on a DB oracle 8.1.7 i don't have the problem but if i connect on a DB oracle 9.2 (which is exactly the same) i have the E_FAIL error.

there are 3 columns in my table string | string | OLE Object

If somebody know the solution ??

thanx in advance