topic QlikView custom OLEDB Port Number in QlikView

QlikView custom OLEDB Port Number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My customer have two server which is QlikView Server and SQL Server. The QlikView server need to load and get the data from SQL server, but the SQL server already change the port number to 9797 rather than port number 1433. Therefore, I cannot find the SQL Server in my QlikView Server by using OLE DB connection link. Can I custom the port number in the QlikView Server when I need to connect to SQL Server?

Appreciate your help.

Thanks.

Best Regards,

Re: QlikView custom OLEDB Port Number

Peter_Cammaert — Tue, 30 Aug 2016 10:38:17 GMT

Connect using TCP/IP, specify an IP-address and add a comma and the correct port number.

If you already have a connection string, you will find examples of how to modify your connection string on this extremely useful site (link points to the SQL Server area): SQL Server connection strings - ConnectionStrings.com

Best,

Peter

Re: QlikView custom OLEDB Port Number

Anonymous — Thu, 01 Sep 2016 03:33:22 GMT

Dear Peter,

I manage to build the connect by using ODBC instead of using OLE DB connection link.

Thanks,

Best Regards,