Posts

Showing posts from June, 2008

How to Create Connection String Easily

Image
will explain to you an easy way to get any Database Connection String so you can use this String to Connect to your database using any developing Language. Right Click on your Desktop Then new Text Document. Change File extension from .txt to .udl file. UDL file is Data Link File, Opened by Microsoft Data Access. Double Click on the file after Changing the Extension. You will see Form Similar to this Form. From Provider Tab, You can choose a type of Database Provider you want to use (Access, SQL Server, Oracle …). Connection Tab will be different according to the provider you choose before from provider tab. The Connection here for SQL Server Provider. The server name is the Database instance Name plus Machine Name. Logging to database require password and username that's only if you use Mixed Mode in Installing SQL Server Database If you don't know the user and password user windows Integrated Security. Then if the information above is correct you will get...