Yes. And while that in some ways is exactly what I'm looking for, in ways
others it just wont do. I'd to be able to handle the presentation and I'd
like to handle/filter some of that info.
What I'm most interested in is being able to detmine what the parameters are
for a particular provider are at runtime. Having that info would really make
the DbConnectionStringBuilder useful.
There has just got to be a way.. I dont see it in the registry (and I've run
filemon/regmon looking for what gets read when windows or studio displays the
infothat I'm after), so I'm betting that there is a stanard call to the
driver.
gabe
"Luxspes [MCP]" wrote:
> Have you tried with this:
> Using DataLinks to get or edit a connection string
> (http://www.codeproject.com/cs/database/DataLinks.asp)
>
> gabe wrote:
> > I'm working on a general use query tool and in that project I'm currently
> > working on building connection strings for oledb providers after I enumerate
> > the installed oledb providers on a system (side question: this is a tiresome
> > registry read - if you know a better way please let me know) I'd like to
> > present an interface for the user to enter the parameters for the driver.
> >
> > In the msdn docs there a bit that reads "For providers that support specific
> > key/value pairs, the connection string builder provides strongly typed
> > properties corresponding to the known pairs"
> >
> > What I'm hopeing that means is that there is some way to get the known
> > parameters for a particular provider at runtime, but i'm not seeing it. In
> > some fashion visual studio is able to determine the parameters for a given
> > driver..... how does visual studio do that? For example i have a syabse
> > driver that supports all kinds of parameters that most other oledb providers
> > dont. How does visual studio able to detmine what the parameters for a
> > particular provider are?
> >
> > (Sahil: yeah I know about and have thought about temp .udl idea and I may
> > have to go that route, but I would really rather not)
> >
> > /gabe
> >
>
