Our company uses different types of shared objects. Some ADO some are dblib. Aa a DBA I am trying to get our developers to convert their applications to use Windows Authentication, but the apps that use shared opjects written in DBLIB pass 'user id' and 'password' to initialize the object.

Does anyone know if you can use Windows Authentication with DBLIB objects or do they need to be rewritten using ADO?

What is the code for dblib to use Windows Authentication?

Thank you.

-Linda