Jump to content


This topic is now archived and is closed to further replies.


Invalid string or buffer length

Recommended Posts

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)\'




Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.