Recordset error after move to mySQL

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Recordset error after move to mySQL

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Recordset error after move to mySQL

Page: [1]

Matth

Posts: 36
From: Zurich, Switzerland
Status: offline

Recordset error after move to mySQL - 6/22/2001 17:01:00

Hi there

I have decided to move over to mySQL instead of using Access files as performance is not good enough with access.

A guestbook that worked just excellent with access is now returning this ugly error-message.

"ADODB.Recordset error '800a0cb3'

Object or provider is not capable of performing requested operation.

/guestbookt.asp, line 256 "

Line 256 says the following:

rs.absolutepage = currentPage

Is it possible that the mySQL ODBC driver does not understand this rs.absolutepage? Is there an equivalent for it?

If I comment this line out, I get all the records, but I can't page back and forth...

Thanks in advance.

Matthias


Spooky Posts: 26681 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Recordset error after move to mySQL - 6/23/2001 20:57:00 I assume no, but couldnt say for sure. Check the server has the latest ado drivers? Im not familiar with Unix admin. Perhaps also ask the driver question in "Servers" ------------------ §þððk¥ "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart (in reply to Matth)

Matth

Posts: 36
From: Zurich, Switzerland
Status: offline

RE: Recordset error after move to mySQL - 6/25/2001 20:02:00

Spooky

I'm not running on Unix. I have installed mySQL on my Win2000 server and it runs just fine. It's just this one thing that doesn't work.

Matthias

(in reply to Matth)


Spooky Posts: 26681 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Recordset error after move to mySQL - 6/25/2001 17:04:00 Either way, Im not sure how it interacts with NT or Unix. Ive had a quick scan of the documentation, but cant see anything. Using myOBDC? Latest ADO? It may be one for the mySQL newsgroup I think ------------------ §þððk¥ "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart (in reply to Matth)


jasjmorris Posts: 1 Joined: 7/21/2009 Status: offline	RE: Recordset error after move to mySQL - 7/21/2009 20:08:04 I am currently having this same problem. I moved from Access to MySQL and now get this error. i see this was back in 2001 is there any known solution?? (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP, PHP, and Database >> Recordset error after move to mySQL

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts