Hi,

i try to connect to oracle and also i add the references "Oracle In Proc Server 4.0 Type Library" but still i'm getting error - "The specified module could not be found"

[VBA]
Sub ConnectToOracle()
Dim objSession As Object
Dim objDatabase As Object

' Create a reference to the OO40 dll
Set objSession = CreateObject("OracleInProcServer.XOraSession")

' Create a reference to my database
Set objDatabase = objSession.opendatabase("Oracle", "scott/tiger", 0&)
End Sub
[/VBA]

thanks..