.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

MS Access ADP projects need to be able to use SQL Native Client

Posted By:      Posted Date: September 11, 2010    Points: 0   Category :Sql Server
Microsoft, PLEASE update the Access ADP platform to be able to connect to SQL Server 2005 using the SQL Native Client.  ADP is a great in-house development platform, but MS seems to have decided to stop supporting it.The problem is, the sql ole db driver that the ADP projects use, cause problems when querying complicated views or stored procedures on SQL Server 2005.  Queries that worked great under SQL Server 2000, time out under 2005.  When run directly on the server, there is no problem.  When they are run from the ADP file, the execution plan of the query is totally messed up.  I watched what SQL Server 2005 does with tracing, it's running certain segments of the query over and over.If I run that same query in Access, through an ADO connection, where I specify the Native Client as the provider, then I don't have that problem, which proves that the problem is the old SQL OLE DB driver. So we need the project's default connection needs to be work properly with SQL Server 2005.

View Complete Post

More Related Resource Links

SQL Server allowing access with NATIVE CLIENT Protocols are disabled.

I have disabled all client protocols from SQL Server Configuration Manager -> Sql Native Client configuration -> Client Protocols.Still I am able to access sql server with all client protocols disabled. Why ?Also I stopped the SQL Server Services and restarted it again. Then also the system is allowing me to connect with all the client protocol disabled.

ClickOnce: Deploy and Update Your Smart Client Projects Using a Central Server


ClickOnce is a new deployment technology that allows users to download and execute Windows-based client applications over the Web, a network share, or from a local disk. Users get the rich interactive and stateful experience of Windows Forms, but still have the ease of deployment and updates available to Web applications. ClickOnce applications can be run offline and support a variety of automatic and manual update scenarios.Learn all about it here.

Brian Noyes

MSDN Magazine May 2004

Return of the Rich Client: Code Access Security and Distribution Features in .NET Enhance Client-Sid


Rich clients employ many of the features and conveniences of the operating system they run on, and the list of these features has been growing since the dawn of the PC. But as apps have migrated to the Web, the trend towards increasing client-side functionality has ground to a virtual halt. There are several reasons for this; chief among them are security and deployment problems. But that's all about to change. With the .NET Framework, you can participate in building the distributable rich client of the future. In this article, the author enumerates the pertinent features of .NET that will allow you to build safe, easily deployable controls. The features discussed include managed code, code access security, versioning control, Windows Forms classes, and isolation.

Jason Clark

MSDN Magazine June 2002

SQL and Outlook: Enable Database Access and Updates Through Exchange and Any E-mail Client


Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002

Usage of Client Access Policy and crossdomain xml for sharepoint 2010>?


Hi Folks,

1.What is Clientaccesspolicy.xml in sharepoint ?

2.What is Crossdomain.xml ?

What is usage of wcf service deploy in sharepoint 2010?

Kindly give me some valuable comments ?


Thank you


Immanuel c


Sharepoint site client access denied


I have an sharepoint application which was working fine.

I encountered a license expired message in sql server enterprise evaluation 2008 version after which i changed the date to 2 months earlier date, I have also changed HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState to 3 after which sql server started working but the issue is that the clients are unable to access the sharepoint site completely. On providing the url the web site requests for logon information and then access is denied. The same url with the same authentication credentials is accessible from the server and the entire application works fine from the server. 

From the  client the below error page appears.

You are not authorized to view this page

You do not have permission to view this directory or page using the credentials that you supplied.

Please try the following:

  • Contact the Web site administrator if you believe you should be able to view this directory or page.
  • Click the Refresh button to try again with different credentials.

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)


Video: The Access Show: Client Performance Improvements against SharePoint Lists

Today's guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance. (Length: 13:05)

Install SQL Server2005 Error:[Native Client]Encryption not supported on the client

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

SSRS Client Access

Hi, I have evaluating SSRS, and somehow I am quite confused. Please tell me if I am wrong in the basic understanding. To create a new report by the user, the client has to be installed with the Report Builder software, and must have access to the database server directly? Is there no thin client, say a web page available to allow the users to create a report (choosing of fields) like that of the Report Builder Software? Please help to answer this fundamental questions. Thank you.

Where is SQL Native Client 10.5.xxxx for Visio 2010

When attempting to use Reverse Engineer tool in Visio 2010 Professional for the Database Model Diagram, selecting SQL Native Client as the data source provider only gives the ODBC SQL Server Native Client as 10.0 (SQL Server 2008). How do I use 10.5.xxxx to connect to a SQL Server 2008 R2 database. Obviously the 10.0.xxxx provider won't understand the newer data types available in 2008 R2.

Migration of DSN use for SQL Server access from Windows SP-3 clients to Windows 7 64 bit client

We have numerous apps which use a named DSN using SQLSRV32.dll for an ODBC connection from our Windows XP-Pro SP3 32 bit machines client access to remote windows 2003 based SQL servers (mix of 2005 and 2008).  On migrating to Windows 7, this dll will not allow the apps to use the newly constructed DSN (using SQLSRV32.dll with ODBC), even though a test connection is sucessful (abbeit much slower than seen on the XP-Pro machines).  What must I use on the Windows 7 64 bit machine to allow a DSN to be used by the migrated apps?  - I have descerned through Google that WDAC is now the tool to use, but I am cluless how to use it. - The expectations from the app on the Windows XP-Pro and on the Windows 7 64 bit machines is to use a DSN to connect to SQL servers on Windows 2003. I would appreciate any advice, and thanks!

SQL Server 2005 Express - Does it require a Client Access License (CAL)

Do you need a Client Access License (CAL) for each device that will connect to a SQL Server 2005 Express edition database?

Access database using client credentials

I have created a small wcf project that comprises the following  TZ_PI_Interface_WCF - This is a WCF service hosted in IIS  TZ_PI_Interface_Client - This is a test client The service is running in as much that my client communicates with it and executes code in the service. My client app executes the GetProcessData_GetSearch_Client_Detail of my service.  This method should go off to a database and return some data to the client. For the purposes of this test I am catching exceptions in the GetProcessData_GetSearch_Client_Detail method and returnind the error message as a piece of data. When the GetProcessData_GetSearch_Client_Detail is executed, a connection should be made the a database and data should be returned to the client The results I get depend on my connection string. These are the scenarios I am trying along with the results of executing GetProcessData_GetSearch_Client_Detail 1) Local DB Test using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user 'N075650\ASPNET' 2) Local DB Test using SQL Login  Data correctly returned 3) Remote DB using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user '(null)' 4) Remote DB using SQL Login  Data correctly returned In the live environment I will have the service hosted on an IIS server (6.0) and the

SQL Server Native Client is substitute of WDAC (MDAC)?

Forking this subquestion from my question Does SQL Server clients use (WDAC, MDAC) and when? Having read msdn article  SQL Server 2008 R2 Native Client Programming I could not understand: Is SQL Server Native Client (SSNC) intended to be used as advanced substitute for MDAC (currently renamed as WDAC)? what one could have understood from th? article... Except that this article tells: "The SQL Server Native Client ODBC driver is always used in conjunction with the ODBC Driver Manager supplied with Windows DAC" From one side it sounds that SQL Server Native Client (SSNC) provide the same functionalities that MDAC (WDAC) and more being "a stand-alone data access API,". From the other side, it is written that SSNC is dependent on MDAC(WDAC) components (drivers, dll) and vice versa. So, why 2 parallel, having essentially the same functionalities, data access structure duplicates?

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

Hi. I have connected my SSAS in SQL server 2008 to an Oracle database.  I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube.  Now everything was going fine.  I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But.  When I come to process the Cube it throws these errors.  Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.

SQL Server Native Client install fails during prerequisites

Hi I'm trying to install sharepoint 2010 on a new windows 2k8r2 which is a member server on our domain. The server is fully updated. The SQL Server native client installation fails. This is the entry in the error log;   2010-09-15 08:57:26 - Beginning download of Microsoft SQL Server 2008 Native Client 2010-09-15 08:57:26 - http://go.microsoft.com/fwlink/?LinkID=160387 2010-09-15 08:57:28 - Size of download of "Microsoft SQL Server 2008 Native Client" in bytes is "8073728" 2010-09-15 08:57:28 - Download of "Microsoft SQL Server 2008 Native Client" completed successfully 2010-09-15 08:57:28 - Installing Microsoft SQL Server 2008 Native Client 2010-09-15 08:57:28 - "C:\Windows\system32\msiexec.exe" /i "C:\Users\myadmin\AppData\Local\Temp\SQLCF11.tmp.msi" /quiet /norestart 2010-09-15 08:57:28 - Install process returned (0X660=1632) 2010-09-15 08:57:28 - [In HRESULT format] (0X80070660=-2147023264)   If I run the SQL native client installer manually I get the following error; The installer has encountered an unexpected error. The error code is 2755. Server returned unexpected error 1632 attempting to install package.   Any ideas why this is happening? I've had a quick google and can't see anything for SQL Native Client for that error code. Thanks   Olly

Should I move ODBC Apps from the SQL Server driviver to SQL Server Native Client 10.0

I have a suite of applications written for SQL Server 2000 in Access 2000 and Access 2007 and running under Access 2007 (12.0.6423,1000 SP2 MSO 12.0.6425.1000) via ODBC with the SQL Server ODBC driver (2000.85.1132.00) under Windows XP Professional (2002 SP3).  I have maintained all the data modules in Access 2000 format so that they can be accessed by SQL Server 2008 if required and am gradully upgrading the data modules to SQL Server.  The server they are connected to is Microsoft SQL Server Standard Edition (10.0.2531.0 running on a 32-bit Wndows Server 2008 Standard (SP2).  As a security improvement I intend to move a number of the applications to the server itself.  My choice of driver for ODBC is between SQL Server (6.00.6002.18005) and SQL Server Native Client 10.0 (2007.100.2531.00).  I have yet to discover any differences in application behavior or performance between the two interfaces My assumption is that I will have have fewer problems if I configure the ODBC links using the SQL Server driver.  However, I was wondering if there is a reason to gradually move them over to the SQL Server Native Client 10.0 driver. Thanks, Harry
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend