MyODBC problems in Exporting/Importing Data

• Carola-137875

  Newbie

  Points: 9

  More actions

  April 12, 2004 at 2:38 pm

  #162243

  Dear Friends..

  I'll try to export some complet tables and some particular data from other tables from SQL Server 7 to MySQL using MySQl ODBC 3.51 (I'm using the Import/Export SqlServer Option) and both cases gave me the same error:

  (I'LL try to translate to english, because I use SQL Server Spanish version)

  "Destiny error, OLE DB multiple steps generate error, OLEDB error.Verify the state value of OLEDB"

  But, when I import data from MySQL throug MySql ODBC3.51 to SQL Server 7 works good.

  I verified that type tables in Mysql were in InnoDB, this type of tables permit foreign keys.

  Although I think that's no problem because I'll try to pass in one case only data.

  (Sorry my english)

  Thanks a lot for some help.

  Carola

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 15, 2004 at 8:19 am

  #502952

  Not sure if this will help

  http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]