Prev: Memory Full Error VB 6
Next: Monitor Files Copy Activities
From: M P on 12 Sep 2005 20:29
I am opening a Crystal Report file that will be dependent on the value that
will be pass from VB6. Here is the exact error:

'Error in File <C:\Path of Crystal Report File>: Unable to connect:
incorrect session parameters.'

I have tried using a database without database password and this error does
not appear only on the time that I assign database password to MS Access
Database(not with workgroup). I already set the password to Crystal and
created a connection string to VB with password. See below:

Private Sub cmdView_Click()
Dim strQry As String
Dim strmyParameter As String

gstrConnectionString = "Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\Access\DB.mdb;Uid=Admin;Pwd=mypassword;"
Set gconMyConnectionServer = New ADODB.Connection

gconMyConnectionServer.Open gstrConnectionString

strmyParameter = Trim(UCase(txtParameter.Text))

strQry = "SELECT * FROM tbl WHERE Item='" & strmyParameter & "'"

Set rs = New ADODB.Recordset

rs.Open strQry, gconMyConnectionServer, adOpenStatic, adLockReadOnly

With rptReport
.Connect = gstrConnectionString
.ReportFileName = App.Path & "\Reports\rptCR.rpt"
.WindowTitle = "My Report"
.WindowState = crptMaximized
.ParameterFields(0) = "@myParameter;" & strmyParameter & ";TRUE"
.Destination = crptToWindow
.Action = 1
End With

End If

rs.Close

End Sub

I try to run Step Into and found that the error triggers when it goes to the
..Action=1 . I am new to VB and Crystal hope that you can give me a solution
on how to solve this problem.

regards,

Me
From: PJ on 13 Sep 2005 04:26
I don't see where you are setting the data source to the recordset.

"M P" <MP(a)discussions.microsoft.com> wrote in message
news:584E6CC1-E89A-4FD1-9BA2-5B3C5531D6B4(a)microsoft.com...
> I am opening a Crystal Report file that will be dependent on the value
that
> will be pass from VB6. Here is the exact error:
>
> 'Error in File <C:\Path of Crystal Report File>: Unable to connect:
> incorrect session parameters.'
>
> I have tried using a database without database password and this error
does
> not appear only on the time that I assign database password to MS Access
> Database(not with workgroup). I already set the password to Crystal and
> created a connection string to VB with password. See below:
>
> Private Sub cmdView_Click()
> Dim strQry As String
> Dim strmyParameter As String
>
> gstrConnectionString = "Driver={Microsoft Access Driver
> (*.mdb)};Dbq=C:\Access\DB.mdb;Uid=Admin;Pwd=mypassword;"
> Set gconMyConnectionServer = New ADODB.Connection
>
> gconMyConnectionServer.Open gstrConnectionString
>
> strmyParameter = Trim(UCase(txtParameter.Text))
>
> strQry = "SELECT * FROM tbl WHERE Item='" & strmyParameter & "'"
>
> Set rs = New ADODB.Recordset
>
> rs.Open strQry, gconMyConnectionServer, adOpenStatic, adLockReadOnly
>
> With rptReport
> .Connect = gstrConnectionString
> .ReportFileName = App.Path & "\Reports\rptCR.rpt"
> .WindowTitle = "My Report"
> .WindowState = crptMaximized
> .ParameterFields(0) = "@myParameter;" & strmyParameter & ";TRUE"
> .Destination = crptToWindow
> .Action = 1
> End With
>
> End If
>
> rs.Close
>
> End Sub
>
> I try to run Step Into and found that the error triggers when it goes to
the
> .Action=1 . I am new to VB and Crystal hope that you can give me a
solution
> on how to solve this problem.
>
> regards,
>
> Me


From: M P on 13 Sep 2005 18:32
I don't understand what you mean. The Data Source was saved on a string
gstrConnectionString.

The parameter is based on the value on a textbox txtParameter.

Hoping for your reply.

"PJ" wrote:

> I don't see where you are setting the data source to the recordset.
>
> "M P" <MP(a)discussions.microsoft.com> wrote in message
> news:584E6CC1-E89A-4FD1-9BA2-5B3C5531D6B4(a)microsoft.com...
> > I am opening a Crystal Report file that will be dependent on the value
> that
> > will be pass from VB6. Here is the exact error:
> >
> > 'Error in File <C:\Path of Crystal Report File>: Unable to connect:
> > incorrect session parameters.'
> >
> > I have tried using a database without database password and this error
> does
> > not appear only on the time that I assign database password to MS Access
> > Database(not with workgroup). I already set the password to Crystal and
> > created a connection string to VB with password. See below:
> >
> > Private Sub cmdView_Click()
> > Dim strQry As String
> > Dim strmyParameter As String
> >
> > gstrConnectionString = "Driver={Microsoft Access Driver
> > (*.mdb)};Dbq=C:\Access\DB.mdb;Uid=Admin;Pwd=mypassword;"
> > Set gconMyConnectionServer = New ADODB.Connection
> >
> > gconMyConnectionServer.Open gstrConnectionString
> >
> > strmyParameter = Trim(UCase(txtParameter.Text))
> >
> > strQry = "SELECT * FROM tbl WHERE Item='" & strmyParameter & "'"
> >
> > Set rs = New ADODB.Recordset
> >
> > rs.Open strQry, gconMyConnectionServer, adOpenStatic, adLockReadOnly
> >
> > With rptReport
> > .Connect = gstrConnectionString
> > .ReportFileName = App.Path & "\Reports\rptCR.rpt"
> > .WindowTitle = "My Report"
> > .WindowState = crptMaximized
> > .ParameterFields(0) = "@myParameter;" & strmyParameter & ";TRUE"
> > .Destination = crptToWindow
> > .Action = 1
> > End With
> >
> > End If
> >
> > rs.Close
> >
> > End Sub
> >
> > I try to run Step Into and found that the error triggers when it goes to
> the
> > .Action=1 . I am new to VB and Crystal hope that you can give me a
> solution
> > on how to solve this problem.
> >
> > regards,
> >
> > Me
>
>
>
From: PJ on 16 Sep 2005 09:26
You are creating a recordset in your code. Usually, if a recordset is
created it is used as input to the report.

You don't indicate the version of CR or VB. It is possible that .action is
not available. In CR9, with VB6, it is not available.


"M P" <MP(a)discussions.microsoft.com> wrote in message
news:7B604FF9-5378-4133-83D8-F4149F7D8189(a)microsoft.com...
> I don't understand what you mean. The Data Source was saved on a string
> gstrConnectionString.
>
> The parameter is based on the value on a textbox txtParameter.
>
> Hoping for your reply.
>
> "PJ" wrote:
>
> > I don't see where you are setting the data source to the recordset.
> >
> > "M P" <MP(a)discussions.microsoft.com> wrote in message
> > news:584E6CC1-E89A-4FD1-9BA2-5B3C5531D6B4(a)microsoft.com...
> > > I am opening a Crystal Report file that will be dependent on the value
> > that
> > > will be pass from VB6. Here is the exact error:
> > >
> > > 'Error in File <C:\Path of Crystal Report File>: Unable to connect:
> > > incorrect session parameters.'
> > >
> > > I have tried using a database without database password and this error
> > does
> > > not appear only on the time that I assign database password to MS
Access
> > > Database(not with workgroup). I already set the password to Crystal
and
> > > created a connection string to VB with password. See below:
> > >
> > > Private Sub cmdView_Click()
> > > Dim strQry As String
> > > Dim strmyParameter As String
> > >
> > > gstrConnectionString = "Driver={Microsoft Access Driver
> > > (*.mdb)};Dbq=C:\Access\DB.mdb;Uid=Admin;Pwd=mypassword;"
> > > Set gconMyConnectionServer = New ADODB.Connection
> > >
> > > gconMyConnectionServer.Open gstrConnectionString
> > >
> > > strmyParameter = Trim(UCase(txtParameter.Text))
> > >
> > > strQry = "SELECT * FROM tbl WHERE Item='" & strmyParameter & "'"
> > >
> > > Set rs = New ADODB.Recordset
> > >
> > > rs.Open strQry, gconMyConnectionServer, adOpenStatic, adLockReadOnly
> > >
> > > With rptReport
> > > .Connect = gstrConnectionString
> > > .ReportFileName = App.Path & "\Reports\rptCR.rpt"
> > > .WindowTitle = "My Report"
> > > .WindowState = crptMaximized
> > > .ParameterFields(0) = "@myParameter;" & strmyParameter &
";TRUE"
> > > .Destination = crptToWindow
> > > .Action = 1
> > > End With
> > >
> > > End If
> > >
> > > rs.Close
> > >
> > > End Sub
> > >
> > > I try to run Step Into and found that the error triggers when it goes
to
> > the
> > > .Action=1 . I am new to VB and Crystal hope that you can give me a
> > solution
> > > on how to solve this problem.
> > >
> > > regards,
> > >
> > > Me
> >
> >
> >


From: M P on 18 Sep 2005 20:27
Im using VB 6 and CR 8.0 Developmer Edition. Hope you could help me.

"PJ" wrote:

> You are creating a recordset in your code. Usually, if a recordset is
> created it is used as input to the report.
>
> You don't indicate the version of CR or VB. It is possible that .action is
> not available. In CR9, with VB6, it is not available.
>
>
> "M P" <MP(a)discussions.microsoft.com> wrote in message
> news:7B604FF9-5378-4133-83D8-F4149F7D8189(a)microsoft.com...
> > I don't understand what you mean. The Data Source was saved on a string
> > gstrConnectionString.
> >
> > The parameter is based on the value on a textbox txtParameter.
> >
> > Hoping for your reply.
> >
> > "PJ" wrote:
> >
> > > I don't see where you are setting the data source to the recordset.
> > >
> > > "M P" <MP(a)discussions.microsoft.com> wrote in message
> > > news:584E6CC1-E89A-4FD1-9BA2-5B3C5531D6B4(a)microsoft.com...
> > > > I am opening a Crystal Report file that will be dependent on the value
> > > that
> > > > will be pass from VB6. Here is the exact error:
> > > >
> > > > 'Error in File <C:\Path of Crystal Report File>: Unable to connect:
> > > > incorrect session parameters.'
> > > >
> > > > I have tried using a database without database password and this error
> > > does
> > > > not appear only on the time that I assign database password to MS
> Access
> > > > Database(not with workgroup). I already set the password to Crystal
> and
> > > > created a connection string to VB with password. See below:
> > > >
> > > > Private Sub cmdView_Click()
> > > > Dim strQry As String
> > > > Dim strmyParameter As String
> > > >
> > > > gstrConnectionString = "Driver={Microsoft Access Driver
> > > > (*.mdb)};Dbq=C:\Access\DB.mdb;Uid=Admin;Pwd=mypassword;"
> > > > Set gconMyConnectionServer = New ADODB.Connection
> > > >
> > > > gconMyConnectionServer.Open gstrConnectionString
> > > >
> > > > strmyParameter = Trim(UCase(txtParameter.Text))
> > > >
> > > > strQry = "SELECT * FROM tbl WHERE Item='" & strmyParameter & "'"
> > > >
> > > > Set rs = New ADODB.Recordset
> > > >
> > > > rs.Open strQry, gconMyConnectionServer, adOpenStatic, adLockReadOnly
> > > >
> > > > With rptReport
> > > > .Connect = gstrConnectionString
> > > > .ReportFileName = App.Path & "\Reports\rptCR.rpt"
> > > > .WindowTitle = "My Report"
> > > > .WindowState = crptMaximized
> > > > .ParameterFields(0) = "@myParameter;" & strmyParameter &
> ";TRUE"
> > > > .Destination = crptToWindow
> > > > .Action = 1
> > > > End With
> > > >
> > > > End If
> > > >
> > > > rs.Close
> > > >
> > > > End Sub
> > > >
> > > > I try to run Step Into and found that the error triggers when it goes
> to
> > > the
> > > > .Action=1 . I am new to VB and Crystal hope that you can give me a
> > > solution
> > > > on how to solve this problem.
> > > >
> > > > regards,
> > > >
> > > > Me
> > >
> > >
> > >
>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: Memory Full Error VB 6
Next: Monitor Files Copy Activities