I'm running into a problem with Crystal Reports that users view from within our application created with Visual Studio. I've been able to narrow it down to MS SQL Express vs. MS SQL Standard.
For testing purposes,
Database: I have a test table with two columns: rowid (int) and data (varchar(50)). There are 10 rows in the test table.
Report: The report is showing the 10 rows, no criteria ... just display all.
Program: Visual Studio vb.net 2010 app, using Crystal Report viewer control.
When SQL 2012 Express is installed, it is installed with the default instance option, so it is running similar to how SQL 2012 Standard does - I am able to connect to it from my development workstation using SQL Manager, just as I would any other SQL server.
When I run the app on my development workstation, it shows the report without any issues. It pops up the Crystal login screen:
Server Name: garfield
Database: Test
Login ID: sa
Password: {blank}
I enter my password, and it displays the report.
When I run the app from any client workstation and the database is MS SQL 2012 Standard, it functions exactly as it does on my development workstation. But if the database is MS SQL 2012 Express, the Crystal login screen pops up like this:
Server Name: garfield
Database: {blank} {greyed out, cannot type in it}
Login ID: sa
Password: {blank}
I enter my password, and it gives me "Login Failed. Please try again."
I've tried SQL 2008 Standard and SQL 2008 Express, with the same results.
I've tried Visual Studio 2008, with the same results.
I've searched online over and over, but am coming up with nothing that seems to help. Anyone else have experience with this?
Thanks,
Sheldon
For testing purposes,
Database: I have a test table with two columns: rowid (int) and data (varchar(50)). There are 10 rows in the test table.
Report: The report is showing the 10 rows, no criteria ... just display all.
Program: Visual Studio vb.net 2010 app, using Crystal Report viewer control.
When SQL 2012 Express is installed, it is installed with the default instance option, so it is running similar to how SQL 2012 Standard does - I am able to connect to it from my development workstation using SQL Manager, just as I would any other SQL server.
When I run the app on my development workstation, it shows the report without any issues. It pops up the Crystal login screen:
Server Name: garfield
Database: Test
Login ID: sa
Password: {blank}
I enter my password, and it displays the report.
When I run the app from any client workstation and the database is MS SQL 2012 Standard, it functions exactly as it does on my development workstation. But if the database is MS SQL 2012 Express, the Crystal login screen pops up like this:
Server Name: garfield
Database: {blank} {greyed out, cannot type in it}
Login ID: sa
Password: {blank}
I enter my password, and it gives me "Login Failed. Please try again."
I've tried SQL 2008 Standard and SQL 2008 Express, with the same results.
I've tried Visual Studio 2008, with the same results.
I've searched online over and over, but am coming up with nothing that seems to help. Anyone else have experience with this?
Thanks,
Sheldon