CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

MS SQL 2008 on ASP.NET Hosting



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 3/27/2007 9:50:04 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 23 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
vijaypvb
Asp.Net User
Question in Data Access Component3/27/2007 9:50:04 PM

0/0

I am using Enterprise Library 2006 - Data Access Application block for console application. I have around 10 console applications created. I am not using App.config file for those console applications created. Also I am forced to build the connection string dynamically. Hence I didnt specify anything in the app.config file. I am using sqldatabase class for establishing the connection using the dynamically generated connection string as shown below:
dim db as new sqldatabase("server=something;UID=usrxyz;pwd=;database=something;")

Then I will be executing the sql statement by assigning it to the command object(dbCommand) as shown below:
Dim dtOutput as dataset = db.Executedataset(dbCommand)

In this way, I have achieved the following:
(a) eliminated app.config files for 10 console applications
(b) would be able to create the connection string dynamically and pass it to the sqldatabase class

Here is the question comes
What should I do if I have to establish the connection through system DSN? I am unable to establish the DSN connection "DSN=systemdsn;Uid=usrxyz;pwd=pwdxyz;" using the sqldatabase class. I believe the sqldatabase class is meant only for the sqlclient provider. Do you guys have any other suggestions??

Please note that I have not modified anything in Data Access component.

vijaypvb
Asp.Net User
Re: Question in Data Access Component6/22/2007 8:32:46 AM

0/0

DSN connection can be achieved only through odbc provider.

2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL Authors: Wallace B. McClure, Gregory A. Beamer, John J. Croft, John J. Croft, IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker, Pages: 614, Published: 2005
Advances in Web-age Information Management: 5th International Conference, WAIM 2004, Dalian, China, July 15-17, 2004 : Proceedings Authors: Qing Li, Guoren Wang, Ling Feng, Pages: 753, Published: 2004
Durability of Building Materials and Components 8: Service Life and Asset Management : Proceedings of the Eighth International Conference on Durability of Building Materials and Components, 8dbmc : Vancouver, Canada, May 30-June 3, 1999 Authors: Michael A. Lacasse, Michael A. Lacasse J. Vanier National Research Council Canada Staff, Dana J. Vanier, National Research Council Canada, Canadian Wood Council, Pages: 817, Published: 1999
Access Database Design and Programming Authors: Steven Roman, Pages: 448, Published: 2002
Research and Advanced Technology for Digital Libraries: 9th European Conference, ECDL 2005, Vienna, Austria, September 18-23, 2005 : Proceedings Authors: Andreas Rauber, Stavros Christodoulakis, A Min Tjoa, Pages: 545, Published: 2005
Grid Computing: First European Across Grids Conference, Santiago de Compostela, Spain, February 13-14, 2003 : Revised Papers Authors: Francisco Fernández Rivera, Pages: 328, Published: 2003
Access 2003 Bible Authors: Cary N. Prague, Michael R. Irwin, Jennifer Reardon, Pages: 1464, Published: 2003
ADO ActiveX Data Objects: Active X Data Objects Authors: Jason T. Roff, Nancy Kotary, Pages: 601, Published: 2001
Expert One-on-one J2EE Development Without EJB Authors: Rod Johnson, Juergen Hoeller, Pages: 552, Published: 2004
Recent Advances in Parallel Virtual Machine and Message Passing Interface: 9th European PVM/MPI Users' Group Meeting, Linz, Austria, September 29-October 2, 2002 : Proceedings Authors: Dieter Kranzlmüller, Peter Kacsuk, Jack Dongarra, Jens Volkert, Pages: 462, Published: 2002

Web:
Download details: MDAC 2.8 Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as the Microsoft SQL Server™ OLE DB provider and ODBC driver.
Microsoft Data Access Components - Wikipedia, the free encyclopedia MDAC 1.5 was the last data access component release supported under Windows NT 3.51 ..... Microsoft, Microsoft Security Program: Frequently Asked Questions: ...
Writing a Generic Data Access Component Home » .NET Best Practices » Writing a Generic Data Access Component ..... Post a Feedback, Comment, or Question about this article ...
microsoft data access components and ado.net tutorials for ... Apr 1, 2003 - Creating a Data Access Layer in .NET - Part 2 ..... Aug 1, 1999 - To ADO or not to ADO, that is the question To ADO or not to ADO, ...
Data Platform Data namespace. For SQL Native Client or related topics, see SQL Server Data Access forum. LINQ to SQL Questions and discussion about LINQ to SQL. ...
Data Access Component for SQL Server in C# The attached source code a data access component for SQL Server that contains methods to get a ... Post a Feedback, Comment, or Question about this article ...
Microsoft Data Access Components (MDAC) - Free software downloads ... Come to CNET Download.com for free and safe Microsoft Data Access Components ( MDAC) downloads. Enable universal data access for your Windows-family ...
SQL Server Data Access Components Frequently Asked Questions But it is highly recommended to download the latest version (newer than 2.5) of Microsoft Data Access Components (MDAC). Licensing and Subscriptions Am I ...
ploeh blog : Data Access Component Testing Redux re: Data Access Component Testing Redux. Thursday, July 03, 2008 5:23 PM by ploeh. Hi Joe. Thank you for your question. I've never worked with Oracle, ...
Data Access Component - Update Data in C# and AJAX This tutorial will show you how to use C# and AJAX to create a Data Access Component that will display data from a SQL database and also allow edits of the ...

Videos:
Data Access in the ASP.NET 2.0 Framework www.mylivelessons.com Stephen Walther, the world's leading ASP.NET authority introduces his new LiveLesson- DVD-ROM hands-on personal video instruct...
03 Testimony_of_Dr_Tom_Ryan Pima_County_Election_Integrity_Trial_Arizona Tom Ryan has a PhD in computer programming. There are generally just a few real take-away nuggets of information from an witness' testimony that can...
Cisco Aironet 1250 Series Access Point: Video Data Sheet Cisco Aironet 1250 Series access points are a critical component of the Cisco Unified Wireless Network. These access points are not only easy to depl...
Supersymmetry, Extra Dimensions and the Origin of Mass Google Tech Talks June 18, 2007 ABSTRACT "Supersymmetry, Extra Dimensions and the Origin of Mass: Exploring the Nature of the Universe Using PetaSc...
UNICEF: "Bee" system provides connectivity in emergencies NEW YORK, USA, 20 August 2008 -- UNICEF has successfully tested the first two prototypes of the 'Bee', a mobile communication system developed by the...
Access 2000 (01) Beginning The Access 2000 (01) Beginning is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course t...
Seattle Conference on Scalability: Scalable Wikipedia with E Google Tech Talks June 14, 2008 ABSTRACT IGlobal online services at Amazon, eBay, Myspace, YouTube, or Google serve millions of customers with tens...
Access 2000 (01) Beginning The Access 2000 (01) Beginning is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course t...
4/5. Access to Nutrients Threatened, Natural Medicine http://www.encognitive.com Codex Means More Pesticides on Crops, More Antibiotics and Hormones for Animals Codex Alimentarius allows pesticides, vete...
Access 2000 (01) Beginning The Access 2000 (01) Beginning is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course t...




Search This Site:










syntax error in masterpage

programatically putting a user control into a content place holder

regarding treeview's treenode checked change

giving value to master page contents

design of masterpage

asp:menu aligned left in firefox. how do i set the alignment to right?

set the default page of the folder

better navigation controls.

finding control in master page

web.sitemap

removing wizard step from wizard control

enforcing the size of the contentplaceholder? dealing bigger images?

how to implement a mouse over image chaneg in dynamic menu

how does the masterpage know which contentpage is being loaded?

web.sitemap setup

setting skins of controls within usercontrols

extending treenodecollection, sealed classes??

accessing contentplaceholders from codebeside

asp:menu image backgrounds

master pages not rendering properly

xmldatasource and menu question

profiles and themes in visual studio 2008

wizard data collection question

master pages across solutions

menu control - how to ignore hyperlink styles

display plus(+) and minus(-) sign for treenodes in a treeview in .net framework version 2.0

i need suggestions for debugging some strange behavior.

master page and resizing problem and the properties window

how to set different color for menu.

submitting webform using master pages(asp.net 2.0)

  Privacy | Contact Us
All Times Are GMT