Hello

In the MSDE Connection if I use the following code to connect with Adodb it works ,

ADO.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MyDB;Data Source=MySystem\VSdotNET"

Here instead of Data Source = Mysystem\VSdotNET , How can I specify Local machine such that it connects by default to its systems database rather than my systems database when applied on other machines. By the above code when its exe is runned on other machine it connects to my systems database , Please do provide me with the syntax.