Mehdi - thanks for your response and sorry for the confusion. I will attempt to clarify and explain my insistance on trying to use the "Microsoft OLE DB Provider for ODBC Drivers".
1. I am not using MYSQL database. I am using a database called MAXDB which is a completely different product to MYSQL. Its a higher end product currently supported and sold by MYSQL ( more info on this db can be found at www.mysql.com
). An OLEDB provider for MAXDB does not exist.
2. I can use the namespace Microsoft.Data.Odbc and this works OK but I don't like the interface. There doesn't seem to be a way to reference database values by fieldname. Correct me if I am wrong but I can't seem to do the asp equivelent of recordset.fields("cust_name") using this .net interface.
3. I can also use the ADODB interop assembly. This appears to work very nicely and is the exact same syntax as I am used to in old ASP. There is even a way to fill a datastore using a recordset. But when I fill a datastore from the ADODB recordset and than assign the datastore to a datagrid the .Text property of my TextBox control in the datagrid.OnUpdateCommand handler returns only the PREVIOUS value and NOT my changed value. I have implemented the Textbox within the <EditItemTemplate> tags between the <columns> tags.This is driving me crazy - I know I am getting a handle to the textbox because I can successfully modify other properties for example .Visible (I will post a separate thread for this problem and include code).
4. Because of problems 2 and 3 I am attempting to use "Microsoft OLE DB Provider for ODBC Drivers" and the following namespace: Imports System.Data.OleDb. If I can get this to work it has in my understanding the following advantages....
a. It is native .net functionality (I think) correct me if I am mistaken.
b. It will probably work with my datastore and datagrid, the adodb recordset I cannot get to work (see point 3) above.
I have only been programming in .net since Saturday morning, today is Monday. Please exscuse my lack of clarity - hopefully over time I can learn to write clear and precise questions.
Thanks again and if you can help I would sincerly appreciate it.