Try turning the CAPs off first... Makes it easier to read... Second...
You are using ADOB to connect to mySQL? Is that what you are doing? Using ASP? Try using PHP, easier to learn and is much more compatible with mySQL. ASP/mySQL can be used, but it’s a pain, plus ASP has its limitation that is more limiting than PHP. I use to use ASP, but it sucks and a pain in the ass to configure and just to connect the database. Yes, Access has its limitations. You can use it, but your load would need to be light. Mysql is a very lightweight DB and barely uses any ram to run it. It is very, very fast (with PHP), and I prefer it over MS SQL server and Oracle, both which I have experience in. Does that help at all? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: IS THIS BETTER? ORIGINAL SUBJECT:HELLO (PLEASE READ THE ENTIRE EMAIL BEFORE DECIDING TO CHUCK IT, I DO GET TO MY QUESTION) GOOD AFTERNOON I THOUGHT I'D TRY MY LUCK AND ASK YOU A QUESTION, IF YOU CAN'T (OR WON'T) HELP MY I UNDERSTAND. I HAVE BEEN VISITING YOU SITE A LOT LATELY BECAUSE I HAD A PROBLEM THAT I THOUGHT I WAS ON THE VERGE OF SOLVING. (BACK STORY)---> I AM BUILDING A WEBSITE, AND I WANTED TO SPEND THE LEAST AMOUNT OF MONEY ON GETTING IT ON THE GOOD OL' WWW. SO SINCE I HAVE A FEW COMPUTERS I'D THOUGHT I COULD RUN IT MYSELF WITHOUT THE HELP OF ONE OF THOSE "WEB HOSTING" SERVICES. SO I STARTED WITH IIS WHICH HAS GOTTEN MY BASIC SITE UP, THEN I GOT TO KNOW A LITTLE ABOUT ASP (NOT REALLY I'VE BEEN USING FRONTPAGE THEY DO ALL THE WORK FOR YOU) AND I AM PRETTY GOOD WITH ACCESS SO I FIGURED IT WAS JUST A MATTER OF PUTTING THEM ALL TOGETHER. WELL.........I COULDN'T GET THE FORM TO CONNECT TO ACCESS(THEY WERE BUT THEY COULDN'T HANDLE THE LOAD) SO I WAS LOOKING INTO MS SQL SERVERS(WAY TO EXPENSIVE!!!) SO THEN I FOUND MYSQL(IT'S FREE!!!). GOT THE HANG OF IT A LITTLE AND CONVERTED MY ACCESS TABLES TO MY SQL'S. I FOUND YOUR WEBSITE, AND LEARNED HOW TO LINK BETWEEN ACCESS AND MYSQL SO I COULD USE ACCESS'S INTERFACE TO MAINTAIN THE FORMS AND QUERY'S FROM MY END(INSTEAD OF WITH THAT DOS INTERFACE), AND FRONTPAGE SEEMED TO ACKNOWLEDGE MY MYSQL DATABASE WHICH GAVE ME A MORE STABLE DATA ENGINE SOLUTION(OR SO I THOUGHT) I THOUGHT I WAS THERE UNTIL I TEST SUBMITTED SOME ASP FORMS,BUT THEN I GOT A TOTALLY NEW ERROR MESSAGE: -------------------------------------------------------- ------------------------ -----> "Cannot add new record set to the database Error Description: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Error Number: 3251 Error Source: ADODB.Recordset -------------------------------------------------------- ------------------------ NOW I HAVE HAD NO FORMAL TRAINING IN ANY OF THE FORE MENTIONED PROGRAMS, BUT I PICK THIS STUFF UP PRETTY GOOD (I THINK), AND I WAS WONDERING IF THERE'S JUST SOMETHING I'M LEAVING OUT OR ADDING WHEN I SHOULDN'T?? WHAT I'M I DOING WRONG!!! PLEASE HELP SINCERELY, > Your message cannot be postsed to mysql@ because it > contained an attachment. If you need to make a file publically available > you should upload it to some public URL, and then paste the URL into your > message instead of trying to send it to everyone on the list. > > Disallowing attachments protects our list from being used to > spread a virus. If you do not remember sending a message to the this list, > it is possible that your computer has been infected by a virus which tried > to spread itself using our list. It is also possible that some spammer used > your e-mail address to hide his identity. > > Some mail clients default to sending messages in HTML or multipart format. > In this case, your message will also appear as if it has an attachment. Such > message formats increase the volume of traffic, and cause readability problems > in some mail programs without providing any extra value. Such formats are > also frequently used by spammers. For these reasons we disallow such messages. > You should disable them in your mail program to be able to post. > > Your mail program was identified as 'Microsoft Outlook'. If this is correct, > you should do the following to > configure it to be able to post to our list: > > Tools->Options->Mail Format, set 'Send message in this format' to 'Plain Text' > > Please note that we may have misidentified your e-mail program, in which case > our instructions would not apply. It is also possible that we are not aware > of a version of that has a slighly different set of menus. If > our instructions are not helpful, please consult your e-mail program's manual > on how to send messages in plain text. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php