Hello all,

Does anyone know if there is an updated version of MyOLEDB on the horizon? Using the current version ( 3.0 ) on Visual Studio .NET is difficult at best. In some ways it just doesn't work. Some parts do work. I can connect and look at datasets all day long using the oledbDataAdapter. I can't get the primary keys to work, but that isn't a big deal to me. I just can't use the find command on the datarow object. The oledbDataAdapter doesn't know how to handle the update command( not the SQL update ;). I have tried every trick I could come up with and could not coerce the oledbDataAdapter into updating the database. The solution I have used involved using the oledbcommand object and executing my SQL string directly on the database.

The cool Crystal Reports engine that comes with .net doesn't play well with MyOLEDB either. I think I can make it work though.

If I am just being stupid, someone please enlighten me.

Ps I can provide vb source of the above working if anyone is interested.