Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 how do i link my pplication to the databse

Author  Topic 

briankind
Starting Member

17 Posts

Posted - 2009-07-25 : 10:32:56
I am a beginner and i am trying to link the application to the database. how do I do that? thanks
Application is written in .net.

what tools do I use, or what do i connect and how?
I have a project qat work next week and I want to ge ready
thanks

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-25 : 12:04:11
you connect by adding the connection string in your web.config file



e.g.
replace the values in red with yours
<connectionStrings>
<add name="afrika" connectionString="Data Source=your_instance_name;Network Library=DBMSSOCN;Initial Catalog=your_db;User ID='username';Password='password';" providerName="System.Data.SqlClient" />

</connectionStrings>
Go to Top of Page

doco
Yak Posting Veteran

77 Posts

Posted - 2009-08-19 : 07:19:07
afrika: why did you assume his app was a web app?

Education is what you have after you've forgotten everything you learned in school
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-08-22 : 05:43:00
oh sorry, what was it ?
Go to Top of Page
   

- Advertisement -