First time here? Check out the FAQ!
x

VB6, Seagate Crystal Report 8, and Windows 7.

0 votes
asked by about Seagate Crystal Reports
edited by

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.

2 Answers

0 votes
answered by (329k points)

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

0 votes
answered by

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...