I downloaded the code for Professional Crystal Reports for Visual Studio .NET (November 2002 printing) from the Wrox web site and loaded it on my computer's hard drive. I was able to access the xtreme.mdb database for the chapter 2 examples (sort of), but I can't use any of the chapter 3 code. Everytime I run my app (or even the VB solution that came with the book), it prompts me with a "Database Login" screen. It gives the table name as "Customer" and lists "Xtreme Sample Database" as the server name. The remaining fields--Database, Login ID, and Password--are blank. If I enter
the full path to the database ("C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports\Samples\Database\xtreme.mdb"), it still doesn't work. I even tried experimenting with login IDs and passwords, all without success.

I checked the errata for this book on the website, but it didn't mention this problem. Can you tell me how to log into the xtreme.mdb database? I can open the database using Access are peruse the tables, etc., without any difficulty. I just can't access it using your code.

Thanks in advance for your help.

I created an ODBC driver for this and called it Xtreme Sample Database 2003.

Actually, that was the name of my Xtreme database server. I changed the name from "Xtreme Sample Database" to "Xtreme Sample Database 2003" on the login screen, and it worked fine. Problem solved! :)

Thanks for your assistance.

I agree with the fix, but why? The Xtreme Sample Database does not have security in effect so why do I have to provide the information?

By the way I figured out the name by going into Control Panel, Admin Tools, Data Sources (ODBC) at the DSN tab you will find, or be able to create, the correct name.

Thanks