Using ADOX to chnage an MS Access query definition
-
View a printable version of this message! Hi, I'm trying to change an MS Access query definition using ADOX in my ASP.NET 2.0 c# web site. Here is my function:
public void ModifyQueryXDateFilter( string strConn, string strQryName, string strSQL) { ADOX.Catalog catDB = new ADOX.Catalog(); ADODB.Command cmd = new ADODB.Command(); catDB.ActiveConnection = strConn; cmd = (ADODB.Command) catDB.Procedures[strQryName].Command; cmd.CommandText = strSQL; catDB.Procedures[strQryName].Command = cmd; catDB = null; }the line:catDB.ActiveConnection = strConn;doesn't work. I get a typically microsoft error that means every thing except the right thing: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Can anyone help with this?Just Relax And Keep It Simple.