Error 599 Cannot Open Sql Server. Execute Pestartprintjob

for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error:599 Cannot open SQL server Want to Advertise Here? Solved Error:599 Cannot open SQL server Posted on 2003-05-27 Crystal Reports 2 Verified Solutions 12 Comments 30,723 Views Last Modified: 2011-08-18 Error:599 Cannot open SQL server Execute . I use Delphi5 Enterprise (Update pack 1 and Delphi 5 ADOExpress Update Pack 2 are installed) and the Crystal Reports VCL v. 7.5.0.52 to view/print my reports. The reports are designed in Crystal Reports 8 Developer Edt. and I use af MS SQL Server 7. The above problem occurs when I try to show/print the report with other data than the ones that was saved with the report. Fx, I preview the report in Crystal Reports with the parameter id "7" and saves the data with the report - no problem there. If I then try to open the report (also with parameter id "7") in my Delphi program, everything still works fine. But, if I from my Delphi program opens the report using parameter id "2", then the above error occurs. The "Convert database driver" tells me that I'm using the "pdssql.dll" to connect to my SQL Server. Isn't pd*.dll old 16bit drivers !? I've download p2ssql.dll v. 8.0.0.21 from Crystals web site, but I can't select it in the "Convert database driver" list !? Hope you have a solution to my problem. Thanks in advance. 0 Question by:Michael G Facebook Twitter LinkedIn Google LVL 4 Best Solution byjrmn Hi snebal, Just wondering why you're not using the latest crystal reports 8/8.5 VCL. Are there any issues you have to consider??? If there are no issues at all, I highly recommend you to go to cystal Go to Solution 12 Comments LVL 100 Overall: Level

Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just https://www.experts-exchange.com/questions/20627660/Error-599-Cannot-open-SQL-server.html copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal Reports 2 Data Access Forum at Tek-Tips HomeForumsProgrammersReporting SolutionsBusiness Objects: Crystal Reports 2 Data Access Forum Reporterror : Error 599 Cannot find SQL server thread766-82545 Forum Search FAQs Links MVPs Reporterror : Error 599 Cannot find SQL server Reporterror : Error 599 Cannot find SQL server bolleke (Programmer) (OP) 14 http://www.tek-tips.com/viewthread.cfm?qid=82545 May 01 10:03 Hello,I have the following problem.I have a oracledatabase (GISA) running on an NT4-server.The reports are made with Crystal Reports 6 and all works well until I install Discoverer on my desktop.The following occurs:I can't print (or view) anything anymore from my 'GISA'-database. The following error occurs :Report error : Error 599 Cannot find SQL server - Execute .Yves RE: Reporterror : Error 599 Cannot find SQL server kenhamady (Instructor) 14 May 01 19:00 It works before discoverer and not after?What is discoverer? Ken Hamadyhttp://www.kenhamady.com/Crystal Reports Training/Consulting and a Quick Reference Guide to VB/Crystal (including ADO) RE: Reporterror : Error 599 Cannot find SQL server bolleke (Programmer) (OP) 15 May 01 02:44 Discoverer is a tool from Oracle with which we can make reports. It is a tool that generates sql-statements and makes some layout. I can compare it with Crystal Reports, but much more powerfull on Oracle-databases. RE: Reporterror : Error 599 Cannot find SQL server kenhamady (Instructor) 15 May 01 13:28 Must be a conflict between the two. What if you reinstall CR after Discoverer? Do they both work? Ken Hamadyhttp://www.kenhamady.com/Crystal Reports Training/Consulting and a Quick Reference Guide to VB/Crystal (including ADO) Red Flag This Post Please let

NC#1 / 1 Error 599 "Cannot open SQL Server" when running ODBC http://computer-programming-forum.com/67-vb-crystal-report/828558a1e2516531.htm report after setting parameters Hi All, I'm using CR8.0 and http://www.bundle-track.com/okb/599.htm I have created a report based on a query through ODBC. The query have several parameters. What I try to do is to programmatically generate the report using the Crystal Print Engine APIs (PE* functions) in VB. What I do error 599 is Open the print engine and report Use PEGetNthParameterField and PEAddParameterCurrentValue to set the parameter Generate the report... I always get the error 599 "Cannot open SQL Server" when I call PEStartPrintJob. If I haven't set the parameters in the code, things are fine. The parameter dialog comes up, and error 599 cannot once I enter the parameters value, the report is generated. So, this problem only happens after I set the parameters but setting the parameters returns no error. Is anyone have any idea of this problem? Your help is highly appreciated. Thanks Fri, 12 Dec 2003 04:14:13 GMT Page 1 of 1 [ 1 post ] Relevant Pages 1. "Cannot open SQL Server" 2. Crystal 6 with Oracle - Error 599 SQL SERVER NOT FOUND 3. 5981 error, "Cannot open macro storage" 4. Run-time error 20599: Cannot open SQL Server 5. Crystal Reports "Cannot Find Report." 6. Error: "Server not yet opened" 7. "server not yet opened" error 8. "server not yet opened" error 9. 599 - Crystal Reports & Oracle Server 10. "Cannot load """ 11. Cannot open the "Visual Basic-Editor" 12. Crystal Reports ,VB,SQL-Server Error "Server is not opened" Powered by phpBB Forum Software

open SQL Server" Error 599 Cannot open SQL server Execute . Typically, this indicates that someone has unsuccessfully tinkered with the ODBC connection and/or the BDE connection, leaving a valid database path in the BDE connection and an invalid path in the ODBC connection. Users will be able to log into Bundle-Track but will be unable to print or preview reports. To correct this, use Bundle-Track Links to prepare your database connections. Bundle-Track Links will properly set both the ODBC and BDE connections. We welcome your comments at support@bundle-track.com. If you would like our live assistance, you may hire us at our professional services rate. top