https://community.qlik.com/t5/Connectivity-Data-Prep/OLE-DB-data-connection-settings-for-SQL-Server/m-p/2163043#M13249 <P>I am trying to connect to Server using OLE DB.&nbsp; What is the correct syntax for getting to the server for the question Data Source(file path or server name)&nbsp;&nbsp;</P> Thu, 18 Jan 2024 20:49:51 GMT Vincent_McCune 2024-01-18T20:49:51Z https://community.qlik.com/t5/Connectivity-Data-Prep/OLE-DB-data-connection-settings-for-SQL-Server/m-p/2163043#M13249 <P>I am trying to connect to Server using OLE DB.&nbsp; What is the correct syntax for getting to the server for the question Data Source(file path or server name)&nbsp;&nbsp;</P> Thu, 18 Jan 2024 20:49:51 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/OLE-DB-data-connection-settings-for-SQL-Server/m-p/2163043#M13249 Vincent_McCune 2024-01-18T20:49:51Z https://community.qlik.com/t5/Connectivity-Data-Prep/OLE-DB-data-connection-settings-for-SQL-Server/m-p/2163539#M13262 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/125762">@Vincent_McCune</a>&nbsp;The best approach is to have file path with full TNS using OLEDB, With this you can have always the correct load balance.&nbsp;</P> Sat, 20 Jan 2024 08:49:35 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/OLE-DB-data-connection-settings-for-SQL-Server/m-p/2163539#M13262 Anil_Babu_Samineni 2024-01-20T08:49:35Z