From: WatsonR@IntelligenCIA.com   
      
   "Steve Gerrard"  wrote in message   
   news:fsOdnbnDxd6EsF7eRVn-vg@comcast.com...   
   >   
   > "Raoul Watson"  wrote in message   
   > news:wOEwf.1807$JT3.1534@trndny06...   
   > >I have a form with an AdoDc control associated to a datagrid.   
   > > The AdoDC uses a "ConnectionString" such as   
   > > "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data   
   > > Source=..."   
   > >   
   > > this is where the problem begins. The data source will not be known   
   until   
   > > the user selects the database.   
   > >   
   > > What is really weird is that if the source is not placed during design   
   time,   
   > > during run time the form upon loading will generate an error ("Failed to   
   > > authenticate"). This error seems to be untrappable since it doesn't   
   occur in   
   > > the Form Load or Activate event (I have tried to catch it there).   
   > >   
   > > Of course once the error is ignored and the datasource is set in the   
   form   
   > > load, everything works OK.   
   > >   
   >   
   >   
   > You should be able to start the app without an error if the connection   
   string   
   > property of the ADODC control is completely blank. Then set the entire   
   > connection string in code, including the part about "Provider=" etc.   
   >   
      
   Thanks.. but remember I have a grid with a datasource pointing to AdoDC so   
   if I marked ConnectionString and leave it blank, I'll get an error   
   "[Microsoft][ODBC Driver Manager] Data source name not found and no default   
   driver specified." upon form load (again, untrappable)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)