Hi, i need to read data from mssql 2016 /mysql / As400 database, i have create a new connection via Odbc and Olap, but board return this message:
The check connection is ok...
I have a demo full licenze for 60 days.#
I am not the super expert on this field, but one of the issues I typically overlooked in the beginning is forgetting to check if the service user of the BOARD Engine (so not my personal account) has access to read from the db.
The test connection you use in the OLE DB-wizard instead using the "windows NT integrated security" points to your personal account. That is typically the reason why you will see "Test connection succeeded" while still receiving the Server error you just showed.
Maybe this helps, if not I leave the floor for the bigger experts between us
Not sure if you have tried to use the Username and Password in the connection this is a good/quick way if you are just testing just insure in the RDBMS you have selected MS SQL Server (the user name and password is not the best way as it does show in the connection string but if you are just trialing it as a demo is quicker then maybe creating a windows account which can run the services and creating the account in SQL as well.
Hello Marco Geraci,
all the suggestion from Jonathan Baetens and Graeme Whorrall are good suggestions, but in my opiniont you should open a ticket in our Support Portal (http://support.board.com )
We will be happy to deeply investigate with you the issue, also through a web-meeting if necessary.
Please insert all details (Board Version, log in the "SQL Log" panel after the db empty message...).
Hope this helps,
Retrieving data ...