Solved

Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'sa'. SQL State: 42000 Native Error:

Posted on 2006-11-24
5
12,016 Views
Last Modified: 2012-06-27
HI iam using crystal report in my web application iam usin Visual Studio 2005

when I run this report in my web page using crystal report viewer iam getting the above error

 CrystalReportViewer1.ReportSource = CrystalReportSource1
        CrystalReportViewer1.DataBind()

how to set the database logon user id and passwd in my web page

in 2003 i know oRpt.SetDatabaseLogon("sa", "password") your can do this

how about in 2005?

Thanks


0
Comment
Question by:farooksg
  • 2
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 18008085
Did you try that?  As far as I know htey didn't change the interface very much.

mlmcc
0
 

Author Comment

by:farooksg
ID: 18009995
yes I tried It gives syntax error and does not work
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18010190
What version of Crystal?

Is this a new application?

mlmcc
0
 

Accepted Solution

by:
farooksg earned 0 total points
ID: 18016130
hi

I found the solution


Thanks

 Dim li As TableLogOnInfo = New TableLogOnInfo()


            li.ConnectionInfo.ServerName = "servername"
            li.ConnectionInfo.UserID = "userid"
            li.ConnectionInfo.Password = "password"
            CrystalReportViewer1.ReportSource = CrystalReportSource1
            CrystalReportViewer1.LogOnInfo.Add(li)
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question