DTS to MySQL fails when scheduled

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  March 29, 2006 at 1:28 am

  #171030

  Morning,

  I have a DTS package to extract data from a MySQL Database and populate a table in SQL Server 2000. This works perfectly when run manually. However, when it is scheduled to run as a job it fails with an error "ODBC Driver Manager. Data source name not specified and no default driver specified."

  I have full admin privileges on the server.

  Any thoughts.

   

  Thanks very much

  Colin

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  March 29, 2006 at 2:22 am

  #629396

  When you schedule it to run, it runs on the server.

  When you run it manually, it runs on the client that you are running it from.

  Probably find the dsn used in the connection to mysql db is NOT on the server, only on your client.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  March 29, 2006 at 4:07 am

  #629426

  Jonathan,

        Wise words! Worked a treat. Thanks very much!

  Colin