VB.net Connection String Pervasive.Data.SqlClient

Hi
I used the following code to pull data from a Pervasive database on my local machine.
I now want to load my app onto a Pastel users machine so they can view their Pastel
I assume that I just need the name of their Pastel Pervasive database.
Do I just replace the name in theconnection string or do I need to do more?

Imports System.Windows.Forms
Imports System.Data
Imports System.Data.Common
Imports Pervasive.Data.SqlClient

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim strConn As String = "server=LocalHost;database=Demodata"
        Dim objConn As New PsqlConnection(strConn)
        Dim objDS As New DataSet
        Dim daPeople As New PsqlDataAdapter("SELECT * FROM Person", objConn)

        ListView1.Clear()
        daPeople.Fill(objDS, "dtPeople")

        ListView1.View = System.Windows.Forms.View.Details
        ListView1.Columns.Add("ID", 85, HorizontalAlignment.Left)
        ListView1.Columns.Add("Last_Name", 65, HorizontalAlignment.Left)
        ListView1.Columns.Add("First_Name", 365, HorizontalAlignment.Left)

        For Each dr In objDS.Tables("dtPeople").Rows
            Dim str(3) As String
            Dim itm As ListViewItem
            str(0) = dr("ID").ToString
            str(1) = dr("Last_Name").ToString
            str(2) = RTrim(dr("First_Name").ToString)
            itm = New ListViewItem(str)
            ListView1.Items.Add(itm)
        Next

    End Sub

Open in new window

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fernando SotoRetiredCommented:
As long as the Table Person with the columns ID, Last_Name, and First_Name exist in the table then that should be all that is needed is a connection string pointing to your customers database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill BachPresident and Btrieve GuruCommented:
Yes -- just change the Servername to your correct server name (instead of Localhost) and make sure that the database name is correct.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.