Re: Can you use the OleDb classes for SQL Server?
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxx>
- Date: Thu, 5 Jul 2007 08:43:08 -0700
I have yet to see this work without a lot of compromises. While OLE DB or
ODBC can obfuscate the backend, the code you write to execute and manage the
queries and the structures they return are very different for different
providers. Again, a layered data object approach seems to be a better way to
deal with this issue.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Gustaf" <gustafl@xxxxxxxxxx> wrote in message
news:uiG0$PvvHHA.484@xxxxxxxxxxxxxxxxxxxxxxx
I'm in a situation where the customer has an Oracle DB, and my developing
platform runs a SQL Server DB. Ideally, I'd like to write the code, and
then simply change the connection string at deployment time. So my
question is: can I use the OleDb classes rather than the native SqlClient
classes, to connect to SQL Server, and then later to Oracle?
Gustaf
.
- References:
- Can you use the OleDb classes for SQL Server?
- From: Gustaf
- Can you use the OleDb classes for SQL Server?
- Prev by Date: RE: Can't modify DataRow during RowChanged event
- Next by Date: Re: Debugging SqlCommand
- Previous by thread: Can you use the OleDb classes for SQL Server?
- Next by thread: Re: Can you use the OleDb classes for SQL Server?
- Index(es):
Relevant Pages
|
