Please someone bring me out this misery, I am
trying to use the OLE DB provider for ODBC but i dont get the same results as i would do if i was using DAO.

I want ADO to display the ODBC select DSN box so that a user may choose any DSN s/he wishes from the DSN list on his/her machine.


Dim cnn1 As ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn As String

Set cnn1 = New ADODB.Connection
cnn1.Open "provider=msdasql;driver = {SQL SERVER};ODBC", "sa"

The above string just throws up an error message asking for ie DSN and server name etc, well each user would have unknown to programmer server names so how do i get this right ...some help please.

thanks

regards
sultan