Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » OleDb   (RSS)
Friday, February 06, 2009 2:49 PM

Getting "Query is too complex" or "Expression is too complex” when using Access

The scenario, you have an MS Access database and you want to run queries against it. A fairly common thing to want to do J However, now you are getting the following exception, assuming you are running a .Net application: System.Data.OleDb.OleDbException:
Posted by maspeng | 0 Comments
Filed under: ,
Monday, December 08, 2008 10:00 AM

The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10

Imagine this; you have been looking at the new data type DateTime2 in Sql Server 2008 because you have a need for the increased precision this data type offers. Comparison here: "SQL Server 2008 Books Online (October 2008) - datetime2 (Transact-SQL)"
Posted by maspeng | 1 Comments
Friday, November 14, 2008 3:08 PM

Connectionstrings, mixing usernames and windows authentication. Who goes first?

When connecting to Sql Server from .Net, there are three namespaces containing classes to do so: System.Data.SqlClient / System.Data.OleDb / System.Data.Odbc The one should use is System.Data.SqlClient since this contains functions specific to Sql Server,
Posted by maspeng | 1 Comments
Filed under: , , ,
Wednesday, October 29, 2008 4:11 PM

How to update an Excel worksheet using DataSet and the OleDbDataAdapter

One very convenient thing in ADO.Net is the DataAdapters. These give you an easy way to fill DataTables and DataSets, and also to update the backing data source with very little effort. However, in order to be able to do INSERT/UPDATE/DELETE you have
Posted by maspeng | 0 Comments
Filed under:
Wednesday, July 23, 2008 10:20 AM

OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

The scenario: You want to use a linked server (directly or indirectly) in SQL Server using the OleDb provider. With this provider you wish to use, for example, the OPENROWSET query against a file of some sort, *.txt, *.csv, *.xls, etc. The problem: You
Posted by maspeng | 5 Comments
Filed under: ,
Thursday, July 17, 2008 3:18 PM

{"Syntax error in FROM clause."} when using text based datasources

This is also one of the issues that I have seen a few times. What happens here is that customer uses *.csv or *.xls or any text file as a data source and connects to it using .Net and OleDb. The error reported from the framework when issuing a SELECT
Posted by maspeng | 0 Comments
Filed under: ,
 
Page view tracker