jmasterx jmasterx - 5 months ago 44
ASP.NET (C#) Question

What is wrong with my connection string?

I am trying to connect to my shared-hosted database.

They gave me this as an example:

Data; Initial Catalog=KezBlu; User ID=KezBlu; Password='your password';

From which I made:

<add name="LibKezberProjectManager.Properties.Settings.KezberPMDBConnectionString" connectionString=" Server=****; Database=KezBlu; User ID=****; Password=mypassword; Trusted_Connection=False" providerName="System.Data.SqlClient" />

But Linq cannot seem to connect to it.

I am not sure what could be wrong.

It works fine when I use my local SQLExpress...



Try using the same keywords as the example given to you by the provider.

So replace Server with Data Source and Database with Initial Catalog.

You may also want to remove Trusted_Connection=False.