DbConnectionStringBuilder

[Guest]

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

 

[Luxspes [MCP]]

Have you tried with this:
Using DataLinks to get or edit a connection string
(http://www.codeproject.com/cs/database/DataLinks.asp)

 

[Guest]

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