Home > Cannot Open > Cannot Open Sql Server Crystal Reports 8.5

Cannot Open Sql Server Crystal Reports 8.5

Join & Ask a Question Need Help in Real-Time? Crystal has several methods for viewing reports. For some reason, Crystal Reports cannot connect to the server once it opens, then it immediately quits, and returns the error. 0 LVL 10 Overall: Level 10 Visual Basic Classic Does anyone have a solution? http://sauvblog.com/cannot-open/cannot-open-sql-server-crystal-reports-8.html

With Crystal 6.0, it is a separate program. I also tried the DSN-less string: "DSN=InsunetDB;TRUSTED_CONNECTION=yes;Initial Catalog=insunet" for both the .ConnectionString and .Connect properties. (These work when I select them as the Machine data Source when I run the report Notes: 1) I assume the UDL is correct since the app has no problem accessing the data, and a "Test Connection" always works. 2) I can manually open the report, assign I don't know what was wrong, but I guess I've mangled too much with the settings on the CR VCL component, because after I deleted it and placed a new one http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/crystal-report-runtime-error-20599-can-not-open-sql-server-1395720

The subreport based on a second database is not updating and sometimes the report reports an error "Cannot open SQL Server".The database is open and available, and the report works on Can I use that to take out what he owes me? All times are GMT -5.

Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics Powered by Hana. However in the end, it still fails with the same result. 0 Message Author Comment by:baer_lee2008-01-03 Comment Utility Permalink(# a20579334) Actually, isn't "con" the connection object? 0 LVL 100 Thank you for your help. /Snebal 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Expert Comment by:mlmcc2003-05-31 Comment Utility Permalink(# a8622613) Glad I could help mlmcc

When you say the SQL driver may need upgrading, which file is this? If not do an update install and select custom to add the print engine. Inequality caused by float inaccuracy Select 2D data in a certain range How to be Recommended to be a Sitecore MVP Operator ASCII art Why do the cars die after removing http://p2p.wrox.com/pro-vb-databases/11987-error-20599-cannot-open-sql-server.html Use this line of code.

wht u need to check is that is ur report is pointing to the same sql server which u r trying to point through vb code. But anyway, thanks for your help :) /Snebal 0 Message Expert Comment by:babashri2003-05-30 Comment Utility Permalink(# a8617864) OPen the report and save the report with the 'save data with report' Did you load the Print Engine when you loaded CR? I've managed to get it working on my development machine but still need to address the others individually.

I am not familiar with Delphi and the VCL method of displaying reports but if you have built the reports in CR 8 it may be the VCL7.5 cannot open the We have on the company I work for an application built in Delphi V with Crystal Reports 8. Crystal has its own database drivers and the report expects to use them so if you built the report with something other than ADO it generally won't work propery. The drivers I am referring to come with Crystal.

as i am new to crystal reports i am unable to understand why this error is coming. this contact form Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics I've book-marked it for later!Stop by my web-site lloyd irvin Reply Newer Post Older Post Translator Our Sponsors Popular Posts Remove Windows Not Genuine Watermark Without Using Any Patches And Cracks An example is the ability to programmatically talk to Microsoft Outlook.

View All Topics View All Members View All Companies Toolbox for IT Topics Visual Basic Groups Ask a New Question Visual Basic – General Discussions The VB - General Discussions group Connect with top rated Experts 27 Experts available now in Live! CRWCHK32.EXE - This utility was meant to be run on a client machine. have a peek here Solution: You can Google for the software scr8_webregfix.exe run to fix this issue.

Remove this forumla if u think this formula is creating problem and then run it. Why there are no approximation algorithms for SAT and other decision problems? If SQLCON cannot connect, then the problem is with the installation and setup of the ODBC drivers.

Should I allow my child to make an alternate meal if they do not like anything served at mealtime?

I have been successful in installing the prerequisites including the visual basic runtime + sp6 components and everything else on windows 8 after a lot of googling. I've also tried to add "CRDelphi.OpenEngine;" in my FormCreate, but that didn't help either. /Snebal 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Expert Comment by:mlmcc2003-05-28 The database of the report is ODBC datasource connecting to SQLServer. rasinc rasinc November 21, 2011 at 20:02 PM 0 Likes 1 replies Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter current community chat Stack Overflow Meta

Covered by US Patent. When you create a new System DSN, it does not inherit the Windows NT default permissions, or the new permissions created by the Crystal Reports 8 installation. Class modules can be a powerful tool in Microsoft Access. Check This Out ravishrivas replied May 1, 2007 HI, If your database server in change at runtime then you have to pass the information to the report object at runtime so that this problem

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed mlmcc 0 Message Author Comment by:Michael G2003-05-30 Comment Utility Permalink(# a8617087) mlmcc: I use the "For loop" in the function i posted earlier, to pass the paramters to the report. Thanks and Regards, Muhammad Abbas Reply With Quote Quick Navigation Reporting Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net The time now is 05:50 AM.

Thanks in advance. 0 Comment Question by:Michael G Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/20627660/Error-599-Cannot-open-SQL-server.htmlcopy LVL 4 Best Solution byjrmn Hi snebal, Just wondering why you're not using the latest crystal reports 8/8.5 For more information, see the following Crystal Decisions Knowledge Base article: http://support.crystaldecisions.net/library/kbase/articles/c2007581.asp What this mean is Crystal Reports was the culprit. How do I solve this problem? It's primary use is to test out ODBC connection problems on client machines.

frmINSUNET.crpCtrl.Connect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=insunet;Data Source=P17" This guy is not using a connection object. anyways thx for the response. Thanks in advance Saritha. All product names are trademarks of their respective companies.

Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name This program is mainly intended to simplify the distribution of Compiled Reports, which are usually used by people who do not want to do a programming interface to the runtime engine. It is an application which connects to ODBC and tests out ODBC Data Sources to see if they are functioning correctly. Adverb for "syntax" Advisor professor asks for my dissertation research source-code Why are LEDs in my home unaffected by voltage drop?

Do you also experience this problem on your development computer? 0 Message Author Comment by:baer_lee2008-01-04 Comment Utility Permalink(# a20581252) My Crystal Report version is 7.01. The "Convert database driver" tells me that I'm using the "pdssql.dll" to connect to my SQL Server. vishal kumar replied Jun 15, 2010 i am also having the same problem ....if any body found the solution then pls let me know.my code is : Cr1.ReportFileName = App.Path & They can easily hide the complexity of a process from… MS Access Visual Basic Classic Advertise Here 780 members asked questions and received personalized solutions in the past 7 days.

Hash3181: Yes to both questions. All rights reserved. Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use.