>Al,
>
>>You show 2 different connection strings - one starting with Dim objConn, the other with REM "Provider ...
>>
>>Are you trying to connect with a trusted connection, or via a SQL Server account? You may need to check that the SQL Server instance is configured to support the logon type you're trying to use.
>>
>>A good site for general connection string information is, unsurprisingly, http://www.connectionstrings.com
>
>Isn't the REM still a REMark or comment? That must have been an old one he was playing with.

Quite possibly, even likely. Speaking for myself, if I have some code that works, I don't throw it away if I want to try something new - I'll remark it out. If the new doesn't work, it's then easy to compare to the old. I was thinking, maybe he's done the same thing.

Since it looks like he's trying to change his logon/authentication method he'll still need to check that the instance supports the method he's trying.