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.
Tim