Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: URGENT - Logon Failure-Database Vendor -30082 Post Reply Post New Topic
Author Message
aditya.cur
Newbie
Newbie
Avatar

Joined: 05 Feb 2008
Location: India
Online Status: Offline
Posts: 5
Quote aditya.cur Replybullet Topic: URGENT - Logon Failure-Database Vendor -30082
    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", "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
IP IP Logged
aditya.cur
Newbie
Newbie
Avatar

Joined: 05 Feb 2008
Location: India
Online Status: Offline
Posts: 5
Quote aditya.cur Replybullet Posted: 05 Feb 2008 at 10:27pm

Any body

Aadi
IP IP Logged
aditya.cur
Newbie
Newbie
Avatar

Joined: 05 Feb 2008
Location: India
Online Status: Offline
Posts: 5
Quote aditya.cur Replybullet Posted: 06 Feb 2008 at 7:41pm
Any one
Aadi
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
aditya.cur
Newbie
Newbie
Avatar

Joined: 05 Feb 2008
Location: India
Online Status: Offline
Posts: 5
Quote aditya.cur Replybullet 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
IP IP Logged
Seva
Newbie
Newbie
Avatar

Joined: 01 May 2008
Location: United States
Online Status: Offline
Posts: 10
Quote Seva Replybullet Posted: 08 Apr 2009 at 8:52am
Look a your DB2 ODBC driver.
Update it for the most recent one.
IP IP Logged
aditya.cur
Newbie
Newbie
Avatar

Joined: 05 Feb 2008
Location: India
Online Status: Offline
Posts: 5
Quote aditya.cur Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.