Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old February 28th, 2005, 09:59 PM
Liz178 Liz178 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 3 Liz178 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 34 m 9 sec
Reputation Power: 0
Unhappy Incorrect Session Parameters, plz need ur help asap, im posting this msg again

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?

Reply With Quote
  #2  
Old February 28th, 2005, 10:51 PM
werD's Avatar
werD werD is offline
Certified Abuser
ASP Free Beginner (1000 - 1499 posts)
 
Join Date: Jan 2005
Location: Line 73 ---^
Posts: 1,046 werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)werD User rank is First Lieutenant (10000 - 20000 Reputation Level)  Folding Points: 20652 Folding Title: Starter FolderFolding Points: 20652 Folding Title: Starter Folder
Time spent in forums: 1 Week 4 Days 20 h 37 m 12 sec
Reputation Power: 127
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
Comments on this post
Liz178 disagrees!

Reply With Quote
  #3  
Old March 1st, 2005, 12:03 AM
sbaxter sbaxter is offline
Moderator: Access, SQL
ASP Free God (5000 - 5499 posts)
 
Join Date: Oct 2003
Posts: 5,126 sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
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-
Comments on this post
Liz178 disagrees!
__________________
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.

Reply With Quote
  #4  
Old March 1st, 2005, 03:49 AM
Liz178 Liz178 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 3 Liz178 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 34 m 9 sec
Reputation Power: 0
Post the script

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

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Incorrect Session Parameters, plz need ur help asap, im posting this msg again


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway