jmasterx jmasterx - 1 year ago 91
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...


Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download