VB6, Seagate Crystal Report 8, and Windows 7.

Question

We are facing problem with some old software:

Architecture : Client-Server
Database     : MS-SQL Server 2000
FrontEnd     : MS-VB6
Report       : Seagate Crystal Report 8
Network Type : Win XP Workgroup
Security Policy : "Windows and SQL Server" in MS-SQL Server
Crystal Repot Designed with ODBC and at runtime it is calling using Connectionstring

In Windows 7, when we use "Windows Authentication" security policy in SQL server, it's showing report usually at run time, but when we use "Windows And SQL-Server" security policy in SQL server, it's showing error "Can't open SQL server" when calling any report at run time.

Answer 1

The discussion around this problem is troubleshooted on various websites. The common reason and fix is to use only one connection to the SQL Server. For both methods, Windows Authentication and SQL server, there might be additional settings that need to be configured.

I recommend checking the information listed through Google Search in order to find out the possible configuration and fixes for this error: http://goo.gl/TJI26j

Answer 2

The discussion around this problem is troubleshooted on various websites. The common reason and fix is to use only one connection to the SQL Server. For both methods, Windows Authentication and SQL server, there might be additional settings that need to be configured.