embedded database connection string

Question

I got two problems: First, i'm trying to connect my windows form app with my embedded database (.dbf) and i keep getting this message no matter what i do to the connection string: "error isam instalable cant be found"

Second, i would like to make the path relative to the executable.

Thanks, here is the code i'm using to test the whole thing:

    private void bGuardar_Click(object sender, EventArgs e)
    {
        try
        {
        string cadena = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =D:\\; Extended Properties = dBASE IV; UserID =; Password =;";
        OleDbConnection con = new OleDbConnection();
        con.ConnectionString = cadena;
        con.Open();
        MessageBox.Show("conected");
        con.Close();
        }
        catch (OleDbException exp)
        {
            MessageBox.Show("Error: " + exp.Message); 
        }


    }

Well my system is 64-bit but im not sure how to see if my app is running at 32 or 64. And thanks for the link but i allready saw it and it was not clear enough for me, sorry im still learning. — Fabrizio Bruzzese
– Fabrizio Bruzzese, Commented Jul 17, 2016 at 0:53

Community · Accepted Answer · 2017-05-23 11:51:29Z

1

For the second part, you can get the path of your executable using System.IO.Path.GetDirectory(Application.ExecutablePath). There are more ways do this based upon your need (see Best way to get application folder path).

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Jul 17, 2016 at 0:48

Vijay

5113 gold badges5 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fabrizio Bruzzese Over a year ago

string app = Path.GetDirectoryName(Application.ExecutablePath); string cadena = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="+app+"; Extended Properties = dBASE IV; UserID =; Password =;"; I'm trying this now but i does not work also if i use GetDirectory instead of GetDirectoryName it gives me an error. Thanks for the answer tho

PawelSz · Accepted Answer · 2016-07-17 01:50:09Z

0

To avoid further difficulties instead of 'OleDbConnection con = new OleDbConnection();' try

using (OleDbConnection con = new OleDbConnection())
{
    ; // your command and executes here
}

this way you call the dispose / close method always (using generally wraps up your code so that the part between { and } is wrapped in a try / catch block with finally that calls a dispose() / close() on the OleDbConn object.

answered Jul 17, 2016 at 1:50

PawelSz

1646 bronze badges

Collectives™ on Stack Overflow

embedded database connection string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related