Unsupported Screen Size: The viewport size is too small for the theme to render properly.

odbc import only sees tables – not views

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › odbc import only sees tables – not views

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 3, 2005 at 8:46 pm #8833
      gregoj
      Member

      when I set up an odbc import from a SQL Server database, I cannot use the “copy table” option. I only have a view into the SQL Server db and the view does not show up in the list of tables. However, if I enter the sql to manually select from the view, it gets data using the view just fine. Why won't the view show up in the list of tables? The same odbc data source shows the view just fine for other applications making an odbc connection.

    • March 3, 2005 at 9:39 pm #17119
      Ritesh
      Member

      SQLyog's ODBC Import Wizard does not support Views as of now. We are in the process of rewriting our ODBC Import feature in v4.1.

      SQLyog v4.1 FINAL will have support for Views.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.