locked
Logon failed. Details: Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. RRS feed

  • Question

  • User-2010095746 posted

    Hello friends,

    I am facing problem in migrating Visual studio 2005 Appliacation to Windows 2008 64bit R2 Server from Windows 2003.

    My Windows 2008 R2 Development Server working on 64bit. IIS is also set on 64bit. My Visual studio 2005 Application set on 64bit. I have installed Oracle 10g 64bit client  on Windows 2008 R2 Development Server. 

    But when I published application & run crystal report which is linked with Microsoft OLEDB provider for Oralce in design time, it raised error. Error description is as below.

    Error Description : Logon failed. Details: Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Error in File C:\Windows\TEMP\tablesource {DDAA03B8-F727-4C3B-9E03-3345859EA8AC}.rpt: Unable to connect: incorrect log on parameters.

    I have installed all software in Windows 2008 R2 Development Server in following order.

    1) First Installed Oracle 64bit client

    2) Visual Studio 2005

    3) CRRedist2005_X64

    I have given full rights to everyone on C:\windows\temp folder.

    I think IIS not able to find 64bit Crystal report driver for oracle 64bit.

    How can I over come from this problem ?

    Pls. help me.

    Thanks in Advance.

    Keyur

    Wednesday, November 9, 2011 12:26 AM

All replies

  • User580678469 posted

    Hello keyumehta,

    i too facing this same issue.

    is there any solution for this??

    Pls share ur points..

    Tuesday, January 3, 2012 5:05 AM
  • User-2010095746 posted

    Hi,

    I have tried many things to resolve this issue. but did not get success. After going through many blogs & website solution related to this issue, I realised that there is no 64bit crystal report driver for oracle 64bit. So I had installed 32bit & 64bit oracle client on my windows 2008 R2 server. Now report designed with help of command in crystal report is working nice. but report designed with direct table source in crystal report is not working. 

    So first you try installing 64bit oracle client on server or machine, then set iis pool setting in advance tab ==> enable 32bit application to false. then create crystal report with command source. It will run. 

    Then  set iis pool setting in advance tab ==> enable 32bit application to true. and then create crystal report with table source, it will run

    try this.

    Keyur Mehta

    Wednesday, February 22, 2012 11:39 PM