Prompt for ADO.Net Connection String

[bigbob]

Prompting for an ADO Connection String:
MSDASC.DataLinks DataLink = new MSDASC.DataLinks();

ADODB._Connection Conn;

Conn = (ADODB._Connection)DataLink.PromptNew();

LocalClass.WriteConnString(Conn.ConnectionString.ToString());

//Works fine, but the connection string is formatted as: Provider = xxx,
etc..

//No good for ADO.Net Connection

How do you prompt for an ADO.Net connection string?

I really shouldn't need the COM references, but I don't know what the Net
references are.

 

[Miha Markic]

Hi,

If you are after sqlconnection (sql server) connectionstring then just
remove the data provider part.

 

[Miha Markic]

Hi,

Thanks, Miha. I thought about that and I guess it'll work.
It does leave me with an undesired COM reference though.

Indeed. Oh well.

 

[bigbob]

Thanks, Miha. I thought about that and I guess it'll work.
It does leave me with an undesired COM reference though.