473,660 Members | 2,459 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query Engine Error after Forced Protocol Encryption on Crystal Report

jeffstl
432 Recognized Expert Contributor
After enabling forced protocol encryption on SQL server there are a handful of crystal reports that have the following error when you try to run them

Query Engine Error: '08S01:[Microsoft][ODBC SQL Server Driver]Communication link failure

Turn the forced protocol encryption off on SQL Server and they work again just fine. I have tried re-choosing the data source of the .rpt files, and tried turning on Integrated Security before loading the reports with no luck

Has anyone had this problem? Is there something that can be done to let these reports run with forced protocol encryption?
Nov 17 '09 #1
0 1654

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2082
by: Gary | last post by:
Hi All, I am hoping someone can either help me with this issue or recommend a third party company to aid in its resolution. Environment: VS 2003, W2K3 Crystal Report 9.0 SQL 2000
0
1702
by: william_dudek | last post by:
I have a crystal report that works fine when run through Crystal, which I am triying to incorporate into a crystal report viewer. The report takes 1 parameter, which is either 0 or 1. If the paremeter is 1 then a filter is placed onto the data by the database server (Oracle PL/SQL procedure in a package), parameter is 0 then it doesn't use the filter. When I run this with the filter on the program works fine and the report is displayed,...
0
1453
by: raf_z | last post by:
Hi, I think i'm doing something simple, although i may be wrong. I was able to load a Crystal report file up until today, and even now, its only 1 report that's misbehaving. I'll confess that i didn't create the report, it was done by our Crystal guy with Crystal 9 (or 8), all i do is load it using .NET, which, like i said before, worked just fine. Here's the code: //i call this func from Page_Load passing in only the filename
0
5235
by: Pavan | last post by:
THIS IS THE ERROR I GOT: --------------------------- Report Generation Error --------------------------- <Our System specific error raised by out VB.NET application..inserted by Developer>
2
6496
by: Hardy Wang | last post by:
Hi, I have a console application to export crystal reports result to PDF. For one of my report file, when i call Export() function from my code, I get "unknown query engine error". I have Crystal Reports 8.5 with service pack 3 installed. If I load this report directly from Crystal Reports 8.5 IDE, everything is fine. I did a search, and found most articles talk about version 9 or 10, is there anybody has idea how to handle this problem...
1
4245
by: Frank Teunen | last post by:
Dear reader, I'm having a problem linking a dataset to a crystal report. I'm using next code. In between I explain my problem 'This code is to fill a dataset with the result of a stored procedure on an SQL data base Adapter_Sp_CoparnEmptyAfterDate.SelectCommand.Parameters("@Date").Value = DateTimePicker1.Value
2
8682
by: matt | last post by:
hello, i have an .RPT file that i am using to load a report via the ASP.NET CrystalReportViewer control. i dont include my .RPTs as embedded resources...instead i load the absolute path of the .rpt (on the file system) to the control's ".ReportSource" property. i do this because i like to move new versions of the reports w/o having to rebuild the site. then i pass in filter criteria to the control's ".SelectionFormula"
2
2022
by: Jason Huang | last post by:
Hi, In my computer, I have the built in Crystal Report for VS on my Visual Studio .Net 2003, but this version of Crystal Report doesn't meet my need. So I have installed a new Crystal Report XI on my VS2003 without removing the built in Crystal Report for VS. When I tried to open a report which is created in the CR11, the VS.Net gave me an error saying "query engine error". How do I fix the question so that I can open a CR11 report in...
7
6702
by: Jlo | last post by:
Hi, I have a c# winforms application. When I call the report file, it shows me all the records in the table. How can I make it to call only a particular range. i have the following code Viewer1.ReportSource = Application.StartupPath + "//Label.rpt"; How can I assign it a dataset which have the data of a particular range.
0
8341
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8630
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6181
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5650
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4343
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2760
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1984
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1740
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.