Hi, I am attempting to load connection strings from my server's machine.config file. On our old server, this worked just fine. We just installed SQL Server, IIS, and Visual Studio on a brand new server. I created a project and, using the same code, made reference to a connection string that should be retrieved from the machine.config file. Unfortunately, I'm getting an "Object variable or With block variable not set" on the line that references the connection string's name.
When I searched my C:\WINDOWS\Microsoft.NET directory, I found a machine.config in each of these locations:
\Framework\v1.1.4322\CONFIG
\Framework\v2.0.50727\CONFIG
\Framework64\v2.0.50727\CONFIG
I added the connection string to the two version 2.0.50727 machine.config files. I didn't do anything to the version 1.1.4322 file because there were no tags for connection strings in that file. This is a 32-bit project so I'd think I'd want to reference the middle one. What am I doing wrong? Why won't my project see the connection string in the file? Thanks!