I have SQL Server 2008 and SQL server 2016 ruing on my server. How do I select which server the ADO Coection string is looking at? The Data Source indicates the Server and the Initial Catalog indicates the Data Base, but I do not find a setting to indicate which SQL Server the coection is using. Is there one? Using Delphi6.
Provider=SQLOLEDB.1;Password=xxxxxxx;Persist Security Info=True;User ID=sa;Initial Catalog=FIFDB;Data Source=ROONEY01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ALWS24;Use Encryption for Data=False;Tag with column collation when possible=False