>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.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up