error after deploy..? RSS

• • Reply
  

  step_xsf

  Member

  5 Points

  1 Post

  error after deploy..?

  Oct 26, 2005 07:37 AM|LINK

  hey,
  
  can somebody please help me, I have the following strange problem. I have been through a lot of little
  bugs and problems to get this far and now I am finnaly stumped.

  I am using MS Visual Studio 2005, C#, on Win XP x64.

  Running a MySQL database using the MyODBC 3.5.11 drivers.

  I want to write a XML Web Service to handle the database access. Everything works fine while I am
  in .Net but as soon as I publish it to my web server (IIS6), I get the following error. As far as I can tell
  all access and security stuff have been taken care of, which leaves me to believe
  that it's not security related?
  
  System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] 
              Data source name not found and no default driver specified
     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, 
              DbConnectionFactory connectionFactory)
     at System.Data.Odbc.OdbcConnection.Open()
     at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, 
              ConnectionState& originalState)
     at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, 
              Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
     at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, 
              Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
     at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
     at Service.getTable()
  
   
  Why might this be; does anyone have any ideas? Can it be that not all the libraries(system.data.odbc)
  get loaded (when published) to the webserver, or that they can’t be accessed from there?
  I have tried to force a reference to the System.Data.dll but to no avail. .Net libraries live in the GAC i know,
  so they should be available?

  I have connected to the database in a myriad of ways from multiple locations and applications, can
  it really be the driver that gets messed somewhere? If it is the driver or the libraries any ideas to fix it?
  Here is the connection string if someone was wondering, where i do specify the defualt driver?
  
  this.adapter = new OdbcDataAdapter(this.selectCom, 
      "DRIVER={MySQL ODBC 3.51 Driver};
      providerName=System.Data.Odbc;
      SERVER=walter;
      port=3306;
      dns=MySQLDNS;
      database=MyData;
      user=*****;
      password=****;
      option=3;"
  );
  
  Any ideas please, about to pull my hair out.