Forums
This topic is locked
error '80004005' Invalid string or buffer length
Posted 30 Nov 2003 14:23:03
1
has voted
30 Nov 2003 14:23:03 Morten Lensberg posted:
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?
Replies
Replied 02 Feb 2006 16:02:05
02 Feb 2006 16:02:05 emadullah gawai replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
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?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
read this article
bugs.mysql.com/bug.php?id=13776
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?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
read this article
bugs.mysql.com/bug.php?id=13776