Hi,
I have created a DSN for connecting to oracle database.
When I use 'ODBC Testing Tool" of oracle and one provided with domino6.5, I am able to connect to oracle database.
I have written following script
Sub Initialize
Dim session As New notessession
Dim notesdb As notesdatabase
Dim db, db1 As NotesDatabase
Dim view,v1 As notesview
Dim currdoc,doc,otherdoc As notesdocument
Dim coll As notesdocumentcollection
Dim x, y, z, m As Currency
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Set qry.Connection = con
Set result.Query = qry
Set db = session.CurrentDatabase
If Not con.ConnectTo(“APPS”) Then
Print “Could not connect to ATDB”
Exit Sub
Else
Print “connected”
Exit Sub
End If
When I run this from notes client then it is executed correctly (I change print to msgbox) but when i am trying to run it from web (using browser) it gives following error message:
“The oracle™ client and networking coponents were not found. These components are supplied by oracle corporation and are part of oracle version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed”
Pl. help me , what could be wrong in it.
Thanks in advance.
Bhavesh