title: Openquery insert not working
body: <p>I have a linked MySQL -server to MSSQL-server and I am trying to INSERT  data to the table admin_user on the MySQL -server, but end up getting the error:</p>
  
  <blockquote>
    <p>Cannot process the object "dbo.admin_user". The OLE DB provider
    "MSDASQL" for linked server "MYDB" indicates that either the object
    has no columns or the current user does not have permissions on that
    object.</p>
  </blockquote>
  
  <p>This works fine:</p>
  
  <pre><code>SELECT * FROM openquery([MYDB], 'SELECT * FROM admin_user')
  </code></pre>
  
  <p>This gets the error:</p>
  
  <pre><code>INSERT into openquery([MYDB], 'dbo.admin_user') values ('Testi','Testaaja','me@google.com','koe','','','','','','1','N;','','')
  </code></pre>
  
  <p>Here are the rights of the user whom I used for creating the ODBC-connection</p>
  
  <blockquote>
    <p>| xx.xxx.xxx.xx | me | *qweqweqwdq2edqdadasd|
    Y           | Y           | Y           | Y           | Y           |
    Y         | Y           | Y             | Y            | Y         | N
    | Y               | Y          | Y          | Y            | Y<br>
    | Y                     | Y                | Y            | Y<br>
    | Y                | Y                | Y              | Y<br>
    | Y                  | Y                | Y          | Y            |
    Y                      |          |            |             |<br>
    |             0 |           0 |               0 |                    0
    |        | NULL                  |</p>
  
  <pre><code>&gt;     | %             | me | *asdasadasdsadasdasdsad| Y           | Y           | Y           | Y           | Y           |
  &gt; Y         | Y           | Y             | Y            | Y         | Y
  &gt; | Y               | Y          | Y          | Y            | Y        
  &gt; | Y                     | Y                | Y            | Y         
  &gt; | Y                | Y                | Y              | Y            
  &gt; | Y                  | Y                | Y          | Y            |
  &gt; Y                      |          |            |             |        
  &gt; |             0 |           0 |               0 |                    0
  &gt; |        | NULL                  |
  </code></pre>
  </blockquote>
  
  <p>My catalog is bitnami_magento, I have the provider string configured with </p>
  
  <blockquote>
    <p>DRIVER=(MySQL ODBC 5.3 ANSI Driver); SERVER=
    XX.XXX.XXX.XXX;PORT=3306;DATABASE=bitnami_magento;
    USER=me;PASSWORD=mypass;OPTION=3;</p>
  </blockquote>
  
  <p>Also I have unchecked the "Level zero only" box from Provider Options (MSDASQL) and made sure that ad_hoc queries are allowed. What I am doing wrong?</p>
  
  <p>There are the instructions that I followed
  <a href="http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/" rel="nofollow noreferrer">http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/</a></p>