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,057 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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