I have been going crazy trying to trace down an 80004005 error.<BR><BR>It seems that when I run the same query with a DSN connection it works, but with a DSN-less connection, it gives the unspecified error!<BR><BR>SQL: "SELECT count([f1]) AS found FROM guest WHERE [f1] = 73545"<BR><BR>The code has been stripped so I can try and see what is going on. It uses the same SQL statement twice, with only the method of opening the connection changing.<BR><BR>Another thing - If I change the SQL Statement so that it does not include the COUNT function, it works fine for both! Is this some strange feature of the DSN-less connections?<BR><BR>Any help at all would be greatly appreciated. I am going nuts over this.<BR><BR>Thanks,<BR>Bill Case