I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
/cart.asp, line 112
I have tried changing the datatypes but still got problems.
here is the table causing the error:
CREATE TABLE `orderdetails` (
`orderdetailID` bigint(20) NOT NULL auto_increment,
`orderID` bigint(100) NOT NULL default \'0\',
`productID` bigint(20) NOT NULL default \'0\',
`name` varchar(50) default NULL,
`brand` varchar(20) default NULL,
`price` float(10,0) default NULL,
`quantity` bigint(20) default NULL,
PRIMARY KEY (`orderdetailID`),
KEY `orderID` (`orderID`),
KEY `productID` (`productID`)
) TYPE=InnoDB COMMENT=\'InnoDB free: 4096 kB; (orderID) REFER surffx/orders(orderID)\'
Anyone?