MySQL Forums
Forum List  »  Microsoft Access

Cripes am I confused!!!
Posted by: Jim Rudnick
Date: July 29, 2004 02:46PM

I'm migrating a simple dbase from Access to mySQL4 by trying to copy the same exact functionality in the new mySQL dbase that I had in Access.

I was able to install it fine, I now own mySQLFront as well.

I created a new dbase in mySQLFront, and 2 tables. One table called security lists a users name and their assiged password as follows...

Name = Jim
PW = tvr


Name = David
PW = qqq

The second table I created is to hold the list of users who log in, a simple table with 3 cols...VisitorName, VisitorIP and VisitTimeDate. All items for both tables are varchars and everything has been properly saved.

The problem I face is as follows and it makes NO SENSE to me at all!!!

IF I log in as Jim/tvr, everything works properly. I can then go to mySQLFront and check the actual lists and seee that yup, I just logged in. Later I'll create an asp page to show the logins in a table.

But as soon as I try to use David/qqq -- the asp page errors out with this message..
"...Microsoft Cursor Engine (0x80040E21). Multiple-step operation generated errors. Check each status value..."

No matter what I do, I can NOT get it to accept any number of chars for that name greater than 3. That is, if I cut the name David to Dav, it works fine.

What have I done wrong and why wont mySQL accept a name of 5 chars when the field is certainly a varchar that says it will hold up to 255 chars???

I am confused here


Options: ReplyQuote

Written By
Cripes am I confused!!!
July 29, 2004 02:46PM
July 29, 2004 03:39PM
July 29, 2004 05:21PM
July 30, 2004 12:40AM
July 30, 2004 07:43AM
July 30, 2004 08:11AM
July 30, 2004 03:17PM
July 31, 2004 02:06AM
July 31, 2004 12:07PM
August 01, 2004 09:12AM
August 02, 2004 06:15PM
August 03, 2004 01:49PM
August 03, 2004 01:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.