SQL connection works for everything except objRS insert data into database

drew22299 posted this at 10:01 — 31st July 2007.

Joined: Mar 2006

I have changed the above to the following but it doesn't work, can you see why? Do you open the database connection in a different way when using mysql instead of ACCESS when using objRS? I have been trying to work this out for a few hours and still can't get it to work!

<?php
Dim Apples

Set Apples = Server.CreateObject("ADODB.Connection")

Conn = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=database; UID=user;PASSWORD=password; OPTION=3" 

Apples.Open(Conn)
?>

Dim I
Dim iRecordAdded
Dim iRecordCount

Dim objRecordset
Set objRecordset = Server.CreateObject("ADODB.Recordset")

objRecordset.Open "password", Conn, adOpenKeyset, adLockPessimistic, adCmdTable
__________________