nevergiveup01
Programmer
If I use the first config following in my Webconfig I can connect Crystal via the Wizard to my database which is housed in SQL 2005 with no problems.
If I use the one under it (#2)where the database is located in my App_data folder and uses SQL EXpress i get the error message above..
Can anyone tell me if there is something special I need to do to get the crystal Wizard to work with SQLExpress? I think I have to use #2 when I want to publish my site don't I? Otherwise my database will not work when I publish it becuase it cant find Cheryl-PC.. Help help help please
1)<add name="TestFeetConnectionString" connectionString="Data Source=CHERYL-PC;Initial Catalog=TestFeet;Integrated Security=True;Pooling=False" providerName="System.Data.SqlClient"/>
2)<add name="TestFeetConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TestFeet.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
If I use the one under it (#2)where the database is located in my App_data folder and uses SQL EXpress i get the error message above..
Can anyone tell me if there is something special I need to do to get the crystal Wizard to work with SQLExpress? I think I have to use #2 when I want to publish my site don't I? Otherwise my database will not work when I publish it becuase it cant find Cheryl-PC.. Help help help please
1)<add name="TestFeetConnectionString" connectionString="Data Source=CHERYL-PC;Initial Catalog=TestFeet;Integrated Security=True;Pooling=False" providerName="System.Data.SqlClient"/>
2)<add name="TestFeetConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TestFeet.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />