Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15952

SQL Server linked server to MariaDB - getting error 7303

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Configuration
    • None
    • Linked server from SQL Server to Mariadb.

    Description

      I installed MySQL 5.1 odbc 64-bit, 32-bit, mariadb driver to no avail, keep getting the same error.
      Cannot initialize the data source object of OLE DB provider 'MSDASQL" for linked server MARIADBLINKED
      OLDE DB Provider "MSDASQL" for linked server "MARIADBLINKED" returned message
      "Microsoft" [ODBC Driver Manager] Data source name not found and no default driver specified".
      (Microsoft SQL Server, Error: 7303)
      I googled all the resolution and tried but still getting the same error.

      ODBC MariaDB connection was successful.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23249 __builtin_readcyclecounter in include/my_rdtsc.h causes SIGILL on ARM

          • Major - Major loss of function.
          • Closed

          Activity

            Lawrin Lawrin Novitsky added a comment -

            Could you please elaborate on the problem and why do you think it is a bug in mariadb server?

            According to the error text, the DSN you are trying to use does not exist(in your architecture). So neither ODBC connector hadn't got into the play, nor MariaDB server. And this looks like link to MariaDB server is mis-configured. MariaDB server has nothing to do with that.

            JIRA is a bugtracker, it is not a place to seek help, please use public forums instead. You might also want to consider acquiring a support contract.

            I am closing the ticket so far. If you still think this is a bug with MariaDB server - feel free to re-open it, but please provide more data proving your point.
            p.s. You can download MariaDB ODBC connector from http://mariadb.com - they are available.

            Lawrin Lawrin Novitsky added a comment - Could you please elaborate on the problem and why do you think it is a bug in mariadb server? According to the error text, the DSN you are trying to use does not exist(in your architecture). So neither ODBC connector hadn't got into the play, nor MariaDB server. And this looks like link to MariaDB server is mis-configured. MariaDB server has nothing to do with that. JIRA is a bugtracker, it is not a place to seek help, please use public forums instead. You might also want to consider acquiring a support contract. I am closing the ticket so far. If you still think this is a bug with MariaDB server - feel free to re-open it, but please provide more data proving your point. p.s. You can download MariaDB ODBC connector from http://mariadb.com - they are available.

            People

              Lawrin Lawrin Novitsky
              wilcal7 Willie Calove
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.