Crystal Report 9 using Oracle OLE DB in Visual Basic

I have this big problem coz everytime i used this code

ConnectionInfo.Item("Provider") = "OraOLEDB.Oracle.1"

i always get an error message

what seems to be the problem with this

this is what the crystaldecision guys gave me in their pdf document but it doesnt work


Connecting to Oracle (OLE DB) at Runtime
'Declare a Connection Info Object
Dim ConnectionInfo As CRAXDRT.ConnectionProperties
'Set the Connection Info to Connection Properties of
‘the table object
Set ConnectionInfo =
Report.Database.Tables(1).ConnectionProperties
'Set the OLE DB Provider
ConnectionInfo.Item(“Provider”) = “SQLOLEDB”
'Set the physical server name
ConnectionInfo.Item(“Data Source”) = “Server name”
'Set the user name
ConnectionInfo.Item(“User ID”) = “User name”
'Set the password
ConnectionInfo.Item(“Password”) = “Password”
'Set the fully qualified table name if different from
‘the original data source
Report.Database.Tables(1).Location =
“schema.tablename”



maybe because i am not using sql but oracle

what possible solution could you give me guys