Data Connectivity: URGENT - Logon Failure-Database Vendor -30082

Print Page | Close Window

URGENT - Logon Failure-Database Vendor -30082

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2237
Printed Date: 29 Apr 2024 at 5:16am

Topic: URGENT - Logon Failure-Database Vendor -30082

Posted By: aditya.cur
Subject: URGENT - Logon Failure-Database Vendor -30082
Date Posted: 05 Feb 2008 at 10:26pm

I am having a report(Crystal 10) with 7 sub reports and its working fine with Crystal Design mode, but if run this report from VB6.0 it is showing Logon Failure Error Database Vendor Code -30082. I Have DB2 Database as Backend. I think problem is with my code i.e.

Dim Crystal As CRAXDRT.Application
    Dim Report As CRAXDRT.Report
    Dim RECORD_SELECTION_FORMULA As String
    CRViewer1.DisplayBorder = True
    CRViewer1.DisplayTabs = True
    Dim strProductOption As String
    Dim StrItemFrom As String
    Dim StrItemTo As String
    Me.MousePointer = fmMousePointerHourGlass
    CRViewer1.EnableDrillDown = False
    CRViewer1.EnableRefreshButton = False
    CRViewer1.EnableProgressControl = True
    Set Crystal = New CRAXDRT.Application
    If UserForm1.radioAll.Value = True Then
        strProductOption = "All"
    ElseIf UserForm1.radioAssembly.Value = True Then
        strProductOption = "Assembly"
    Else
        strProductOption = "Spares"
    End If
Set Report = Crystal.OpenReport("C:\Documents and Settings\adityas.WMICOMBLR.000\Desktop\Heijunka\Heijunka Plan.rpt")
Report.Database.LogOnServer "P2SODBC.dll", "DBLIVE", "DBLIVE", "Db2admin", " mailto:Db@accpac - Db2admin "
    Report.DiscardSavedData
    ' Disabling The Parameter Prompting
    Report.EnableParameterPrompting = False
    Report.ParameterFields(1).AddCurrentValue Val((Format(UserForm1.dtpPlanStartDate.Value, "YYYYMMDD")))
    Report.ParameterFields(2).AddCurrentValue Val((Format(UserForm1.dtpPlanEndDate.Value, "YYYYMMDD")))
    Report.ParameterFields(3).AddCurrentValue strProductOption
    CRViewer1.ReportSource = Report
    CRViewer1.ViewReport

Any body with Suggestion or Solutions Please

-------------
Aadi

Replies:

Posted By: aditya.cur
Date Posted: 05 Feb 2008 at 10:27pm

Any body

-------------
Aadi

Posted By: aditya.cur
Date Posted: 06 Feb 2008 at 7:41pm

Any one

-------------
Aadi

Posted By: BrianBischof
Date Posted: 06 Feb 2008 at 10:47pm

Unfortunately, I don't know VB6 and this forum is primarily for .NET programmers. I doubt if anyone knows how to solve your problem. Sorry.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: aditya.cur
Date Posted: 30 Mar 2009 at 11:17pm

Ok tell me about vb.net code. As i am getting the same error in VB.Net also.
The report file which i am trying to open was created in Crystal Report 8.5 Version. Then it was upgraded to Crystal Report XI by opening and saving it in Crystal XI.

Please tell me the solution if you have/ Or is there any other way to solve this issue.

Tell me can i downgrade Crystal report file to Crystal 8.5. If yes then HOW???

-------------
Aadi

Posted By: Seva
Date Posted: 08 Apr 2009 at 8:52am

Look a your DB2 ODBC driver.

Update it for the most recent one.

Posted By: aditya.cur
Date Posted: 08 Apr 2009 at 9:08pm

Hi seva. I am using DB2 database for this report.
I have checked my ODBC driver also. it is the latest one......

-------------
Aadi

Print Page | Close Window