Thank you Xiaoxiang, both the link you sent me and chatgpt told me that this error comes from Visual C++ Redistributable for Visual Studio 2015 but I install/reinstall this component many times already still having the same problem
Take a rest now and before retrying with this ODBC On Wed, Nov 8, 2023 at 4:46 PM Xiaoxiang Yu <x...@apache.org> wrote: > I guess your situation maybe similar to this link: > - > https://dba.stackexchange.com/questions/238135/odbc-error-for-oracle-client-12-2-0-1 > > Here are some librays that I installed on my PC. > > (My PC is a single language version, its display language can not change > to English.) > [image: check-visual-c++-windows.jpeg] > > > ------------------------ > With warm regard > Xiaoxiang Yu > > > > On Wed, Nov 8, 2023 at 4:00 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: > >> Hi Xiaoxiang, >> >> I got this error when configuring the ODBC, it said the dll file was not >> found but in fact it is there in the location. Please kindly advise... >> >> Thank you very much >> >> [image: image.png] >> >> On Wed, Nov 8, 2023 at 2:25 PM Xiaoxiang Yu <x...@apache.org> wrote: >> >>> Hi, >>> This morning, I verified the Kyligence ODBC Driver's connectivity >>> with Kylin 5.0.0-beta, it works well on my Windows PC, and I can preview >>> the table data in the Power BI application correctly. >>> >>> Here is my PC and software information: >>> - PC : A laptop with 4 cores CPU and 16GB RAM >>> - OS : Windows 11 Home China Version, 22H2 >>> - Kylin : Kylin 5.0.0-beta in docker image(downloaded from dockerhub) >>> - Docker Desktop : latest(4.25.0) >>> - WSL : latest/ubuntu >>> - Power BI Desktop : 2.122.1066.0 64-bit(October 2023) , the latest >>> version which download from Microsoft Store >>> - ODBC Driver: 3.1.12, visit >>> https://download.kyligence.io/#/download , >>> find the link of 'Kyligence ODBC Driver for Windows 64 bit', the >>> downloaded >>> file name should similar to 'Kyligence.ODBC.3.1.12.1008.Windows.x64.exe' >>> >>> >>> Here is how to prepare a Kylin Instance in Windows: >>> 1. Install Docker Desktop and WSL, refer >>> https://learn.microsoft.com/zh-cn/windows/wsl/tutorials/wsl-containers . >>> 2. Execute command( >>> https://hub.docker.com/r/apachekylin/apache-kylin-standalone) in WSL >>> shell(default is Ubuntu) >>> to start Kylin Instance. >>> 3. Build a segment of Model 'sample_ssb' and make sure the job >>> succeeds. >>> 4. Install Power BI Desktop(it is free to use) >>> 5. Install and configure Kyligence ODBC Driver, and test the >>> connectivity >>> 6. 'Get Data' from Power BI Desktop, and preview table rows >>> >>> >>> Here is my configuration of 'ODBC Datasource': >>> - Host : 127.0.0.1 >>> - Port : 7070 >>> - Username : ADMIN >>> - Password : KYLIN >>> - Project : learn_kylin >>> >>> Here is my suggestion: >>> Unluckily, I didn't have the same software as yours. But I think you >>> should >>> check if you configured it correctly. >>> If you cannot make it correct, please go to 'Kyligence ODBC Driver >>> DSN >>> Setup', >>> click the 'Logging Options', and set proper Log Level and Log Path. Then >>> you >>> should retry and check if log files show any helpful message. >>> >>> Here are some of my screenshots: >>> 1. Step 5, ODBC DSN Configuration, >>> >>> https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-1.jpeg >>> 2. Step 6, Power BI Desktop, >>> >>> https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-2.jpeg >>> >>> Hope this reply will help you fix your problem. >>> >>> ------------------------ >>> With warm regard >>> Xiaoxiang Yu >>> >>> >>> >>> On Tue, Nov 7, 2023 at 7:18 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> >>> wrote: >>> >>> > Hi Xiaoxiang, I downloaded that file but the error is still the same, >>> > please kindly investigate and advise me. >>> > >>> > Thank you very much >>> > >>> > On Tue, Nov 7, 2023 at 5:15 PM Xiaoxiang Yu <x...@apache.org> wrote: >>> > >>> > > I need some time to try to reproduce and find the cause, but before >>> that, >>> > > could you re-download another driver from >>> > > https://download.kyligence.io/#/download have >>> > > another try ? >>> > > ------------------------ >>> > > With warm regard >>> > > Xiaoxiang Yu >>> > > >>> > > >>> > > >>> > > On Tue, Nov 7, 2023 at 5:58 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> >>> > wrote: >>> > > >>> > >> Thank you Xiaoxiang, please see the attached photo and advise me the >>> > >> following: >>> > >> >>> > >> 1. I setup the file of x64, is it correct? >>> > >> 2. I run docker kylin 5.0 on Windows 10 Enterprise, mapping port of >>> > >> docker to 7070:7070 but it showed error as attached file. please >>> advise >>> > the >>> > >> configuration. >>> > >> >>> > >> Thank you very much >>> > >> >>> > >> [image: image.png] >>> > >> >>> > >> On Tue, Nov 7, 2023 at 4:51 PM Xiaoxiang Yu <x...@apache.org> >>> wrote: >>> > >> >>> > >>> Oh, you just ignore the 'A running Kyligence Enterprise server', >>> since >>> > >>> you >>> > >>> have a Kylin 5 server, you can replace it with your Kylin 5 server. >>> > >>> That is because I know that these two products share the >>> > >>> same API, metadata, and the core design . >>> > >>> ------------------------ >>> > >>> With warm regard >>> > >>> Xiaoxiang Yu >>> > >>> >>> > >>> >>> > >>> >>> > >>> On Tue, Nov 7, 2023 at 5:40 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> >>> > >>> wrote: >>> > >>> >>> > >>> > Hi Xiaoxiang, >>> > >>> > >>> > >>> > In order to use Kylin ODBC, do I need to buy separate license of >>> > >>> Kyligence >>> > >>> > to use it? >>> > >>> > >>> > >>> > Prerequisites >>> > >>> > >>> > >>> > 1. >>> > >>> > >>> > >>> > Microsoft Visual C++ 2015 >>> > >>> > >>> > >>> > During the installation of Kyligence ODBC Driver, Microsoft >>> VC++ >>> > >>> will be >>> > >>> > installed first and redistributable is already embedded in the >>> > >>> > installation >>> > >>> > package. If Microsoft Visual C++ 2015 is already installed on >>> your >>> > >>> > machine, >>> > >>> > this step will be skipped. >>> > >>> > 2. >>> > >>> > >>> > >>> > A running Kyligence Enterprise server >>> > >>> > >>> > >>> > Kyligence ODBC Driver will connect to a Kyligence Enterprise >>> > server >>> > >>> to >>> > >>> > verify whether the connection works, so make sure the >>> Kyligence >>> > >>> > Enterprise >>> > >>> > is running properly. >>> > >>> > >>> > >>> > >>> > >>> > Thank you and best regards >>> > >>> > >>> > >>> > On Tue, Nov 7, 2023 at 3:46 PM Xiaoxiang Yu <x...@apache.org> >>> wrote: >>> > >>> > >>> > >>> > > Kylin Team didn't release a suitable driver at the moment, but >>> you >>> > >>> can >>> > >>> > try >>> > >>> > > an ODBC >>> > >>> > > driver from Kyligence(a vendor of Kylin). I did not verify but >>> I >>> > >>> supposed >>> > >>> > > it should >>> > >>> > > work for 5.0.0-beta. Please let us know if it can meet your >>> needs. >>> > >>> > > >>> > >>> > > Here are the download and document links by its website: >>> > >>> > > >>> > >>> > > 1. >>> > >>> > > >>> > >>> >>> > >>> https://kyligence.io/resources/kyligence-odbc-driver-for-apache-kylin-2/ >>> > >>> > > 2. >>> > >>> > > >>> > >>> > > >>> > >>> > >>> > >>> >>> > >>> https://docs.kyligence.io/books/v4.6/en/Analyst-and-Business-Users-Guide/integration/ >>> > >>> > > >>> > >>> > > >>> > >>> > > ------------------------ >>> > >>> > > With warm regard >>> > >>> > > Xiaoxiang Yu >>> > >>> > > >>> > >>> > > >>> > >>> > > >>> > >>> > > On Tue, Nov 7, 2023 at 3:14 PM Nam Đỗ Duy >>> <na...@vnpay.vn.invalid> >>> > >>> > wrote: >>> > >>> > > >>> > >>> > > > Dear Sir/Madam >>> > >>> > > > >>> > >>> > > > Our company is using report server on premise. Please advise >>> me >>> > the >>> > >>> > > > integration guidelines in two scenarios: >>> > >>> > > > >>> > >>> > > > 1. POC period: >>> > >>> > > > Power BI report server: Windows 10 >>> > >>> > > > Kylin 5.0 in docker file downloaded from official kylin >>> website >>> > >>> > > > >>> > >>> > > > 2. Development period: >>> > >>> > > > Power BI report server: Windows 10 >>> > >>> > > > We plan to not use docker this time: Kylin 5.0, Hive, zoo >>> keeper, >>> > >>> > hadoop >>> > >>> > > in >>> > >>> > > > Ubuntu >>> > >>> > > > >>> > >>> > > > Thank you very much and best regards >>> > >>> > > > >>> > >>> > > >>> > >>> > >>> > >>> >>> > >> >>> > >>> >>
