Re: Choosing at Database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: MadCrazyNewbie (test_at_nospam.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 18:44:48 +0100

Hey i`ve found this but im so confused, i ain`t got a clue what it means, is
this what I should be looking into?

http://support.businessobjects.com/library/kbase/articles/c2011464.asp

Any help would be much appriciated

Thanks
MCN

"MadCrazyNewbie" <test@nospam.com> wrote in message
news:RDGdnbX9vK1YAL3cSa8jmA@karoo.co.uk...
> Hey Group,
>
> Sorry to be a pain yet again. I problem that i don`t know how to get
> around:(
>
> I use the following connection class on my project:
>
> Private Shared mConnectionsstring As String =
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> Private Shared mLocation As String
> Private Shared connArray As ArrayList
> Public Shared Sub setString(ByVal ind As Integer)
> Dim connArray As New ArrayList()
> connArray.Add("J:\Excellence.Net\LiveNetDB.mdb")
> connArray.Add("J:\Excellence.Net\DevNetDB.mdb")
> connArray.Add("C:\Program Files\Excellence.Net\LiveLocalDB.mdb")
> mLocation = connArray(ind).ToString
> End Sub
> Public Shared ReadOnly Property [String]() As String
> Get
> Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mLocation &
";"
> End Get
> End Property
>
> and then I use:
> Connection.setString(Me.cboSelectDB.SelectedIndex) on my Login form and
> <WhateverDataConnect>.ConnectionString = Connection.String
> on the load event of every other form.
>
> And the following to print my Crystal Reports:
>
> rptForm.Text = "Excellence.Net - Fax Meter Reading Report" 'Set the form's
> titlebar
> rptForm.CRVReportPrint.ReportSource = New FaxMeterReadings() 'Tell the
> viewer which report to display
> rptForm.CRVReportPrint.RefreshReport() 'Refresh the viewer
> rptForm.ShowDialog() 'Show the report
>
> How do I get my report Print to determin which database it using? I.E -
> Network or Local? All I can find on my Crystal report is the Set Location,
> to which I have to choose a databse.
>
> Many Thanks again for any help
>
> Regards
> MCN
>
>

Quantcast