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

Code:
Dim objConn, strSQL

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

strSQL = "Some sort of insert statement"

objConn.Execute strSQL

Do you use any response object inbetween the code there?

_________________________
- Vijay G
Strive for Perfection