Crystal Report Viewer Error Server Has Not Yet Been Opened
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 server has not yet been opened vb6 Hire for a Full Time Job Ways to Get Help Expand Search Submit server yet not open in crystal report Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts crystal reports server has not yet been opened windows 7 Exchange > Questions > Crystal 8.5 and VB6 - Server has not yet been opened error Want to Advertise Here? Solved Crystal 8.5 and VB6 - Server has not yet been server has not yet been opened crystal reports error vb opened error Posted on 2010-07-01 Visual Basic Classic Crystal Reports 1 Verified Solution 8 Comments 5,604 Views Last Modified: 2013-12-20 I have a few different reports that are called from a vb6 application. They currently connect directly to the tables they need the info from for the report and I decided to convert from that to stored procedures. I have my stored procedure ready and working and added it to my report. It showed the fields that I put in there and I added them to my report. I verified that report works using the username/password that my program uses to access the database inside of Crystal Reports and all looks good there. I didn't change anything in my code that was previously working. Theoretically, by adding that stored proc, nothing should have changed. However, now when I try to execute the report, I'm getting "Server has not yet been opened." Does anyone have any suggestions on fixing this or has seen this before? Dim crxRpt As CRAXDRT.Report Dim crxApp As New CRAXDRT.Application Dim crxTable As CRAXDRT.DatabaseTable Set colreport = colReports(cboReport) Set crxRpt = crxApp.OpenReport(App.Path & "\" & colreport.Filename) For Each crxTable In crxRpt.Database.Tables crxTable.SetLogOnInfo gtServer, gtDatabase, gtUserName, gtPassword Next crxRpt.DiscardSavedData crxRpt.EnableParameterPrompting = False frmReportViewer.CRViewer1.ReportSource = crxRpt frmReportViewer.CRViewer1.ViewReport frmReportViewer.Caption = colreport.Description frmReportViewer.Show vbM
has not yet been opened If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Crystal Reports error: Server has not yet been opened Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 16th, 2001,11:04 AM #1 JMuller View Profile View Forum Posts Thread Starter Lively Member Join Date Apr 2000 Location Rafaela (Argentine) Posts 107 Crystal Reports error: Server has https://www.experts-exchange.com/questions/26301929/Crystal-8-5-and-VB6-Server-has-not-yet-been-opened-error.html not yet been opened I'm using a Crystal Reports Viewer Control, to show a report in a VB form. If I install the program in a PC that doesn't have VB nor Crystal Reports installed, when I try to show the report, I get the error 'Server has not yet been opened'. Could anybody help me with this? Thanks a lot Reply With Quote Nov 16th, 2001,11:43 AM #2 andyL View Profile View Forum Posts Lively Member Join Date http://www.vbforums.com/showthread.php?119860-Crystal-Reports-error-Server-has-not-yet-been-opened Jul 2001 Location NY Posts 89 What database are you using? SQL Server? AndyL Reply With Quote Nov 16th, 2001,11:47 AM #3 JMuller View Profile View Forum Posts Thread Starter Lively Member Join Date Apr 2000 Location Rafaela (Argentine) Posts 107 I'm using ODBC (file DSN connection) to connect to an Access 97 database. Reply With Quote Nov 16th, 2001,12:15 PM #4 andyL View Profile View Forum Posts Lively Member Join Date Jul 2001 Location NY Posts 89 In the report go to database and try Verify location. Did you set up the ODBC connection on the computer you installed it on? You might be missing some DLL files on the computer you installed it on. Other than that I'm not sure what it could be. Also try http://support.crystaldecisions.com/fix/ask.asp and http://www.crystaldecisions.com/ AndyL Reply With Quote Nov 16th, 2001,12:29 PM #5 scostell View Profile View Forum Posts Hyperactive Member Join Date May 2001 Posts 306 You may have to login to the server from your VB code. VB Code: cr.connect "DSN=" & g_SERVER & ";UID=" & g_SYSUserID & ";PWD=" & g_SYSPW & ";DBQ=" & g_DBName Reply With Quote Jan 4th, 2002,11:23 AM #6 ted123 View Profile View Forum Posts Lively Member Join Date Jun 2001 Posts 72 Follow up to Crystal Reports Originally posted by scostell You may have to login to the server from your VB code. VB Code: cr.connect "DSN=" & g_SERVER &
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Server has not been opened yet (Crystal https://social.technet.microsoft.com/Forums/windowsserver/en-US/9c5598ad-44c7-478c-8856-64405fd038a5/server-has-not-been-opened-yet-crystal-report85?forum=winservergen Report8.5) Windows Server > Windows Server General Forum Question 0 Sign in to http://vbcity.com/forums/t/108808.aspx vote Weare trying to runWindows2003 Server SP2 with Crystal Report8.5 We are facing the following issue. When an asp file is trying to call an rpt(Crystal Report)file, the application shows error message as follows. Seagate Crystal Reports ActiveX Designer error '80047288' Server has not been opened yet /***/***/***.asp, line*** It seems crystal report like the error is occuring @ session("oRpt").ReadRecords in the asp file in accessing MS SQL Serverby odbc. I'll be grateful if someone could provide assistance to solve the issue. Regards Edited by ymoshimoshi Friday, November 16, 2012 12:12 PM Friday, November 16, 2012 12:11 PM Reply | Quote Answers 0 Sign in to vote Hi, Please refert to the below link: http://scn.sap.com/thread/2042206 In addition, please server has not also ask in the Crystal Report forum. Regards, Yan LiYan Li TechNet Community Support
Proposed as answer by Yan Li_Moderator Friday, November 23, 2012 2:09 AM Marked as answer by Yan Li_Moderator Monday, November 26, 2012 2:03 AM Monday, November 19, 2012 8:29 AM Reply | Quote Moderator All replies 0 Sign in to vote After doing some research found two possible ways to fix crystal report error. Clear C:\windows\temp\ and run report.Check this thread and act accordingly. Regards, Ravikumar P Friday, November 16, 2012 2:02 PM Reply | Quote 0 Sign in to vote Hi, Please refert to the below link: http://scn.sap.com/thread/2042206 In addition, please also ask in the Crystal Report forum. Regards, Yan LiYan Li TechNet Community Support Proposed as answer by Yan Li_Moderator Friday, November 23, 2012 2:09 AM Marked as answer by Yan Li_Moderator Monday, November 26, 2012 2:03 AM Monday, November 19, 2012 8:29 AM Reply | Quote Moderator Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.(RESOLVED) rated by 0 users This post has 2 Replies | 1 Follower homebunny Belgium Since 7/27/2005 Posts 58 Reputation 650 Reply Homebunny (homebunny) Posted: 10/3/2005 5:25 AM rated by 0 users Hi all,I'm facing a difficult problem, I have read dozens threads about it but had no luck to resolve this:In VB6 with CR 8.5: I'm getting this error "Server has not yet been opened."This is my Code:Code:Private Sub Form_Load()Dim cn As ADODB.ConnectionDim rs As ADODB.RecordsetDim crxApp As CRAXDRT.ApplicationDim crxreport As CRAXDRT.ReportDim crxTable As CRAXDRT.DatabaseTableSet cn = New ADODB.Connectioncn.CursorLocation = adUseClientcn.ConnectionString = gl_cLogon.DSN_Connect_String_ADODB '*// this works fine in my forms - MSHFlexGridcn.OpenSet rs = New ADODB.Recordsetrs.Open "SELECT * FROM vw_Delfor_summary_Resource", cn, adOpenKeyset, adLockOptimistic, adCmdTextSet crxApp = New CRAXDRT.ApplicationSet crxreport = crxApp.OpenReport("S:\dummy.rpt", 1)With crxreport.Database.Tables(1)sDll = .DllNamesServer = .LogOnServerNamesDb = .LogOnDatabaseNameIf sServer <> "" Or sDb <> "" Then 'Need to log oncrxreport.Database.LogOnServer sDll, sServer, sDb '*// Here I get the error "Server has not yet been opened."For Each crxTable In crxreport.Database.TablescrxTable.SetLogOnInfo sServer, sDbNextEnd IfEnd With'disgard any saved data and repopulate the reportcrxreport.DiscardSavedDatacrxreport.Database.SetDataSource rsCRViewer1.ReportSource = crxreportCRViewer1.ViewReportrs.CloseSet rs = Nothingcn.CloseSet cn = NothingSet crxTable = NothingSet crxApp = NothingSet crxreport = NothingEnd SubWho has experience with this to get this damn thing to work ?Many thanks in advance! | Post Points: 5 homebunny Belgium Since 7/27/2005 Posts 58 Reputation 650 Reply Homebunny (homebunny) replied on 10/4/2005 12:34 AM rated by 0 users Bump | Post Points: 5 homebunny Belgium Since 7/27/2005 Posts 58 Reputation 650 Reply Homebunny (homebunn