[RESOLVED] i have error saving in database

[brixx]

hello guys,

please help me to fix my problem.. i am trying to add record in my database in mysql.. i have this codes below:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
rs = New ADODB.Recordset
rs.Open("insert into employee values('" & txtid.Text & "','" & txtname.Text & "','" & txtaddress.Text & "','" & cmbgender.Text & "','" & DateTimePicker1. Text & "')", Mycon, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
MsgBox("save agad")
End Sub

when i run it an error shows like this:

System.Runtime.InteropServices.COMException was unhandled
ErrorCode=-2147217887
Message="ODBC driver does not support the requested properties."
Source="Microsoft OLE DB Provider for ODBC Drivers"

i don't know how to solve this because i used this code already in other project and it worked..

is anyone know how to solve this??

help. . . .

[DataMiser]

Sounds like you are using the wrong connection string.

Also you should be using ADO.Net rather than ADODB

[.paul.]

Sounds like you are using the wrong connection string.

Also you should be using ADO.Net rather than ADODB

as DataMiser said, use ADO.Net instead of the superceded ADODB

[Shaggy Hiker]

The best answer is certainly to get away from ADODB in favor of the newer, but if that is in someway impractical, then you're going to have to do a bit of detective work. Database errors like this can be rather opaque in that the error message doesn't really tell you what the problem is in a very specific sense. Something isn't supported, maybe, but what? Is it just a typo, or is one of your arguments wrong? You don't get much information about that.

Unfortunately for you, since ADODB is so dated, few people will have much experience with it in .NET. But you DO have some experience with it, since, according to you, this code worked in a different program. So, what is different between the two? Because that's where your problem lies. Are both programs on the same computer (and if not, is one on a 64-bit while the other is not)? Are you using the same arguments? Something has to be different or else both would behave the same.

[brixx]

i am currently using it here in my laptop means that this is not different bits (32 bit/64 bit) the first program i used is work, it is about adding and generating serialcode in database.. what i was edited here is only the names of table and columns.

anyway, how can i change it into ado.net connection?


thanks guys for reading my post.. thanks for helping also.. i am a new member here and a new student in vb.net

[DataMiser]

Instead of using the OLE DB driver he should be using a MySql driver. I would think that is the most likely candidate.

From a connection string I have used to connect to MySql using ADODB from Vb6

DRIVER={MySQL ODBC 3.51 Driver}

[geek648]

And whatever you do, beware of SQL Injection. The user could type in all sorts of nasty things in the text boxes that would end up as SQL commands. Use parameters instead.

[brixx]

guys, do i have to use the ado.net connection?

what line in my code should i change if i revise it into ado.net?

thanks..

[DataMiser]

You would change all of the lines related to database access.

[.paul.]

here's an ADO.Net example:

http://code.msdn.microsoft.com/acces...-with-2fed4cc1

[brixx]

guys i found the already the error.. it works now i just edit the connection string.. thanks for those who response to my post..