I have some answers to my own questions.

1) To get the connection type, run the query "SELECT net_transport FROM sys.dm_exec_connections WHERE session_id = @@SPID;"

2) Not sure how to use Named...

Thanks Mark

It is a C++ app using ADO (not .net)

Seek is not supported on the SQL Server, I need to support both Jet and SQL Server.

I can't search the list...