ASP & MTS

[FelixV]

Hi All,
Which version of Microsoft ODBC driver is required to run MTS ? ( I am quite new to MTS)
I am getting "Driver Not Capable error" !! Any kind of help is appreciated.

My ASP code looks like this


%@ LANGUAGE='VBScript'
%@Transaction=Required%>
%Response.Buffer = True%

%

Dim ObjCon
Dim ObjRs
Dim ObjContext


Set ObjCon = server.CreateObject ("ADODB.Connection")
Set ObjRS = server.CreateObject ("ADODB.Recordset")
ObjCon.Open "UID=reserv_dv;PWD=reserv_dv;DSN=reservation_oca_dev"

ObjCon.Execute "Insert into Make Values (333, 'Acura', 'Y')"
ObjectContext.SetAbort

Response.Write "Done"

%

I am getting the following error

Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'

[Microsoft][ODBC driver for Oracle]Driver not capable

/Mtstest/mtstest.asp, line 20


Thanks

-Felix

[Rick Leinecker]

Make sure you install the latest MDAC version (2.1). It's on the universal CDs, or you can download from www.microsoft.com.