Lost connection to database when site was published. (Using Linq and ASP.Net)

Salam

Hi everyone,

I was able to connect to the database on my desktop. But where I publish the website (host: 1and1.com), I fail to connect to the database.

I use Linq to SQL. Which creates these connection lines in Web.config:

These worked perfectly fine in my desktop. But when I published the website, I was given this connection string:

Provider=sqloledb;Data Source=***.***.perfora.net,1433;Initial Catalog=db33333333;User Id=dbo33333333;Password=*****;

So, I changed the Web.config files to this:

It's not working! Please help!

Thanks!

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piotr Justyna17y ago
Since you have only one project in your solution, could you please try to debug your aplication and view the connection string just before using it? Is there a possibility that you're not using a connection string from the config file? :)

Cheers!
Salam17y ago
I have only one project in my solution.
Piotr Justyna17y ago
Hi!

Your solution can consist of many projects - are you sure, that you used the config file from a proper project? You can check it while debugging your application - just view the value of your connection string. I hope I'm more specific right now :)

Cheers!
Salam17y ago
Hi Piotr, I'm not sure what you're asking for! When I was connecting to my MS-SQL DB at my desktop, everything was fine. When I published it and tried to connect to the DB at my website, it didn't work. I provided you with the connection string before and after.
Piotr Justyna17y ago
Hi Salam!

I know that it may sound stupid, but have you changed the Web.config in the correct project in your solution? Is there a possibility to view your connection string before accessing DB and during debugging?

Cheers!