Browse by Tags

SQL Server 2005 or 2008: SQL Native Client or MDAC - which is best one to use?

Published 16 June 8 3:53 AM | SSQA.net

SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are...

Filed under: sql server, mdac, features, sqlnative, components, native client, editions

SQL Server does not exist or access denied

Published 13 August 7 5:10 AM | SSQA.net

I hope you will get to see the above error message most often and I say a common question among forums & newsgroups. Few times you might be thinking why it is throwing error even though you are using right credentials to access that SQL Server instance...

Filed under: sql server, security, server, mdac, client, access denied, exists, does not, network

Annoying x80040E21 & x80040E24 errors

Published 25 May 7 4:41 AM | SSQA.net

If you are performing a simple process to import a data using a DTS package in SQL 2000 or an SSIS package in SQL 2005, you might be very familiar with errors such as "x80040E21 & x80040E24". To put more in the sense of real error it will...

Filed under: data, ssis, error, jet, component, oledb, mdac, dts, odbc