>HI,
>Is there a way to change the connect string of a datacontrol programmatically. I use it to connect to an Oracle server and I use a datagrid to display the results. The problem is that the server can change and the userid/password too. The fields won't. When I issue adodcLoad.ConnecString = strConn (= variable containing the connect string), VB tells me that It does not see any odbc provider.

With ADO, you don't need data control to bind to a DataGrid. You can simply do:

Set DataGrid1.DataSource = rst

So open a connection to your database, then a recordset and bind it to your grid.