accessing udl dialog

Question

how can i access the udl dialog(universal data acess) for creating connection string

Administrator · Answer

Thankyou very much zulfi but I did it in VB. here is the code Dim datalinksdlg As MSDASC.DataLinks datalinksdlg = New MSDASC.DataLinks() Dim adoconn As ADODB._Connection adoconn = datalinksdlg.PromptNew() MessageBox.Show(adoconn.ConnectionString())

Administrator · Answer

Here is the code for accesing UDL dialog programatically . //Set a reference to the oledb32.dll and ADO //It will create the MSDASC Wrapper for you... private void PromptNew_Click(object sender System.EventArgs e) { MSDASC.DataLinks objDataSourceDlg = new MSDASC.DataLinks(); ADODB._Connection adoConnection; adoConnection = (ADODB._Connection)objDataSourceDlg.PromptNew(); objDataSourceDlg.WriteStringToStorage(@Connection.UDL adoConnection.ConnectionString 2 ); //CREATE_NEW 1 CREATE_ALWAYS 2 OPEN_EXISTING 3 //OPEN_ALWAYS 4 TRUNCATE_EXISTING 5 } private void PromptEdit_Click(object sender System.EventArgs e) { MSDASC.DataLinks objDataSourceDlg = new MSDASC.DataLinks(); ADODB.Connection objADOConn = new ADODB.Connection(); object objTempConn = null; string strConnectionString; objDataSourceDlg.LoadStringFromStorage(@Connection.UDL out strConnectionString); objADOConn.ConnectionString = strConnectionString; objTempConn = (object)objADOConn; bool bSuccess = objDataSourceDlg.PromptEdit(ref objTempConn); if (bSuccess) { objDataSourceDlg.WriteStringToStorage(@SentinelDB_Connection.UDL objADOConn.ConnectionString 2); } } From Zulfikar Gul Shaikh

Administrator · Answer

i want to use it programmatically .i.e. at run time i want to invoke that udl dialog .and at run time the user to provide me info and i want to acess the db. for this there is an API but i dont know what does its name and how to use. so please if any body know let me inform or post here

Administrator · Answer

create a text file and then save it with a .udl file extension.