OLEDB v/s ODBC
What is the difference between OLEDB and ODBC? When do I use which and how do I know what I am looking at is a OLEDB driver v/s an ODBC driver? ...
oledb
OLEDB Driver Bit?
How do I find if the Oracle drivers installed on a system (64 bit Windows 2003 Server) are 32 bit or 64 bit? And how do I even know if they are installed? Is there a particular location where I can check it? PS - I saw the Q here, but is there an easier way? ...
Persuade Access 2007 to use a .UDL file/oledb connection?
Is there any way of coaxing Access 2007 into using a .UDL file? Specifically, one of our older products uses an Interbase 6.0 database. My client would like to link to his database, for read/write, using Access 2007 (in the short term). While this isn't my preferred way of doing things at all, given it's all single-user and the other ...
Reading Excel in .NET, how to get row number?
Hi, I have got this code to read an Excel file using C# .NET (from http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx) string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"...
How do I query raw data from a Proficy Historian?
How can I retrieve raw time-series data from a Proficy Historian/iHistorian? Ideally, I would ask for data for a particular tag between two dates. ...
Connect to Pick Database using Odbc C# .Net
How to Connect to PickBasic database using Ole db driver .. I need it badly help me out ...
Is there a difference in the underlying protocol for ODBC, OLEDB & ADO.NET
When communicating to a SQL Server database using one of the typical systems, ODBC, OLEDB or ADO.NET, is the underlying basic protocol the same? Are all the differences between these systems basically just client side issues? Is this all just different flavors of TDS (Tabular Data Stream) transfer? [MS-TDS]: Tabular Data Stream Protoc...
What is best way to read CSV data?
Hi Guys, I am using C# and trying to read a CSV by using this connection string; Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\rajesh.yadava\Desktop\orcad;Extended Properties="Text;HDR=YES;IMEX=1;FMT=Delimited" This works for tab delimited data. I want connection string which should for tab delimited as well...
Good OleDB/ODBC provider for PostgreSQL
Hi! I'm in need of a functional OleDB data provider for PostgreSQL. It should be similar to the ODBC provider for MySQL. See http://dev.mysql.com/downloads/connector/odbc/5.1.html ...
ITransactionLocal interface is not supported
I have a .NET 3.5 C# library that uses OleDb to pull data from an Excel file and return it in a DataRowCollection which is used by a CLR Table-Valued Function in SQL Server 2005. The function works fine when I use SELECT on it. But if I want to use its output as a source for an INSERT INTO a table, I get the following error: System.In...
Best RDBMS for use from VB6
We are embarking on a grand/huge project which will take us around 1 full year of coding (by 4 developers) to get off the launch pad. It is a complete Business Management System. We can use any commercially available RDBMS like Oracle, MS SQL Server, etc. but we are looking out to use freeware and open source RDBMS system like FireBird...
db connection pool across processes
We have a client/server application that consists of multiple EXEs. The data access layer is on the same physical tier as the client in a library shared by our EXE modules. ODBC and OleDB connection pools are managed per-process; are there techniques for sharing DB connections across processes (other than moving the data access layer to ...
UPDATE query works fine when run from Access, but raises SQL syntax error from within C# app
I have a very simple Update statement that will update mail server settings and network credentials info... Query works fine when I run it in Access but C# keeps giving me the error stating that my SQL Syntax is wrong ... I have a dataaccess layer (dal class) and Update instance method pasted belows ... But the problem must be sth else c...
How do I list all the queries in a MS Access file using OleDB in C#?
I have an Access 2003 file that contains 200 queries, and I want to print out their representation in SQL. I can use Design View to look at each query and cut and paste it to a file, but that's tedious. Also, I may have to do this again on other Access files, so I definitely want to write a program to do it. Where are queries stored an ...
Access 2007 - "Could not update; currently locked"
Hello. First sorry for my bad english but I'll try my best. Right now I'm programming a .net application using Access 2007 as datastore. In a nutshell: I have two threads. One thread inserts a row with a transaction into a table. The other thread updates many rows in constant intervals. Thread 1 Database db = _loggingDatabase; usin...
Generic Data Access functions
What is the best way to code the following generic data access functions (ADO.NET, C# or VB, SQLServer or OLEDB) Execute SQL on a connection Open a DataReader Open a DataSet (any ideas on this one?) Such that I can call these functions from anywhere in my program. I'm not interested in Data Access patterns or Data Access layers unle...
Accessing Excel 2007 Binary (.xlsb) via OleDb ACE
Hi Fellows, I found the Excel 2007 Binary format (with extension .xlsb) perfectly suitable for my needs, since it's fast to load and very compact. I deliver a bunch of reports in Excel that carries a lot of data, and those reports are actually being loaded with a IS package. So I assumed the conversion to this very format, read docu...
Does DDE still matter? Which are the alternatives?
I'm working on a stock exchange information platform and we are thinking in provide a link between our platform and home-made Excel files. The financial market is still bound to the old DDE server approach, now does it still matter today? Which are the alternatives to make automatic online data updates on Excel files, OLE DB queries? I ...
Querying Jet Databases/Excel files with C# under x64 OS
So I have learned that that the Microsoft.Jet.OLEDB.4.0 data provider for querying data sources like Microsoft Access MDB files and Excel spreadsheets does not work under a Windows 64-bit operating systems. What I am now supposed to use to query against these file types in .NET 3.5 (C#) applications in order to ensure compatibility in b...
How do I extract the data in a FoxPro memo field using .NET?
I'm writing a C# program to convert a FoxPro database to XML, and everything works except the memo field is blank. Is there something I'm missing to convert that bit? I'm using C# .Net 3.5 SP1, Visual FoxPro 9 SP 1 OLE DB Driver. Connection string is okay, as all other data is being pulled properly. When I converted the FoxPro database...