Hendra
I use the old SQL Server provider. I found out the hard way that there is a bug in Access or maybe it's in the Native client. varchar(max) columns get strangely truncated in linked tables. The old provider does not have that problem.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <agesthahendra@ymail.com> wrote :
Hi everyone... :)
I'm learning about "driver & provider" to Sql Server, my question is : assumed that we don't need to use new feature of Sql server 2005/2008, is there bennefits to use the latest driver or provider? especially for performance factor, i have read many articles but didn't find the explicit statement about performance factor in using...for example Sql Server Native Client 11.0 OLEDB Provider or Sql Server Native Client 11.0 ODBC Driver (or SNAC in general)... i always use "the old" sql server driver.
any directions would be appreciated...thank you very much.
Regards
Hendra Agestha
I'm learning about "driver & provider" to Sql Server, my question is : assumed that we don't need to use new feature of Sql server 2005/2008, is there bennefits to use the latest driver or provider? especially for performance factor, i have read many articles but didn't find the explicit statement about performance factor in using...for example Sql Server Native Client 11.0 OLEDB Provider or Sql Server Native Client 11.0 ODBC Driver (or SNAC in general)... i always use "the old" sql server driver.
any directions would be appreciated...thank you very much.
Regards
Hendra Agestha
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar