Click here to Skip to main content
15,849,829 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionregarding creating Help File for vb.net 2.0 windows application Pin
vijaylumar15-Apr-08 21:08
vijaylumar15-Apr-08 21:08 
AnswerRe: regarding creating Help File for vb.net 2.0 windows application Pin
Arjun Marwaha15-Apr-08 21:42
Arjun Marwaha15-Apr-08 21:42 
GeneralRe: regarding creating Help File for vb.net 2.0 windows application Pin
Smithers-Jones16-Apr-08 0:32
Smithers-Jones16-Apr-08 0:32 
GeneralCRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
vbDigger'z15-Apr-08 20:32
vbDigger'z15-Apr-08 20:32 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
_Damian S_15-Apr-08 20:59
professional_Damian S_15-Apr-08 20:59 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
vbDigger'z15-Apr-08 22:22
vbDigger'z15-Apr-08 22:22 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
_Damian S_16-Apr-08 19:07
professional_Damian S_16-Apr-08 19:07 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
vbDigger'z16-Apr-08 22:56
vbDigger'z16-Apr-08 22:56 
Are you sure the "Data Source" property isn't expecting the full path AND filename of your database?

eg: crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = "c:\databasepath\filename.mdb"

*********************

actually, not really...

i just made so many experimentation also base on other post from the internet..

i've also try this code
**************************
<br />
<br />
    Public crxApp As CRAXDRT.Application<br />
    Public crxReport As CRAXDRT.Report<br />
    Public crxDataBase As CRAXDRT.Database<br />
    Public crxTable As CRAXDRT.DatabaseTable<br />
    Public crxTables As CRAXDRT.DatabaseTables<br />
    Public crxConnectionProperty As CRAXDRT.ConnectionProperty<br />
<br />
    Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        Try<br />
<br />
            crxApp = New CRAXDRT.Application<br />
<br />
            crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault)<br />
<br />
            For Each crxTable In crxReport.Database.Tables<br />
<br />
                'STILL ERROR OCCURED HERE "Invalid Index" also to following crxTable.ConnectionProperties.Item<br />
<br />
                crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source")<br />
                crxConnectionProperty.Value = "D:\Folder1\Folder2\DatabseFolder"<br />
                crxConnectionProperty = crxTable.ConnectionProperties.Item("Initial Catalog")<br />
                crxConnectionProperty.Value = "myDataBase.mdb"<br />
                crxConnectionProperty = crxTable.ConnectionProperties.Item("User ID")<br />
                crxConnectionProperty.Value = "xxxxxxxxx"<br />
                crxConnectionProperty = crxTable.ConnectionProperties.Item("Password")<br />
                crxConnectionProperty.Value = "xxxxxxxxx"<br />
<br />
            Next crxTable<br />
<br />
            crxReport.Database.Verify()<br />
<br />
            crxReport.SQLQueryString = strSelectionfrm<br />
<br />
            AxCRViewer1.ReportSource = crxReport<br />
            AxCRViewer1.ViewReport()<br />
<br />
            crxDataBase = Nothing<br />
            crxTable = Nothing<br />
            crxTables = Nothing<br />
            crxReport = Nothing<br />
            crxApp = Nothing<br />
<br />
        Catch ex As Exception<br />
            MsgBox(ex.ToString())<br />
        Finally<br />
            Me.Cursor = Cursors.Default<br />
        End Try<br />
    End Sub<br />
<br />

*******************************
and still??? the same error...

and i've also try this code and still the same error.. Frown | :( Cry | :((
*******************************
<br />
crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source")<br />
crxConnectionProperty.Value = "D:\Folder1\Folder2\DatabseFolder\myDatabase.mdb<br />


or neither like this... still the same error... Frown | :(

<br />
crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source")<br />
crxConnectionProperty.Value = "D:\Folder1\Folder2\DatabseFolder"<br />

**************


this VS VB2005 and CR XI R2 is freaking me out and im very frustrated.... Cry | :((
please help... anybody... please... Frown | :(

thank you so much again to those who are formerly participating with this topic... thanks guys... a lot of appreciation to all of you...
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
Mycroft Holmes15-Apr-08 23:07
professionalMycroft Holmes15-Apr-08 23:07 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
vbDigger'z15-Apr-08 23:19
vbDigger'z15-Apr-08 23:19 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
ChandraRam16-Apr-08 0:56
ChandraRam16-Apr-08 0:56 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
vbDigger'z16-Apr-08 15:21
vbDigger'z16-Apr-08 15:21 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Pin
ChandraRam16-Apr-08 20:52
ChandraRam16-Apr-08 20:52 
GeneralRe: CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" [modified] Pin
vbDigger'z16-Apr-08 22:53
vbDigger'z16-Apr-08 22:53 
GeneralI think so i know whats wrong with my vb project... its not on the code but the versioning of active x component [modified] Pin
vbDigger'z17-Apr-08 19:04
vbDigger'z17-Apr-08 19:04 
Questionextract OLE Object from MS-Access Table using vb6 Pin
ERLN15-Apr-08 19:05
ERLN15-Apr-08 19:05 
GeneralRe: extract OLE Object from MS-Access Table using vb6 Pin
Dave Kreskowiak16-Apr-08 4:23
mveDave Kreskowiak16-Apr-08 4:23 
GeneralException has been thrown by the target of an invocation Pin
tom8315-Apr-08 18:56
tom8315-Apr-08 18:56 
GeneralRe: Exception has been thrown by the target of an invocation Pin
Arjun Marwaha15-Apr-08 21:50
Arjun Marwaha15-Apr-08 21:50 
GeneralRe: Exception has been thrown by the target of an invocation Pin
Mycroft Holmes15-Apr-08 23:11
professionalMycroft Holmes15-Apr-08 23:11 
GeneralRe: Exception has been thrown by the target of an invocation Pin
tom8316-Apr-08 4:01
tom8316-Apr-08 4:01 
QuestionSatellite Assemblies... Pin
kaizenIT15-Apr-08 11:15
kaizenIT15-Apr-08 11:15 
GeneralRe: Satellite Assemblies... Pin
Dave Kreskowiak16-Apr-08 4:16
mveDave Kreskowiak16-Apr-08 4:16 
Generaltabs in form Pin
asha_s15-Apr-08 10:23
asha_s15-Apr-08 10:23 
GeneralRe: tabs in form Pin
C1AllenS15-Apr-08 11:39
C1AllenS15-Apr-08 11:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.