.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

Cannot access a SQL data base since a .net application usin ODBC and/or one by one instructions

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :Sql Server

At the time when we try to access a database the followin message is showed: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'Mid' is not a recognized function name.

I created an ODBC and when the database connection is tested there is no problem, the problem is when I try to access since the program.

View Complete Post

More Related Resource Links

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Microsoft Application Block for Data Access in .NET


Hi all,

I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET

It seems great of course. The articles are all early 2003-5 such as


So the question is - is this tech still relevant and should I be using it?



Data Access: Building a Desktop To-Do Application with NHibernate


Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.

Oren Eini

MSDN Magazine December 2009

Data Points: The Enterprise Library Data Access Application Block, Part 3


E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.

John Papa

MSDN Magazine October 2005

Data Points: The Enterprise Library Data Access Application Block, Part 2


Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).

John Papa

MSDN Magazine August 2005

Data Points: The Enterprise Library Data Access Application Block, Part 1


A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.

John Papa

MSDN Magazine July 2005

Using WCF unable to transfer bulk data in windows base application

Hi, I am testing bulk data transfer over WCF service and my project structure is as follows. Project Structure: 1> One Console application that have the WCF service reside of it. 2> One Class library that contain the interface and a class file that implement the interface. 3> Another Windows Application type project act as a client interface that call the service using proxy. Now the scenario I have is as follows: 1> Inside of the console application their is a module that have the (following server side code) .This service is hosted in the Console app programmatically (No config file). Server Code: Dim x As New NetTcpBinding(SecurityMode.None)         With x             .TransactionFlow = False             .TransferMode = TransferMode.Streamed             .MaxReceivedMessageSize = Integer.MaxValue             .CloseTimeout = New TimeSpan(0, 10000, 0)             .OpenTimeout = New TimeSpan(0, 10000, 0)             .ReceiveTimeout = New TimeSpan(0, 10000, 0)       &n

saving a text file in ms access data base

i have to read a text file in a text box then have to save it into ms access data base in column format how could i do this....

To Access Oracle Data Base


I have written two diffirent application using ASP.NET (used C# as server side scripting language in both applications) against Oracle Data base.

 In the first applicaton I am going to use Microsoft Library (System.Data.OracleClient) to access Oracle data base. 

In the second application I am using ODP.NET. The first application will call the second application with a link on a page then the second applicaton will get control. Both the application having there own web.config files.

By Now both of these applicaton are in the development phase. I want to deploy it on the same server machince.

My question is, is it possible for both of these application to co exists. Will there be any problem/conflict as am using System.Data.OracleClient in the first, where as uses ODP.NET in the second to access the same oracle data base.


How to open More then one lists of sharepoint 2010 as a tables in access 2010 data base


Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

Mohammad Siddiqali

Using Data View Web Part to access Documents in Separate Web Application


MOSS 2007 SP2
SharePoint Designer 2007

I am currently trying to display the contents of a document library within a separate site collection (different Web Application). The source document library is hosted on a Records Center on a Web Application with a name of records.example.com. The destination site (where the documents need to be displayed) is on a Web Application named teamsite.example.com

I am thinking web services is the way to go, but when I setup a connection to records.example.com/_vti_bin/Lists.asmx, I receive an error when trying to get the data:

The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again.

Any help will be greatly appreciated!

Cannot Import application Definition to Business Data Catalog (BDC) -- Error: Access Denied

I want to import an application definition to my Business Data Catalog (BDC).

I log into my Shared Service and select Import application definition.

I am redirected to page that says Error: Access Denied

My account is:

1. An Administrator on the windows server running sharepoint
2  A member of the Farm Administrators
3. Added individually with Full Control to Central Administation
4. Added individually with Full Control to my shared service.

John Bailo

Creating a Smartphone Application and Using Data from SQL Mobile

In this exercise, you will use Visual Studio 2005 to create a Smartphone application. You will associate commands with a mobile device's soft keys, and you will add the ability to scroll through the list of available products (a list of images). You will create a data source for an existing SQL Mobile database, and then test the application in the Windows Mobile 5.0 emulator.

In the following procedure, you will create a new Windows Mobile 5.0 project in Visual Studio.

data access library v4.1


Ive just started a project that will use the enterprise library 4.1 data access code blocks.  Its been years since ive used them, can anyone tell me what assemblies I need to reference in my project in order to use them ?  Ive referenced 


are there any others I need ?

Data Points: Deny Table Access to the Entity Framework Without Causing a Mutiny


Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.

Julie Lerman

MSDN Magazine August 2010

EF Data Access: EF v2 and Data Access Architecture Best Practices


Developers deploy a wide variety of development philosophies and architecture styles. This article explores three common perspectives on application development and describes how the Entity Framework can be employed in each. Specifically, the article looks at the forms-centric, model-centric, and code-centric development styles and their relationship to the Entity Framework.

Tim Mallalieu

MSDN Magazine August 2009

Under the Table: How Data Access Code Affects Database Performance


In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.

Bob Beauchemin

MSDN Magazine August 2009

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