Agfdhyk

up vote 1 down vote favorite I Have a vb6 application using crystal report 8.5 and sql server 2005.My issue is that when I print report i get Server has not yet been opened.Here is my code in vb.: Option Explicit Dim ctr As Integer Dim cn As New ADODB.Connection--Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=user ID;Initial Catalog=database Name;Data Source=server Name Dim crApp As CRAXDRT.Application Dim crReport As CRAXDRT.Report Dim crtable As CRAXDRT.DatabaseTable Private Sub prin_Click() Dim rs As New ADODB.Recordset Set cn = New ADODB.Connection cn.ConnectionString = MDI1.txtado cn.Open Set rs = New ADODB.Recordset rs.Open "select * from temp_abs_yes", cn, adOpenKeyset, adLockOptimistic Set crApp = New CRAXDRT.Application Set crReport = crApp.OpenReport(&quo