|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello,
actually this is my first time to post here, nway i have a VB Application and i used Crystal Report 4.6 for the generation of my reports and my database is MS Access 97, i set a password on my database, and now my problem is when i am going to generate / display my report i got this error message " Run Time error "20535" Error in file L:Reports\identdata.rpt: Unable to connect: Incorrect Session Parameters. when i unset my database password, the reports is properly working but when i set the password on my database i got this error message in which i could not load my report. Can anyone help me get through this error? |
|
#2
|
||||
|
||||
|
Sounds like Crystal is attempting to connect as anonymous You should look into the web based files to find what is actually creating the session or the database conn and see if you can adjust the script. It would be easier to help if I could see the script though
|
|
#3
|
|||
|
|||
|
Like werD said it will be easier to help you if we could see the VB code you are using to open the report
S-
__________________
If you have found a particular post helpful, show your appreciation by adding reputation points to that user by clicking the "scales" image in the upper right had corner of their post. |
|
#4
|
|||
|
|||
|
this is the script i wrote.............thanks for the response
With CR_DIS .ReportFileName = REPPATH & "idendata.rpt" .DataFiles(0) = DBPATH + "cotiinv.mdb" .Formulas(0) = "FROM = '" & MN & "/" & DY & "/" & YR + "'" ' PASSING OF VALUE FROM FORM TO CRYSTAL .Formulas(1) = "TO =' " & MN2 & "/" & DY2 & "/" & YR2 + "'" .Formulas(3) = "FROM1 = '" & MN3 & "/" & DY3 & "/" & YR3 + "'" .Formulas(4) = "TO1 = '" & MN4 & "/" & DY4 & "/" & YR4 + "'" .SelectionFormula = "{TRANSHIST.odat} >= Date(" & YR & "," & MN & "," & DY & ") AND {TRANSHIST.odat} <= Date(" & YR2 & "," & MN2 & "," & DY2 & ")" _ & " AND {BEGINVTY.pdat} >= Date(" & YR3 & "," & MN3 & "," & DY3 & ") AND {BEGINVTY.pdat} <= Date(" & YR4 & "," & MN4 & "," & DY4 & ")" _ & " AND {TRANSHIST.wrhs}>= '" + DBCombo1.Text + "' AND {TRANSHIST.wrhs}<= '" + DBCombo2.Text + "'" _ & " AND {TRANSHIST.lcod}>= '" + DBCombo3.Text + "' AND {TRANSHIST.lcod}<= '" + DBCombo4.Text + "'" .Action = 1 End With |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Incorrect Session Parameters, plz need ur help asap, im posting this msg again |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|