Using Database connectivity toolkit, and I have code that successfully connects to and returns result from an access database using a named Parameter Query. I have migrated the access database over to SQL Server, and I am trying to figure out what connection string and driver will work with sql server.
It looks like ODBC does not support named parameters in a query (only for stored procedures?). Is there a different driver (SQL, ADO, OLEDB, etc) that can work with SQL Server and will accept the @name format used in the DCT?
Thanks!
