I see that I needed to change the default install security of 'Windows only' to 'mixed mode' to solve the problem.
So now that ADO connection is working I have another question: What is the most recommended way to connect to SQL Server for SQL-Passthrough using dsnless connections to the new oledb provider? Or can the oledb provider be used by sql-passthrough?
>Using:
>oconn=CREATEOBJECT('adodb.connection')
>oconn.Open("Driver=SQL Server;Server=a;Database=b;UID=c;pwd=d;")
>I get a good object oconn, but the open method gets an error:
>The login for user x failed due to: Not associated with a trusted SQL Server connection.
>
>Does anyone know how I would fix this?
>
>Thanks.