Please help me with this....i m trying to connect Oracle 9i DB with Crystal reports XI. I am using ODBC connectoin. Infact it connects the oracle but dosent brings the table from my user.

I also tried to connect it with OLE DB. With OLE DB it connects the Oracle and brings all the tables and works fine, But i call that specific report from VB6 it gives the error..LOGON Failed...Details:{database Vendor Code:1005}. The code i wrote is given below

CrystalReport1.database.logonserver "crdb_oracle.dll", "Oracle Service", "database name", User Name", "Password".

Please coreect me with codes or tell me if there is any other possible way to do connect the crytal report with oracle and caaling that report from VB6.