Converting MS Sql Server to MySql

[Jim McCaslin]

I am converting a web based program from MS Sql Server to MySql. I have removed the sql server code and replaced it with MySql code. Sometimes when the C# code is running a function will not complete. The following code will sometimes run , but sometimes will get to one of the MySql statements and go off into never-never land. I'm suspecting that java code in another part of the program has grabbed the processor. Does MySql do a 'DoEvents' to release the processor? In tracing this piece of code it will often do the open, then be gone but sometimes it will complete.

Any ideas?

 
            DataSet dsAccount = new DataSet();
            string ConnectionString = System.Configuration.ConfigurationManager.AppSettings.Get("mySqlConnectionString");
            MySqlConnection myConnection = new MySqlConnection(ConnectionString);
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            string SQL = "SELECT accountid FROM accounts WHERE userid = '" + username + "'";
            adapter.SelectCommand = new MySqlCommand(SQL, myConnection);
            myConnection.Open();
            adapter.Fill(dsAccount);
            myConnection.Close();
 
 

thanks,
Jim

[pbmods]

Heya, Jim. Welcome to TSDN!

What do you mean by 'never-never land'? Are you getting an error? Does your script hang or go into an infinite loop? Are you just not getting a valid result set from your query?