Invalid string or buffer length

[lenmor]

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?