Yesterday a co-worker cam to me and she was having multiple problems with Crystal Reports 7.0 accessing SQL Server 2000. She was doing the same thing as me and my stuff work so I tarced it down to the fact that she was using the 'Microsoft SQL Server' as her data provider in Crystal. Once I switched it to OLEDBSQL it worked fine. I was wondering what everyone here prefers using for providers (and why!) out of the various choices (OLEDB, ODB, etc.).