Hi,

I am trying to insert data into mysql with asp. But i get an error code 0185-Missing default property. I know the asp is connecting to mysql database because if i ask an query to obtain a result, i get some result.

I think my question is what property do i need to set up to allow me to insert data to an mysql table.

I am using mysql-4.0 and myodbc-3.5.

I tried looking the problem up on the internet but i did not find any approriate solutions for it.

Any advice will be helpful. Thanks in advance

Dim objConn, strSQL

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=mysql_dsn"

strSQL = "Some sort of insert statement"

objConn.Execute strSQL

I am not too sure about that error code, but it could be referring to either the connection string or the insert statement. So two things come to mind:

This code is for MS SQL, but it should be the same for MySQL, or at least pretty close.

One:
Try setting up the connections something like this

sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Drive:\Path\NameOfDatabase;" '


Set rs = Server.CreateObject("ADODB.RecordSet")
Set cnn=Server.CreateObject("ADODB.Connection")
cnn.open sDSN

Two:
Check that you have matching field-value pairs in the insert statement and that they are correct for the table column type

sSQL = "INSERT INTO TableName(Field1,Field2) VALUES ('"&Var1&"','String')"
cnn.Execute(sSQL)

HTH

Bill

Another possibility is that a field in the database is requiring a value but you are not sending one in with the SQL. In MS SQL I get a similar error if I insert into a table that I forgot to set auto increment on my primary key.

MtnMinded

This is an error that is commonly seen when you are trying to access an Access database via ASP that is already open in Access (heh?). Do you have the database open and are trying to test your code at the same time?