Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loading Crystal Rpt in ASP

Status
Not open for further replies.
kcorrigan

kcorrigan

Programmer
May 30, 2002
50
US
I am tring to load a Crystal Report (8.5 Dev. version) in ASP (Visual Interdev 6)that pulls data from an Access (97)database. I have a system DSN ("MRF_DB") set as a Microsoft Access driver that has the database location set, and there is no password. Here is my code to set the database:

session("oRpt").Database.Tables.Item(1).SetLogonInfo "MRF_DB"
session("oRpt").Database.Tables.Item(2).SetLogonInfo "MRF_DB"

I have also tried setting the table names:

session("oRpt").Database.Tables.Item(1).SetLogonInfo "MRF_DB", "Table1"
session("oRpt").Database.Tables.Item(2).SetLogonInfo "MRF_DB", "Table2"


...But both ways will load the viewer, but I get an error saying the server has not been opened. Any Suggestions?!
 
Status
Not open for further replies.

Similar threads

XrayboX
  • Question
Dynamically pass Crystal Reports formula to a Stored procedure Parameter
Replies
0
Views
83
XrayboX
XrayboX
Sajeesh Aravind
  • Locked
  • Question
Smooth Line Cure is cutting in Y axis
Replies
1
Views
391
hilfy
hilfy
hg05
  • Locked
  • Question
Crystal Reports Left outer join and link type
Replies
1
Views
499
PeterDimitrov
PeterDimitrov
SAINI2020
  • Locked
  • Question
Crystal Reports 2008 and SharePoint
Replies
1
Views
404
hilfy
hilfy
DSenger
  • Locked
  • Question
Developing a Crystal Report in text format
Replies
8
Views
484
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top