Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / August 2006

Tip: Looking for answers? Try searching our database.

UDL in ADO.NET

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anders Eriksson - 30 Aug 2006 13:23 GMT
Hello!

In ADO the preferred[1] way of specifying the connection string was using
an .UDL file.

What is the preferred way to do this in ADO.NET?

// Anders
Signature

English is not my first, or second, language
so anything strange, or insulting, is due to
the translation.
Please correct me so I may learn better English!

[1] by me and MS...

Cowboy (Gregory A. Beamer) - 30 Aug 2006 14:18 GMT
Your English is fine.

I would not say the UDL was the preferred method in ADO. It was, however, a
convenient way to package a connection. In general, in .NET apps, the config
file is the proper location for configured resources. A UDL can still be
used if you are sharing connections across multiple apps, but each
application that is installed can give the user the ability to configure for
the same database, so it does not give you a lot to configure it in this
manner.

How you configure depends upon the application(s) and the user(s) [knowledge
level, etc.].

Signature

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

> Hello!
>
[quoted text clipped - 4 lines]
>
> // Anders
Anders Eriksson - 30 Aug 2006 15:25 GMT
> Your English is fine.

Thank you!

> I would not say the UDL was the preferred method in ADO. It was, however, a
> convenient way to package a connection. In general, in .NET apps, the config
> file is the proper location for configured resources.

> How you configure depends upon the application(s) and the user(s) [knowledge
> level, etc.].

The thing that was most convenient with UDL was that Windows had a build in
editor where the user easily could change configurations! Is there
something like this when using the config file?

// Anders
Signature

English is not my first, or second, language
so anything strange, or insulting, is due to
the translation.
Please correct me so I may learn better English!

Cowboy (Gregory A. Beamer) - 31 Aug 2006 13:32 GMT
Yes and no. There is a bit of leeway with the connection string section, but
it is not an external editor and you would have to put the bits in to allow
changing them. On install, however, it is quite easy to ask for the
connection string and even test prior to completing, so there is little need
for the end user to whack the string. You also have the ability to put
config elements in a separate file, which will not be locked down during
runtime, but there is no visual editor, per se.

I am sure there are some instances where end users need to move from one
data store to another, but it is not the most common scenario. I have yet to
have written an application where the common end user flips a connection
string after an application is installed, except for applications where a
user might work with multiple databases and that is usually configured at
runtime (although the strings might be stored at runtime for reuse).

Hope this helps!

Signature

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

>
>> Your English is fine.
[quoted text clipped - 17 lines]
>
> // Anders
Cor Ligthert [MVP] - 30 Aug 2006 15:43 GMT
Anderson,

The native provider from the database by instance the SQLClient or the
OracleClient, if that does not exist OLEDB and at last ODBC.

Hoping that I understood your question right as meant.

Cor

> Hello!
>
[quoted text clipped - 4 lines]
>
> // Anders
Paul Clement - 30 Aug 2006 16:17 GMT
¤ Hello!
¤
¤ In ADO the preferred[1] way of specifying the connection string was using
¤ an .UDL file.
¤
¤ What is the preferred way to do this in ADO.NET?

Well if you look at some of the hooks into the development environment the common method is to use
either the App.config or Web.config file.

I have to admit I didn't really find UDLs to be widely adopted.

Paul
~~~~
Microsoft MVP (Visual Basic)

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.