Problem with a mysteriously persistent connection string parameter

Question

This morning I deployed an MVC3 application to my hosting provider, using the VS publish action to apply a transform to my web.config file. For debugging I use a local SQL Server, with a trusted connection, and for release I transform the connection string to use a SQL login. I accidentally deployed the first time using the incorrect keyword 'user name' instead of 'user id' in the release connection string, and I got the expected error:

Keyword not supported: 'user name'

I corrected my web.config.release, then published and deployed again, but I still get the same error on the host. I can find no occurrence of the term 'user name' anywhere in my solution, nor in the files I published and uploaded, and the support guy at the host can't find any reference to the term either. He has even restarted IIS for me, with no change.

How could I go about diagnosing and/or helping my host diagnose an issue like this?

Which Deployment method? If it is FTP you might have to check override files. — Dismissile
– Dismissile, Commented Jul 14, 2011 at 16:59

Dismissile · Accepted Answer · 2011-07-14 17:02:09Z

1

Try deleting the files on the server before deploying. If you deploy again and it is still there, then you know that somewhere in your solution something is wrong (or that it is not rebuilding, etc.)

If you get the expected result then you know that the deployment isn't overriding your files.

answered Jul 14, 2011 at 17:02

Dismissile

33.1k40 gold badges179 silver badges269 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ProfK Over a year ago

That helped me diagnose the problem, thanks. The same error without any visible web.config was quite a watershed.

ProfK · Accepted Answer · 2011-07-15 07:24:47Z

0

This was caused by a very confusing directory structure on my FTP account at the hosting provider, like this:

ftp-home (ftp://*www*.mydomain.com)
|
|--Content
|
|--mydomain.com
|    |
|    --wwwroot
|
|--wwwroot

I had been uploading to the first visible wwwroot, not the inner one.

answered Jul 15, 2011 at 7:24

ProfK

51.4k127 gold badges419 silver badges808 bronze badges

Collectives™ on Stack Overflow

Problem with a mysteriously persistent connection string parameter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related