1
Answer

Error happens when my application uploads to server

Photo of amritha O

amritha O

14y
1.7k
1
hi all

I purchase server space and upload my application to it.Database (iam using MySQL ) also.Its working fine but when taking some pages error like this appearing which works well i n my local system.
Error is
MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'mydbname'@'122.172.119.128' for table 'employeedetails'
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at dboperation.GetDataTable(String qry) in c:\myapps\App_Code\dboperation.cs:line 101}


Thanks in advance

Answers (1)

0
Photo of HumptyNotSoDumpty
NA 23 0 20y
What a muppet (me that is!). I did get close, but must be going mad! Cheers so much
0
Photo of james
NA 1.1k 313k 20y
If (Test1 = true) || (Test2 = true) Then _____MessageBox.Show("HelloWorld") Else _____MessageBox.Show("GoodbyeWorld") End If || = logical Or && = logical And