Can't connect to database from web service!

Can't connect to database from web service!

• clint 2

  it would help if you can post the error messages if any as well as code, and maybe try using the SQL Client namespace (SqlCommand/SqlConnection/SqlDataAdapter etc....)
  
  

• robnzrob

  Here is some of the code I have now. I am unable to get the exact error right now because I can't debug on the machine I am on currently.

  Any Ideas based on the code below

  connection = new OleDbConnection("Provider=SQLOLEDB;Data Source=10.10.200.121;Initial Catalog=SALES;UID=user;PWD=pw");

  try

  {

  connection->Open();

  command = new OleDbCommand(query, connection);

  reader = command->ExecuteReader();

  reader->Read();

  if(reader->HasRows)

  {

  this->recurrence = (DK_SCHEDULE_RECURRENCE )reader->GetInt32(0);

  this->last_run_date = reader->GetDateTime(1);

  this->next_run_date = reader->GetDateTime(2);

  this->ftp_server = reader->GetString(3);

  this->ftp_password = reader->GetString(4);

  this->ftp_username = reader->GetString(5);

  }

  
  

• Zombie_002

  what was the error how did you fix it please share with us!
  
  

• Leander-Man

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=687929&SiteID=1
  
  

• Sarosh79

  Ah I found my error and it is working now. Thanks.
  

• Indigo Cowboy

  do you have access to edit the code

  try
  {

  connection->Open();
  command = new OleDbCommand(query, connection);
  reader = command->ExecuteReader();
  reader->Read();
  if(reader->HasRows)
  {

  this->recurrence = (DK_SCHEDULE_RECURRENCE )reader->GetInt32(0);

  this->last_run_date = reader->GetDateTime(1);

  this->next_run_date = reader->GetDateTime(2);

  this->ftp_server = reader->GetString(3);

  this->ftp_password = reader->GetString(4);

  this->ftp_username = reader->GetString(5);
  }
  }
  Catch OleDBException oleEX
  {
  Response->Write(oleEx.Message());
  }
  Catch Exception ex
  {
  Response->Write(ex.Message());
  }
  Finally
  {
  connection->Close();
  }

  Just trying to determine what errors are happening. Sorry if you already have this code written.

  
  
• Can't connect to database from web service!