Hi, How do I program against Access 2007 in C#? I don't see any VSTO templates for it. All I need to do is define a schema, let the user fill in the data on their own, and then read all of the data they entered back into my program. The reading part looks easy...how would I programmatically create a MS Access Database, and how would I...
I'm using OleDb to interact with an Access database, and I'm trying to find out how to get the primary keys of each table, but in such a way that they are associated with the tables. In other words, I don't just want a flat list of the primary key column names--I want to be able to determine which table they belong to. Any idea how to d...
Anyone know of a free/open source OLEDB/ODBC/JDBC driver against DataEase? ...
We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a temporary .txt file using a schema.ini. (I'm not sure yet exactly why are are writing to this temporary file, but that's how the code currently works). From there, we are loading a DataTable via OleDB using the following connection string (for ASCII...
I have a c# application which reads excel files using oledb drivers. I would like to know is it possible read excel file in blocks so that we can avoid loading entire file into memory. ...
I'm trying to connect to a database using OleDbConnection and a connection string, the error given within the try-catch statement is 'database/user/password is too large'. What does that statement mean, and how can I solve this problem so I can connect to my database? My database is using a SQLBase driver. ...
In the past I had the indexing service installed on a Windows Server 2003 and used it to index files for my website. I did this by executing an OleDbCommand with a query and a connection string. How do I accomplish the same thing with the new "Windows Search Service" (Windows Server 2008) by using VB.NET? Does this work the same way so ...
How can I pass a null parameter to a SQL server query. I have a simple table with a nullable int column. If I pass a .NET null value, I get a sql error. If I pass DBNull.Value, no row matches the filter. Is there a simple way to do this without using ISNULL. OleDbConnection connection = new OleDbConnection(); connection.Connecti...
Okay here is the scenario I have a VB6 application that is getting re-written for asp.net 3.5. I have a grundle of Crystal Reports that are getting updated to Crystal Reports 10.5 (which is included in Visual Studio 2008). All of the old reports used OLEDB. What I am doing is taking the sql statements used in the reports and putting t...
Can I use PHP with Oledb connection? As far as I know database connection as provided by PHP extension are all odbc. ...
In .net, is there a standard library that should be used to read in csv files? All the samples on the web roll their own csv reader / parser, or use OleDb. It's not a problem using any of these solutions, I was just wondering if there is a generally accepted library (not that I can find), or any other "proper" way to do it? ...
So the main program is in C#. Inserting new records into a VFP database table. It was taking too long to generate the next ID for the record via select max(id)+1 from table , so I put that code into a compile dll in VFP and am calling that COM object through C#. The COM object returns the new ID in about 250ms. I then just do an ...
Greets, When working with DirectX, you get this nice header to #include called DxErr9.h which has really helpful functions like: DXGetErrorString9 and DXGetErrorDescription9 They tell you everything you need to know about the error given the HR. But now working with COM and OLE, I find I'm kind of on my own with the HRESULTS th...
In this OLE DB msdn example, (yes, it is dated 1997, but still works :)) I'm wondering what the historic point of OLE DB was if you still apparently wrote SQL to interact with the underlying datasource. The one thing I'm thinking is if the ICommandText was not executed directly on the database, but instead somehow interpretted by OLE DB...
I'm running an insert statement using OLE DB and an ICommandWithParameters. In the ICommandText, I made sure to set: params.cParamSets = n ; Then cmdTxt->Execute( NULL, IID_NULL, Where n > 1, but in my database, all I see is 1 insert happening. The docs say cParamSets is greater than one) can be specified only if DBPROP_MULTIP...
I want my application to be able to work with multiple db vendors. In other words, depending on the DB infrastructure of the client, the db schema will be deployed on one of Oracle, MySQL, SQL Server. I am between using ODBC and OleDB, and the following key requirements that must be taken into account for the selection: the DB schema m...
Hello! I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, uptime is very important) and writes to error log if anything funny happens (like a timeout or lost connection). This works great, however once in a while I will get this error: Arithmetic operation resulted in ...
I get the following error: The 'Miccrosoft.Jet.OLEDB.4.0' provider is not registered on the local machine When I run this code: string dbConn = @"Provider=Miccrosoft.Jet.OLEDB.4.0;Data Source=C:\structuredfunds.mdb"; string cmdText = "select * from StructuredFundPosition"; DataTable dt = new DataTable(); using (OleDbDataAdapter da = n...
I'm using OleDb to select data from excel spreadsheets. Each spreadsheet can contain many small tables, and possibly furniture like titles and labels. So it might look like this, where we have two tables and some titles; A B C D 1 . . . . 2 . . ...
Hi all I'm working on a VB2008 project that references two Access databases using Provider=Microsoft.Jet.OLEDB.4.0; It would seem if the user does not have MSOffice on their machine, the program crashes with a "XXX stopped working" on startup on Vista and Win7. I thought that Windows had XP and above had Jet functionality built in? Do...