App.config Connection String? - D-Tools Forum

10-08-2007, 04:57 PM

Whats is the connection strings spose to look like. The quickstart guide doesnt really say what it should be. I have sqlExpress and I'm not really sure what to put into this file to connect to sample db's with the sample application.

HTML Code:

<add name="DTools.SystemIntegrator..SDK.DAL.Properties.Settings.DToolsMasterTableConnectionString"
        connectionString="Data Source=SQLEXPRESS\dtoolsmsde;Initial Catalog=DToolsMasterTable;Integrated Security=True"
        providerName="System.Data.SqlClient" />

    <add name="DTools.SystemIntegrator.SDK.DAL.Properties.Settings.DToolsProjects40ConnectionString"
        connectionString="Data Source=SQLEXPRESS\dtoolsmsde;Initial Catalog=DToolsProjects40;Integrated Security=True"
        providerName="System.Data.SqlClient" />

10-08-2007, 04:59 PM

I get this error message when trying to open the sample app.

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

CoreyK · 10-08-2007, 05:46 PM

If you have installed SQLExpress with both integrated and SQL Server Security you simply need to change the "Server" value to point to the correct server and instance name. If no instance name was created, this will only need to be the name of the server.

Let me know if this solves your problem

Corey

10-08-2007, 06:04 PM

I've tried everything. I have no clue what the integrated security is but I install SQLExpress with everything on it, so I assume that its there. My computer name is AARONSI and the instance name is SQLEXPRESS, I've tried localhost and various other things nothing seems to work, Should I remove my DTOOLSMSDE instance its still on here from the old sdk I was testing.

HTML Code:

<add name="DTools.SystemIntegrator..SDK.DAL.Properties.Settings.DToolsMasterTableConnectionString"
        connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=DToolsMasterTable;Integrated 

Security=true"
        providerName="System.Data.SqlClient" />

    <add name="DTools.SystemIntegrator.SDK.DAL.Properties.Settings.DToolsProjects40ConnectionString"
        connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=DToolsProjects40;Integrated 

Security=true"
        providerName="System.Data.SqlClient" />

10-08-2007, 07:47 PM

It says the DToolsProducts50_log.LDF file is corrupted. So i cant even generate a connection string threw .net. This kill the app. You said is a previous email that this file was corrupted. How do I get sqlExpress to generate a new .ldf

10-08-2007, 07:52 PM

ok generated a new .ldf and the .net generated these connection strings, but it still doesnt work, its throwing the same error.

HTML Code:

<add name="DTools.SystemIntegrator.SDK.SampleApplication.Properties.Settings.DToolsProducts50ConnectionString"
      connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DToolsProducts50.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
      providerName="System.Data.SqlClient" />
    <add name="DTools.SystemIntegrator.SDK.SampleApplication.Properties.Settings.DToolsProjects50ConnectionString"
      connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DToolsProjects50.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
      providerName="System.Data.SqlClient" />

10-08-2007, 08:25 PM

Now I get the dialog message "Bussiness manage database not found, verify connection string" but it seems to be the same error thrown from the code. when I add the new connection the test connection works fine

Bill Battaglia · 10-12-2007, 05:56 PM

If you are utilizing the Sample Applicaiton with the SDK try this:

connectionString="Data Source=(local);Initial Catalog=DToolsProducts50;Persist Security Info=True;User ID=d-toolsprojects;Password=d-toolsprojectsadmin"

The Sample dB is utilzing the old SI 4.x User ID and Password.

Bill