[got a bit further so its updated] Hello There, i really hope you are able to help me! Now the first part of my code does work, and I do get my report numbers out in my combobox, and i'm able to write that number to a lbl. now I need to take that number and get the rest of my data from my Access 2003 database, and drop them in a strin...
Hi Guys, Im trying to extract rows from excel using Oledb. For some excel files from certain people is throwing error while trying to open the connection. The error says "External table is not in the expected format." Here is my connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.xls;Extended Properties="Excel 8.0;H...
After several hours (~6 hours Win7 64bit, ~24hours WinXP) of running multi-threaded (.NET Framework 3.5 SP1 WinForms) desktop application using .mdb files as backend I'm getting the following runtime error: Exception -> Unspecified error StackTrace -> at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionS...
Hi all, I implementing OLE DB provider for my custom database. It will be used from ADO applications. Now i have ADO example which creates ADO connection then close it with Connection.Close method but not release interface pointer of connection object. After that sample application creates another connection object and fails to open it b...
I am trying to use Microsoft.Jet.OLEDB driver to connect to an access database from my C# application. When I try to open a connection, I get an error: "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." This is because the driver is only supported on 32 bit machines. My solution was to change the platform t...
My tab-delimited file is something like this: ISO ISO3 ISO-Numeric AD AND 20 I've been trying the following code with no luck. OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= |DataDirectory|;Extended Properties='text;HDR=Yes;FMT=TabDelimited'"); OleDbCommand cmd = new Ole...