SQL Connection String OR Access Connection String OR How to Get Database Connection String

When Your Are confuse in database connection string.

use this simple way.

1.first create one text file.
2.rename with conn. txt
3.now change the extension. Extention name is .udl
4. now your file name is conn.udl
5. Open the conn.udl file
6. u will show data link property
7. select provider name in provider tab(for Sql Server database , select "Microsoft OLE DB Provider for SQL Server")
8. then click on connection tab
9. select database source name,enter user name,password and database name
10. Click on text connection. if you get succeed message.
11. open conn.udl file in text or notepage. You will get connection string
like "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=BusinessCoupon;Data Source=NILSON1"