title: Error converting data type DBTYPE_DBTIMESTAMP to datetime2
body: <p>I have this code</p>
  
  <pre><code>SELECT
  TRY_CONVERT(varchar(150), "PCR_Fecha")  AS "PCR_Fecha"
  FROM OPENQUERY(EXTRACCION, 'SELECT * FROM EXTRACCION.Extraccion')
  </code></pre>
  
  <p>But i get the error </p>
  
  <pre><code>Error converting data type DBTYPE_DBTIMESTAMP to datetime2.
  </code></pre>
  
  <p>I know there are wrong values in PCR_Fecha (like 40218:00:00 or 14mayo09) that's why I'm trying to convert them to varchar.</p>
  
  <p>I can see the data using</p>
  
  <pre><code>SELECT * FROM OPENQUERY(EXTRACCION, 'SELECT CAST(PCR_Fecha AS varchar(26)) FROM EXTRACCION.Extraccion');
  </code></pre>
  
  <p>The linked server is from Filemaker and there PCR_Fecha is set as a date.
  Looking for an answer I found that I could define "dbtimestamp_rules=2" in connection string but I don't know how to add the rule.</p>
  
  <p>Any other suggestions? </p>