1. Open Notepad
2. Save the blank notepad with any name but ending in .udl
3. Close Notepad
4. Find the UDL
5. Open the UDL which will create the connection string for you
6. Close the UDL
7. Open the UDL in notepad There's your connection string Should look something like the following: [oledb] ;
Everything after this line is an OLE DB initstring
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adam;Data Source=TURNER-1B9A9553\SQLEXPRESS vamsi
No comments:
Post a Comment