no not yet.where i get solution for my problem
On Dec 29, 4:41 pm, "Flavio Stakoviak" <[email protected]> wrote: > Have you ever tried to use mysql specif dll? > > -- > Flavio Henrique Moura Stakoviak > DGTAF - Secretária da Fazenda > > > > On Mon, Dec 29, 2008 at 3:12 AM, nag <[email protected]> wrote: > > > hi Flavio , > > i tried with code wat you suggested above.but i'm getting following > > error. > > > ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt] > > 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 'Title,'x-zip-compressed'MIMEType,'PK \n\0\0\0\0\0ÏE > > ‰2\0\0\0\0\0\0\0\0\0\0\0\0 \' at line 1 > > > here is my code > > using (OdbcConnection myConnection = new OdbcConnection(connString)) > > { > > //OdbcConnection myConnection = new OdbcConnection > > (connString); > > const string SQL = "INSERT INTO PictureTable > > (Title,MIMEType,Image) VALUES (?Title,?MIMEType,?ImageData)"; > > OdbcCommand myCommand = new OdbcCommand(SQL, > > myConnection); > > > myCommand.Parameters.AddWithValue("? > > Title",TextBox1.Text.Trim()); > > myCommand.Parameters.AddWithValue("?MIMEType", > > MIMEType); > > byte[] imageBytes = new byte > > [fileUpload1.PostedFile.InputStream.Length]; > > fileUpload1.PostedFile.InputStream.Read(imageBytes, > > 0,imageBytes.Length); > > myCommand.Parameters.AddWithValue("? > > ImageData",imageBytes); > > > myConnection.Open(); > > myCommand.ExecuteNonQuery(); > > myConnection.Close(); > > } > > > On Dec 28, 12:17 am, "Flavio Stakoviak" <[email protected]> wrote: > > > hi nag, > > > > try this codes, then confirm if your column on server if mediumblob type: > > > > String connString = "Driver={MySQL ODBC 3.51 > > > Driver};Server=mysql9.servername.com;Database=xyz;user > > > id=kv;password=kv"; > > > OdbcConnection myConnection = new OdbcConnection(connString); > > > const string SQL = "INSERT INTO PictureTable > > > (Title,MIMEType,Image) VALUES (?Title, ?MIMEType, ?ImageData)"; > > > > OdbcCommand myCommand = new OdbcCommand(SQL,myConnection); > > > myCommand.Parameters.AddWithValue("?Title", > > > TextBox1.Text.Trim()); > > > myCommand.Parameters.AddWithValue("?MIMEType", MIMEType); > > > byte[] imageBytes = new byte > > > [fileUpload1.PostedFile.InputStream.Length]; > > > fileUpload1.PostedFile.InputStream.Read(imageBytes, 0, > > > imageBytes.Length); > > > myCommand.Parameters.AddWithValue("?ImageData", > > > imageBytes); > > > myConnection.Open(); > > > myCommand.ExecuteNonQuery(); > > > myConnection.Close(); > > > > -- > > > Flavio Henrique Moura Stakoviak > > > DGTAF - Secretária da Fazenda- Hide quoted text - > > - Show quoted text -
