Hi,

I am facing problem in Visual studio 2005 with crystal report on Windows 2008 R2 server.

Today I installed all softwares in following order.

1) First install oracle 10g 32bit client & 64bit client on windows 2008 R2 application development server.

2) After oracle Client installation, I installed visual studio 2005 and tested crystal report on server in debug mode. It was working completely. (Both type of report - report created with the help of command in crystal report & crystal report created in direct reference of database table)

Then i published my test project and made setup on same server for clientside testing. but on client machine, it shows error message.

that was : The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception.

One more thing i have observed that was report created with help of command in crystal report was working on client machine. But report in which i have added table directly, was generating above error.

Then i installed crredist2005_x86.msi and crredist2005_x64.msi from visual studio installed folder.

After installation, error message changed on clinet machine.

Error Message : 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 {EE65A074-2C4E-43DE-A3FC-1FE673093BF1}.rpt: Unable to connect: incorrect log on parameters

Still in debug mode on server, asp.net project is working with crystal report. I think, when i run asp.net project in debug mode on server, project may be run on 32bit mode. When i run same project from published setup on client machine, it may be run on 64bit mode.

I can't understand how to solve this problem.

Pls. help me.

Thanks in Advance

Keyur