Re: OLE DB 2.8 & SQL 2005
- From: "Bob Beauchemin" <bobb_no_spam@xxxxxxxxxxxxx>
- Date: Tue, 6 Jun 2006 11:04:03 -0700
If you're not using the new features (like MARS, Query Notifications,
Failover Partner, etc) SQLOLEDB is just fine. There's a bit of difference in
handling of XML and MAX data types, but these are new too.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"StevenBr" <sbras@xxxxxxxxxxxxxxxx> wrote in message
news:52404C9C-1AE1-4EC2-B7EC-E1420293ABF9@xxxxxxxxxxxxxxxx
Do I need the new Native Client, or can I use the 2.8 sp1 OLE DB provider
for
SQL Server to connect to SQL 2005? I have read that certain new features
won't be available, but we have not used any in our existing application.
We'd prefer not to upgrade the drivers on all client PCs if we can be
reasonably sure our existing apps won't break with MDAC 2.8 sp1 and SQL
2005.
Thanks.
--
Steven Bras
Tessitura Network, Inc.
.
- Prev by Date: MTA with thread pool API
- Next by Date: Re: MTA with thread pool API
- Previous by thread: MTA with thread pool API
- Next by thread: 'Microsoft.JET.OLEDB.4.0' provider is not registered on the local machine
- Index(es):
Relevant Pages
|
