Connection Wizard

[culshaja]

Hi,

I was wondering if anyone knew of a way of invoking the ADO connection creation wizard from a VB app? This is the one that gets invoked when you are using a DataEnvironment.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[shmiller]

Are you looking for help in building a connection string?

 

[neilkonitzer]

I think that the only way that you can open the connection dialog of the Data Environment from a VB application is if the application is a VB add-in. The dialog is strictly an IDE entity and is not available for distribution. Are you trying to create an add-in that opens a connection string generation dialog? Neil Konitzer, President
Freisoft

http://www.freisoft.com

 

[culshaja]

Hi,

thanks for your input. I did find a way in the end though.

You need to set a reference to Microsoft OLE DB Service Component 1.0 Type Library. This gets shipped from MDAC 2.1 and above I believe.

You then can use the following code:

Dim dlNew As DataLinks
Dim cnNew As ADODB.Connection
Dim strConnectionString as string

Set dlNew = New DataLinks
        
Set cnNew = dlNew.PromptNew
strConnectionString = cnNew.ConnectionString

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305