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 a
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
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
how to restore from the logs.
If you know, please let me know.
Thank you in advance,
Lee Jenkins
how to restore from the logs.
If you know, please let me know.
Thank you in advance,
Lee Jenkins
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 functiona
ons would be greatly appreciated so that I can have a good
starting point to experiment with.
ADV(Thanks)ANCE,
Lee Jenkins
Any help would be greatly appreciated as I am in a crunch.
Lee Jenkins
than many people I've
seen posting on this list. What setting are (if any) can be tweeked to
better handle that type of activity?
Any help would be greatly appreciated.
Lee Jenkins
t;X" represents the ascii character 0.
INSERT INTO MyTable (ThisNumber) VALUES
('23302220202X')
...Creates the syntax error.
Any help would be appreciated.
Lee Jenkins
x27;s version of the TOP 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 PR
using 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
DESC order.
I've tried several ways, but keep getting errors that say I'm using illegal
group by functions, etc.
Any suggestions?
Lee Jenkins
-
Before posting, please check:
http://www.mysql.com/manual.php (
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, reader
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
ssional for the File
Server with MS 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
) 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)?
ers.ServerFirst,
servers.ServerLast, deliverycustomers.CustomerPhone,
orders.OrderTime
WHERE
Orders.OrderType = 'Delivery' AND (Orders.OrderStatus = 'Open'
OR Orders.OrderStatus = 'PreAuth') ORDER BY OrderTime;
Any h
Very, very cool. What will happen to the licensing and/or price for this
version?
Lee
-Original Message-
From: Britt Johnston [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 2:16 AM
To: Vinny; Mysql List
Subject: RE: OK, I'll bite
NuSphere announced Gemini a few months a
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
complet
Hi All,
Are there any switches to force MyODBC to do a "Silent" install?
Thanks,
Lee Jenkins
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
ECT col1, col2,
col3... 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
g
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
DataTra
MyODBC and ADO -- except for earlier
versions 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
With your VB App, are you using DAO or ADO? MS Access uses DAO to working
with ODBC while VB apps using ADO have problems with the MyODBC driver (at
least with me it did). I recently changed much code in my VB app to work
with MySQL from DAO to ADO. However, many methods aren't supported like
was hoping that I could get some advise on getting the data/tables into
the database from our end. Do we Telnet into the database? Any help would
be greatly appreciated.
Lee Jenkins
-
Before posting, please check:
http
26 matches
Mail list logo
