Connection String

[mike2145]

When preparing a connection using the datPrimaryRS control, it requires a connection string. How can you get this connection string without
installing Visual basic and then using the properties dialog to walk you
through the options.

I'm stuck on the Provider string, where is the list of providers located?

Connection string=Provider?????

The remaining settings appear self explanatory

I need to get this string at run time, and feed it back to the control after the program is installed on a third party machine ??

[Cakkie]

You can think of the provider as the thing you use to talk to your data. There's a different provider for each type of data you access, and for each way you do. If you are for example trying to access a SQL server via OLEDB, the provider would be SQLOLEDB, the one for ODBC is MSDASQL.
A list of providers can be found at MSDN (if you don't have it installed, you can goto http://msdn.microsoft.com)

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[mike2145]

tom thats not exactly what I need..
using VB when you run the DATA FORM WIZARD..The Wizard Provides you with a
list of Providers to choose from, the one you choose then becomes the
CONNECTION STRING
my question is where does the wizard get this information from and how..
My problem is the program im creating is for a 3rd party machine I have to
have the program itself at runtime provide me with a list of providers.
that info I can then write to an .ini file to use after the initial 1st
time.
the person who installs this program can't take vb to the clients machine
install it and run the wizard to determine this obviously..so how do I get
this info
thanks mike