CrystalReport.Net help please...

[agcabutotan]

Hi to everyone.

I am new in this thread, please help me.

I'm having difficulty with CrystalReport.Net. I have a completed project written and compiled in VB.Net (and I used CrystalReport.Net in all of my reports). I used to connect in our SQL server using ADO datasets and It worked. Long after I created a new SQL server (not a member from the original server, a new server so-to-speak), with the same project, I am creating a new report but this time around using the new server.

My procedure is as follows:

Provided I have a new blank report template

1. Field Explorer > Database Field > Add/Remove Database
2. Data Expert module appears
3. Select OLE DB (ADO)
4. OLE DB (ADO) module appears
5. Select and Find provider

I searched for he provider Microsoft SQL server ODBC Driver or SQL Provider not in the list.

I check the Data Source (ODBC) in the Administrative tool, it appear when adding new User DSN.

I searched Microsoft and CrystalReport websites to find hotfix and/or .net framework service packs and redistribution packages for Windows Server 2003 x64.

Actions taken:

I have installed and update with the patches I downloaded. Still the same problem.

I have reinstalled and repaired SQL Connectivity and Client tools and applied service pack 3a in my PC. Still the same problem.

I have reinstalled and repaired Visual Studio.Net and its prerequisites. Still the same problem.

Please help me.

A million thanks in advance.