Pervasive

Server: Windows 2008 R2

Pervasive Server 10.30

Client: Windows 2008 R2 Terminal Server

Visual Studio 2005

Crystal Report 10

Network user is a domain admin

I have a Crystal report that uses ODBC to connect to Pervasive. When the report is opend from a VB.Net 2005 program, it prompt for a "Database Login". The prompt has four text boxes, (1) "Server Name" box is populated with Pervasive Client DSN and grayed out; (2) "Database" box is blank and greyed out; (3) Login ID box; (4) Password box, and "Use Integrated Security" check box. No matter what I enter for Login ID and password, login always fails and Crystal report viewer will quit.

If I open the report in Crystal Report designer, it will prompt for login. If I just click OK without providing any Login ID and passowrd, it can connect to Pervasive and get data OK.

This problem did not exist when our Pervasive server is on Windows 2003.

Has anyone seen this problem before? Thanks

When you changed from Windows 2003 to Windows 2008, did anything else change? 

What exactly is the error message when the login fails?  

Thanks, Mirtheil.

Before we upgraded the Sage ERP, the Pervasive server was running on Windows 2003 and Pervasive client was on another Windows 2003 server in Terminal SServer role. Both server were running slow. So our client just bought two new servers with Windows 2008 R2. As far as I know, there is no change to the network other than added two new servers and installed new Pervasive to version 10 on Windows 2008 R2.

I know this issue is complicated because it involves Microsoft, Crystal, and Pervasive. Microsoft basically asked me to seek help from Crystal. Crystal asked me to pass login information from the application to the report before opening it. However, I don't know how to pass login info for Pervasive since our Pervasive database has no security of any kind.

Thanks again

 I haven't used the Crystal Viewer recently so I don't have a lot of ideas.  Does the Viewer through VB.NET have a method or property or way of passing a username / password?  If so, try passing "Master" with and empty string password or your username with any password.  If there is no user/password on the PSQL database, anything can be passed and it should work.