|
Posted by Erland Sommarskog on 12/03/07 22:39
(jags_32@yahoo.com) writes:
> Could you clarify on "MSDASQL, OLE DB over ODBC"? What is MSDASQL, OLE
> DB?
OLE DB is an general API for communicating with databases that is COM-based.
It appeared on the scene around 1998, and for a while this was the top of
the pops. However, it never became the smashing success that Microsoft
intended.
The main difference between OLE DB and ODBC as general APIs is that ODBC
assumes that the data source is relational, OLE DB does not. So you
can use OLE DB to access text files or Active Directory. However, OLE DB
is a more complex API, and applications which uses the OLE DB API directly,
are likely to become very verbose.
Now, most applications that uses OLE DB, use some other high-level API,
like ADO. Or OleDB Client in .Net.
For a data source like SQL Server, OLE DB is very much alive. But for
many smaller data sources, no one ever came around to implement an
OLE DB provider, and apparently there is not one for Double Byte Progress
that you use.
However, the first OLE DB provider that saw the light of day was MSDASQL,
which implements the OLE DB API on top of ODBC. Which means that everyhing
that has an ODBC driver still can be accessed from OLE DB. Maybe not
optimally, but it can be accessed.
Currently you use OdbcClient in .Net and you have problems with it.
I'm not going to promise that MSDASQL will fare any better, but I think
you should give it a try. I've tried using OdbcClient with SQL Server
and that did not work well.
So in your SSIS package, try replacing the DataReader source with an
OLE DB Source, and, oops! As I actually looked into BIDS and found
my way to the Connection Manager, I find that MSDASQL is not listed.
Drat! There goes my theory.
That was quite a long reply for nothing.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|