OLEDB connection to Access database using DSN

Question

Hai

i want oledb connection using Dsn. I used the following code

'Dsn Create
 dbRegBase.RegisterDatabase("GEMINI", "Microsoft Access Driver (*.mdb)", True,DBQ=D:\Gemini\GEMINI\database\paints_01_2008-2009.mdb
Description=Greenchip Technologies ODBC Database File Path
OemToAnsi=No
UID=admin
PWD=XXXXXX

conection code
Provider=Microsoft.Jet.OLEDB.4.0;DBQ ='GEMINI';Persist Security Info=False;Jet OleDB:Database Password = XXXXXX

But Error come error name is "Could not find installable ISAM" what i do . please tell me.

Answer 1

Does it need to be an OleDB connection?

I tried using OleDB in my most recent application and failed miserably but managed using and OdbcConnection and DSN.

String query = "SELECT * FROM myTable"; //Complete this for your specific query
OdbcConnection con = new OdbcConnection("DSN=DatabaseName");
OdbcCommand com = new OdbcCommand("Query...", con);
try
{
    con.Open();
    OdbcReader reader = com.ExecuteReader();

    while(reader.Read())
    {
        //Do things with the results
    }
}
catch(Exception ex)
{
    //Exception handling
}

A lot friendlier than using OleDB I think.

Answer 2

My question is why would anyone want to use odbc? There are many sites out there that show the speed improvements of oledb vs odbc. Also, odbc has not been updated in a while and is very buggy.