Help! - Really wierd error...
-
Hi, I have been using ADO for a while now in my current project. Everything seemed to be working well (wishful thinking) until I noticed the following sequence of events: 1. use connection.Execute to run a UPDATE/DELETE etc query against the connected database 2. use connection.OpenSchema to get any schema information back 3. result is the '...the application is using argument that are of the wrong type...' error Has anyone here experienced this bug, whereby using the Execute method, the connection object seems to get tainted against the OpenSchema method working properly. I tried to disconnect, then reconnect before doing the OpenSchema call, but the same result. Please help! Simon
-
Hi, I have been using ADO for a while now in my current project. Everything seemed to be working well (wishful thinking) until I noticed the following sequence of events: 1. use connection.Execute to run a UPDATE/DELETE etc query against the connected database 2. use connection.OpenSchema to get any schema information back 3. result is the '...the application is using argument that are of the wrong type...' error Has anyone here experienced this bug, whereby using the Execute method, the connection object seems to get tainted against the OpenSchema method working properly. I tried to disconnect, then reconnect before doing the OpenSchema call, but the same result. Please help! Simon
Hello, I seem to have fixed this wierd error, though I don't know why it did! When I do an action query, I use the connection.Execute method as mentioned. I passed it &vtMissing for the records affected parameter as I saw this in a MSDN example somewhere. However, and this is the noodler, if I pass NULL for the records affected parameter, the problem goes away! No problem, but I don't see why this would fix it. Simon