Hopefully this is in the right place as it's my first question. We are developing an application where part of the data handling requirements is to read and write local SAS files (Server comes later). We prefer not to have any specific SAS assembly references in our code. Following the cookbook recipe, we can write SAS files using the IOM Provider in _Local_ mode. However, the examples still use ADODB, which is only possible in 32-bit, as no 64-bit version will ever exist of ADODB.dll I have tried rewriting in ADO .NET using a DataAdapter but this is doomed to failure because the IOM provider does not support parameterised queries. My only other option appears to be to repeatedly construct and execute single row SQL insert queries. This works, but is, not surprisingly, very slow. Can anyone suggest a better method to achieve this? Thanks, Kevin
... View more