Could not find installable ISAM ???

[JNic]

MSDN is not the best in explaining that type of error. I keep getting this. I looked if my Jet engines was installed correctly and everything looks fine in my registry.

May be I am doing something wrong in my code ?


public const string DB_CONN_STRING =
@"Provider=Microsoft.Jet.OLEDB.4.0;" +
@" DataSource=D:\\Documents\\Visual Studio 2005\\Projects\\WindowsApplication2\\db_RFID_OIC.mdb";


public void InsertDBLogTag()
{

OleDbConnection conn = new OleDbConnection(DB_CONN_STRING);
conn.Open();

// SQL command
String sSQLCommand =
"INSERT INTO LogTag (Date, Puce, Cle_bureau, Cle_couloir, Cle_cargaison, Poids, Poste) " +
"VALUES( '2001/12/25 20:30:15', '55', 1, 3, 2, 134, 1 );";

// Create the command object
OleDbCommand cmdAdder = new OleDbCommand(sSQLCommand, conn);

// Execute the SQL command
int nNoAdded = cmdAdder.ExecuteNonQuery();

// Close the connection
conn.Close();


}



The errors is when I open the connection (in the beginning), so I am wondering if my connection string is ok.

thank you for helping me

[dglienna]

Check out this link:

http://www.codeproject.com/KB/database/adonetp1.aspx

[JNic]

Check out this link:

http://www.codeproject.com/KB/database/adonetp1.aspx
This article doesn't talk about my type of error and it's a beta network version, so it doesn,t work with what I am using :(

[superuser]

try separating DataSource into two words like Data Source.

[JNic]

try separating DataSource into two words like Data Source.
Thank You very much !

Now it's work :)

I have an error in my insert command, but I will figure it out. I belive my sql command error comes from the fact that I have a "auto increment" field as my primary on my table and I tought access would automaticly add it, looks like not. I will have to figure it out.

Thank You !