January 15, 2008

Test Connect By NotePad


1. Open notepad
2. Save as by name.udl on desktop
3. Open name.udl you can testing connection based and copy path : [oledb ] with notepad too.
Example

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=Test;Data Source=CALISTO

Archive

Google