Problem with NULL when using OPENQUERY on LINKED server

• hazulado

  SSC Enthusiast

  Points: 175

  More actions

  June 2, 2008 at 4:14 am

  #122644

  Hello,

  I've created a linked server to a MySQL database. Everything is ok except that when there is a datetime column being opened, OPENQUERY generates an error if there is a null value. And I have been looking at many forums but without any conclusive help on how to tell OPENQUERY to allow nulls. It seems that I cannot easily impact the way the conversion is made. I also looked at the properties of the columns identified by SQL server but there is no way to change them.

  Thank you in advance for your help. It is really something that is blocking me and everything else is ok.

  Hope that someone will help me. Thanks in any case.

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 2, 2008 at 7:51 am

  #822936

  Hey,

  How are you using the openquery? Are you selecting into?

  Perhaps first create your table, and set the datetime field to allow nulls?

  Good Luck!

  ~PD