Results 1 to 6 of 6

Thread: Access denied to virtual tables from SQL Server ODBC

Threaded View

  1. #1
    Junior Member
    Join Date
    Apr 2017
    Posts
    2

    [SOLVED] Access denied to virtual tables from SQL Server ODBC

    I want to connect to SQL Server database (2016 version) via ODBC.
    Running Windows 10 x64, I've created a system DSN using Microsoft ODBC 32bit driver (version 11).
    Connection established correctly.

    Then I create a database in Lianja App Builder, and choose "create Virtual Tables from ODBC..."
    I fill "ODBC DSN", "Username" and "Password", clic "Tables" button, and tables list is shown correctly.


    Then clic "Import", and Console Workspace Output shows progress, ending with
    Create Virtual Table 'vt_tomaspautasics' from 'tomasPautasICS'
    Create Virtual Table 'trace_xe_action_map' skipped
    Create Virtual Table 'trace_xe_event_map' skipped
    Operation complete, 52 Virtual Tables created.
    Refreshing tables panel.
    Completed.


    But in "Data workspace", I cannot browse names or attributes of tables (message "Access denied"):

    ¿What am I doing wrong?
    Attached Images Attached Images   
    Last edited by adiez; 2018-02-03 at 06:22. Reason: solved

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us