troubleshooting Question

Modify ADO connection string...

Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America asked on
Visual Basic.NETMicrosoft SQL Server 2008
12 Comments1 Solution478 ViewsLast Modified:
In a simple drag and drop application, I have:

connectionString="Data Source=MIKE-VAIO;Initial Catalog=WSCGSoftware;Integrated Security=True"

connecting to a database (WSCGSoftware) in SQL Server 2012 Enterprise. I used  "Add New Data Source" wizard to do this.

Question: How can I modify this connection string to the same database at "C:\TestFolder\WSCGSoftware.mdf" on the same computer?

This application will be tested in another computer later with "C:\TestFolder\WSCGSoftware.mdf" on it, but there will be no SQL Server installed on it.

If this is not possible, what if the second computer had SLQExpress installed on it.

Idealy, path "C:\TestFolder\" should be the root directory of the project itself. Some comment on it will be appreciated.

Thank you.
 
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="Test_A.My.MySettings.WSCGSoftwareConnectionString"
            connectionString="Data Source=MIKE-VAIO;Initial Catalog=WSCGSoftware;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0,Profile=Client" />
    </startup>
</configuration>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros