According to ADO: ActiveX Data Objects, a book by Jason T. Roff, published by O’Reilly Media in 2001 (excellent diagram here), he says precisely what MOZILLA said. (directly from page 7 of that book) ODBC provides access only to relational databases OLE DB provides the following features Access to data regardless of its format or … Read more
Here is an example of how the parameterized queries work with CSharp, OleDB. try { connw.Open(); OleDbCommand command; command = new OleDbCommand( “Update Deliveries ” + “SET Deliveries.EmployeeID = ?, Deliveries.FIN = ?, Deliveries.TodaysOrders = ? , connw); command.Parameters.Add(new OleDbParameter(“@EMPID”, Convert.ToDecimal(empsplitIt[1]))); command.Parameters.Add(new OleDbParameter(“@FIN”, truckSplit[1].ToString())); command.Parameters.Add(new OleDbParameter(“@TodaysOrder”, “R”)); catchReturnedRows = command.ExecuteNonQuery();//Commit connw.Close(); } catch (OleDbException exception) … Read more
This worked for me using (OleDbConnection conn = new OleDbConnection()) { DataTable dt = new DataTable(); conn.ConnectionString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + path + “;Extended Properties=”Excel 12.0 Xml;HDR=YES;IMEX=1;MAXSCANROWS=0″”; using (OleDbCommand comm = new OleDbCommand()) { comm.CommandText = “Select * from [” + sheetName + “$]”; comm.Connection = conn; using (OleDbDataAdapter da = new OleDbDataAdapter()) { da.SelectCommand … Read more
The Problem is that OleDb (and Odbc too) does not support named parameters. It only supports what’s called positional parameters. In other words: The name you give a parameter when adding it to the commands parameters list does not matter. It’s only used internally by the OleDbCommand class so it can distinguish and reference the … Read more
I found a solution for this problem. The issue I described in my question occured basically due to the incompatibility of the Microsoft.Jet.OLEDB.4.0 driver in 64 bit OS. So if we are using Microsoft.Jet.OLEDB.4.0 driver in a 64 bit server, we have to force our application to build in in 32 bit mode (This is … Read more
Can you not just loop through the sheets from 0 to Count of names -1? that way you should get them in the correct order. Edit I noticed through the comments that there are a lot of concerns about using the Interop classes to retrieve the sheet names. Therefore here is an example using OLEDB … Read more
According to http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.parameters.aspx OleDbCommand does not support named parameter The OLE DB .NET Provider does not support named parameters for passing parameters to an SQL statement or a stored procedure called by an OleDbCommand when CommandType is set to Text. In this case, the question mark (?) placeholder must be used. For example: SELECT * … Read more
Basically, if you’re on a 64-bit machine, IIS 7 is not (by default) serving 32-bit apps, which the database engine operates on. So here is exactly what you do: 1) ensure that the 2007 database engine is installed, this can be downloaded at: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en 2) open IIS7 manager, and open the Application Pools area. On … Read more