Avatar of bsc-elearning
bsc-elearning asked on

Crystal Report 8.5 report connected to MS SQL Server 2005

I am using ActiveX Crystal Viewer to display a crystal reports 8.5. ASP code seems to connnect to SQL Server 2005 but when report object is genereated, the report is blank.
Microsoft SQL Server 2005Crystal Reports

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
Mike McCracken

Does the repor work from the Crystal designer?

Is this on the client or the development machine?

mlmcc
MariaHalt

Sorry mlmcc, I didn't post this question...I'm home on maternity leave!!!  I'm going to have it removed.
ASKER
bsc-elearning

Yes, the report works on the Crystal Designer, when I use the Preview feature. I have run the ASP pages from my PC as well as other PC's. We have been using the same ASP for our other reports. The only different now is that we are connecting to an MS SQL 2005 database.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Mike McCracken

What code are you using to connect?

What database driver are you using?

mlmcc
ASKER
bsc-elearning

I am using the Open Report Method I got from Crystal samples. I set the session("oRpt").Database.Tables.SetLoogonInfo to "{SQLServer}\{instance}", "{Database name}", "{Login}", "{password}". When I echo the Name, Location, LogOnDatabaseName,LogOnServerName, LogOnUserID, and TestConnectivity values they return the correct expected values. Should I be using a different method for MS SQL 2005?

in the Crystal Designer I connect using the OLE DB.
Mike McCracken

Is this on your machine?

mlmcc

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
bsc-elearning

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mike McCracken

Any error messages?

Any errors in the error logs?

Did you include the OLE dlls?

mlmcc