SHOW FIELDS or DESCRIBE COLUMN FIELD Problem

Hello all, I'm trying to use either the SWOW FIELDS or DESCRIBE TABLE COLUMN queries so that I can interate the structure of my tables using ADO/MyODBC in VB and I never get Columns that are either TIMESTAMP or Auto_Increment. I've tried using the OpenSchema method of the ADO Connection object

SHOW FIELDS using ADO/VB?

Hello Everyone, I'm trying write a small Dump application to Dump a MySQL DB similar to MySQLDump.exe because I don't like shelling out to the exe (DOS windows showing, etc.). However, on some tables, I get an EOF before it reached the end. Anyone ever do this? Thanks, Lee

Installing MySQL on Linux Mandrake

I've loaded Linux for the first time on a PC and wondered if I could get some advise on setting up MySQL on it. I would like to start off with the easiest/simplest method. Is that installing from an RPM? Is there an RPM for the latest stable version? Thanks In Advance, Lee Jenkins

Restoring from Bin Log on Windows

store from the logs. If you know, please let me know. Thank you in advance, Lee Jenkins

In need of urgent Advise, please

Hello, First, sorry the lengthy post. I have a couple of questions that are very important for me to get answered. I we moved from using MS Access to MySQL for our Point of Sale app. We do the transaction rollbacks, commits in the application layer so the fact that MySQL lacks this

Startup Params for MySQL on small Network?

that I can have a good starting point to experiment with. ADV(Thanks)ANCE, Lee Jenkins

Restore from Logs?

be greatly appreciated as I am in a crunch. Lee Jenkins

MySQL on Win2K Prof.

ist. What setting are (if any) can be tweeked to better handle that type of activity? Any help would be greatly appreciated. Lee Jenkins

Special Characters in INSERT Statement

represents the ascii character 0. INSERT INTO MyTable (ThisNumber) VALUES ('23302220202X') ...Creates the syntax error. Any help would be appreciated. Lee Jenkins

GROUP BY Aggregate Funtion?

predicate? Lee Jenkins - 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

OLE DB Provider?

ADO with the MyODBC provider works great. (A world better than Access DB's). I've seen a couple of more proprietary interfaces, but was hoping for something that would come from the MySQL team to ensure that it would be around for some time? Any Idea? Lee Jenkins

RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

Is there a Windows version for InnoBase yet? Lee -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 8:03 AM To: [EMAIL PROTECTED] Subject: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x Hi,

Get error message Test sometimes then daemon crashes

Hi all. Sometimes (usually after using MySQLFront) I get a Windows message box that says "Test", then the daemon crashes. Any ideas? Lee Jenkins General Operations DataTrak Business Solutions 910-326-4181 mailto: [EMAIL PROTECTED] (Email) http://www.datatrakpos.com http://www.datat

Suggestion on File Server Running MySQL

Access DB back-end. I would appreciate it very much if I could get some suggestions on hardware (is the above sufficient for a small LAN using MySQL?) and the parameters I should consider for the MySQL Daemon running on the Win2K Box. We're installing the NT Service. ADV(Thanks)ANCE, Lee Jenkins

MySQL NT Service Question

) that our application that was talking to it would hang alot. It's a small network using TCP/IP over NetBEUI with a Win2K Box in the back with 128 MB RAM/PIII 666 MHz. When I un-installed the MySQL NT Service (3.23 Gamma) the problem disapeared. Any Ideas (other than stop using MS Access)? Lee

Help with Query Syntax?

, servers.ServerLast, deliverycustomers.CustomerPhone, orders.OrderTime WHERE Orders.OrderType = 'Delivery' AND (Orders.OrderStatus = 'Open' OR Orders.OrderStatus = 'PreAuth') ORDER BY OrderTime; Any help would be greatly appreciated. Lee Jenkins

RE: MySQL-Front

Yes, I've tried many as well and like MySQL Front the best. lee -Original Message- From: Jose Ostos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 12:20 PM To: MySql List Subject: Re: MySQL-Front Of the diferent tools I have tried, I have found this one to be very

INSERT INTO Statement

Hi all, I trying to insert values from one table into another table, but keep getting an error that the columns don't match. Do I have to select from the one table in the same order that the columns are in the table I'm trying to insert into? Lee Jenkins General Operations DataTrak Business

RE: INSERT INTO Statement

... FROM oldtable; Regards Quentin -Original Message- From: Lee Jenkins [mailto:[EMAIL PROTECTED]] Sent: Monday, 22 January 2001 10:40 To: MySQL Mail list Subject: INSERT INTO Statement Hi all, I trying to insert values from one table into another table, but keep getting an error

RE: Windows ME / 2000 VB problem with BIGINT data type

of MyODBC. Thanks, Laszlo - Original Message ----- From: "Lee Jenkins" [EMAIL PROTECTED] To: "MySQL Mail list" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 3:30 PM Subject: RE: Windows ME / 2000 VB problem with BIGINT data type With your VB App, are you using D