Robert, ADO seems to prefer blobs to be at the end of the select. Try the following to see if it works:
Select Picture, Questions, Answers FROM FAQ ORDER by OrderID Dennis -----Original Message----- From: Helpdesk3 ( Mid North Coast Internet ) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: Re: Provider error '80040e37' Will this help anyone? Set objRS = CreateObject("ADODB.RecordSet") =>objRS.Open "SELECT Questions, Answers, Picture FROM FAQ ORDER BY OrderID", Provider=MySQLProv;Data Source=DSN=database, 2 objRS.Close Set objRS = Nothing The Questions and Answers columns are the text/blobs. Picture is a varchar. OrderID is an int. Thanks again, Robert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
