Databases :: MYSQL Database On ISP - INSERT Or UPDATE Procedure
May 4, 2010
Im hosting my site over at some ISP, and when i try to use INSERT or UPDATE procedure, i get this error : "SELECT command denied to user 'KidumMac'@'localhost' for table 'proc' "Which is really wired for two reasons:
A. In my code i don't reference whatsoever to the MySql databse, nor the "proc" table
B. In the myPHPadmin program the queries work just fine. Any insights?
the second problem is that when i try to import my database, the tables import fine, but when it gets to import the stored procedure, it tells me that the user needs SUPER PRIVILEGES for that. what is it ?
Before I get too far down the road I just want some advice. I'm building a web app using VWD2008 and MySQL 5. I've got the membership provider stuff working fine and have an odbc connection setup which works "fine". what I've noticed is that when I configure a new sqldatasource (that will be used to provide data to a listview or something) the Advanced -> generate Insert,Update..... option is disabled. I'm assuming its because of the sql syntax difference of the square brackets issue between MS SQL Server and MySQL.
Before I start writing all my own insert and update statements does anyone know if there is a way to get MySQL and VWD to talk the same language, maybe a different connector or something. I'm using mysql-connector-odbc-3.51.15
protected void Button3_Click(object sender, EventArgs e) { //Create a connection to the database MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********"); //open the connection conn.Open(); //MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie) MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn); // Update with new text cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value); cmd.Parameters.AddWithValue("?Information", TextBox1.Text); cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text); cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text); cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text); cmd.Parameters.AddWithValue("?Adress", TextBox5.Text); cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text); cmd.Parameters.AddWithValue("?Ort", TextBox7.Text); cmd.ExecuteReader(); conn.Close(); RefreshProfile(); }
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
is there ny data type of date which can hold the date only.....coz i have a field of date in which i have write date manually... i have taken the datatype as DateTime.... and its showing "incorrect datetime value"..
Actually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control
I'm developing an ASP.NET app with a MySQL backend, using the MySQL Connector Net 6.2.3. I have a DetailsView with an insert command that is throwing the error:MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?,?,?,?,?,?,?)' at line 1My code is:
[Code]....
If I hardcode values into the insert statement, it works fine. But when I put the ? placeholder in, it throws the error. Can anyone help me pinpoint the problem or offer a workaround solution?
i am having a transaction related problem regarding mysql.. need some advice how to proceed !!!
here is a gridview for my application and i am inserting or updating for each row.... like
[Code]....
well now what i want is if any of the row update or insert failes ... it should revert all the changes that was already made into the database ... even a single row update .. into that perticular table ... the code which i have called for payment.Update(PayDetails, 0) is :
[Code]....
can someone help me out how to proceed in this scenario ??? how do i undo each of the updates made into the table payment schedule details ...
I want to use MVC 2 with MySQL database. Is it possible?because my shared hosting limits the size of SQL Server database, but there is no limit on Size of MySQL database.MySQL seems to take less disk space than SQL Server database which is costly on the Internet.
I did all the instructions which are in the following link: [URL] in order to do a connection between MySQL database and ASP.NET but I did not successed. Sometimes, it told me that I have a mistake in the <asp: button> and sometimes it told me that I did a mistake in calling (addImage) method. And this is my whole code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="HW5._Default" %> <script> public class DataAccess { private string _strConn = @"Driver= {MySQLODBC 3.51 Driver};SERVER=localhost;DATABASE=test1;"; private OdbcConnection _objConn; public DataAccess() { this._objConn = new OdbcConnection(this._strConn); } // This function adds the Images to database public string addImage(timestamp id, byte [] data,string extension) { string strSql = "SELECT * FROM File"; DataSet ds = new DataSet("Image"); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds,"Table"); try { this._objConn.Open(); DataRow objNewRow = ds.Tables["Table"].NewRow(); objNewRow["Extension"] = extension; objNewRow["Data"] = buffer; objNewRow["ID"] = id; ds.Tables["Table"].Rows.Add(objNewRow); // trying to update the table to add the image tempAP.Update(ds,"Table"); }.....................................
I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':
First one will be: I've installed MySql, Query broswer, and ODBC connector (not sure what this one does. Can anyone explain?)
Now, when im dragging a new DataGridView into the form, and try to connect it to a MySql database, i can't seem to find MySql in the databases list... why is that?
Second question, assuming everything works fine, how can i upload the database to a server and use it there?
I can think of two problems trying to do this : (1) Im not sure where my Database files are stored at... (for some reason, they are not found in MySql/Data... this folder is completly absent)
(2) While working with ACCESS, all i had to do is to point the .aspx page that did the connecting to the location of the .mdb file, but now, each time i want to reach my database, i need to send the page to the server (localhost). How will i create a connection to my database, when its on another server, in the code page ? (small code example would be nice).
My employer is changing hosting providers.Our current hosting provider offers MSSQL which we use for the database used on our website. The host we are changing to is insisting that we switch to MySQL because they only offer an older version of MSSQL and are concerned about compatibility issues.I have absolutely no experience working with MySQL and am a novice with MSSQL as well. What is the best way for me to port a database from one to the other?I have downloaded MySQL and Workbench... I've also downloaded the .Net connector as a zip file but am not sure where to extract its contents.
How to place a MYSQL database in my ASP.NET site?In what format I produces the file to my APP_DATA database folder to place it.
How to build CONNECTION STRING to database located in APP_DATA.I created a site conncted with a LOCALHOST database.Now I want to import it into my website folder APP_DATA
I am using a simple Login function and need to record individual field values from MySQL database to compare with inputs.
My connection code:
Dim myConnection As MySqlConnection Dim myDataAdapter As MySqlDataAdapter Dim strSQL As String myConnection = New MySqlConnection("Database=mydatabase;Data Source=xx.xxx.xx.x;port=3362;UId=myID;Password=1234;") strSQL = "SELECT username,password FROM Login WHERE ID = '" & 1 & "'" myDataAdapter = New MySqlDataAdapter(strSQL, myConnection) myDataSet = New Dataset() myDataAdapter.Fill(myDataSet,"Login")
I have confirmed it is connecting by adding the following GridView.
I am trying to create dataset (.xsd) and link it with stored procedure in MySQL database. the problem is when i connect it it's changing the schema name. like if I have this stored procedure name or table name or whatever :
News.tbNews the builder it self change it to :
def.News.tbNews. MySql version 5.5.8, MySqlConnector 6.3.4 I searched for a solution for this problem and one of the answers was to change the MySqlConnector from 6.3.4 to 6.3.6 !!! I download the new connector 6.3.6 but it's giving me Error while installing it.
