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

and

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 guys...help?

Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
Cripes am I confused!!!
4482
July 29, 2004 02:46PM
2671
July 29, 2004 03:39PM
2839
July 29, 2004 05:21PM
2511
July 30, 2004 12:40AM
2819
July 30, 2004 07:43AM
2473
July 30, 2004 08:11AM
2550
July 30, 2004 03:17PM
2520
July 31, 2004 02:06AM
2530
July 31, 2004 12:07PM
2608
August 01, 2004 09:12AM
2512
August 02, 2004 06:15PM
2523
August 03, 2004 01:49PM
2665
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.