How can we help you today? How can we help you today?

No Intellisense for Linked Server connection to MySQL ODBC

Hi. I have been using SQL Prompt for awhile and one of the best feature I like about it is the fact that Intellisense works even on Linked Server to other MSSQL databases.

Recently however, I have set up Linked server to MySQL ODBC connections and I noticed that Intellisense is no longer returning the table names and column names in the predictive boxes.

I then tested this to other ODBC connection. I set up Firebird (DB2) and Oracle and Intellisense seems to be working for these (only for table names, not columns but that's better than nothing).

Is there a way that we can get it to work for MySQL ODBC connections as well?
cathlynn
0

Comments

1 comment

Sort by
  • Aaron L
    Hi Cathlynn,
    We don't officially support linked servers other than to MSSQL servers at the moment so I'm a little surprised oracle works at all. I could see how this would be a really useful feature if we did support it though!

    The best place for a feature request like this is our UserVoice page if you'd like to open a new request. It really helps us when prioritising which features to work on next.

    Thanks,
    Aaron.
    Aaron L
    0

Add comment

Please sign in to leave a comment.