I think either table engine would be OK but InnoDB has some good extra
features and is the default in recent versions of MySQL so I would go
with that.
Now about your connection problem
You need to check the following things in this order.
Can you get to the server machine on the network? Pi
I don't quite understand your question. I assume you are interested in
the MySQL database engine. The latest production version of MySQL should
be fine for this, running on suitable hardware.
The server would not actually be VB6 but I assume you mean that there
may be some head office clients writ
I'm not sure MSDE is meant to replace Jet. Jet is still fine as a small
desktop database. MSDE is probably one of the best kept secrets M$ has. It's
a very capable database engine a bit nobbled so M$ can continue to collect
revenue from full SQL Server licenses. It is supposed to be the same code
b
Jet
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: Saturday, 11 October 2003 4:50 PM
To: Director General: NEFACOMP; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: what's the database behind m$ access?
That works, Emery. Thanks a lot.
Dummy me, I was wrong. Seems tha
You can't have two tables in the UPDATE query, at least not in v3.x of
MySQL. I'm not sure about version 4. That's why it's complaining about
table2. I think the SUBSTRING_INDEX should be OK.
You may have to split your query into a series of queries. There is some
guidance in the MySQL manual.
Jo
I would have thought that in a well designed 3rd normal form database there
would not be much worth grtouping in the rows. Even 1st normal form tries to
ensure there is nothing to group in the rows.
This isn't an early April Fool thing is it?
John Bonnett
-Original Message-
From: DiAnNe
I would be suspicious that the problem is with ADO or the underlying COM
technology. The maximum size of a string in VB is 64K. Perhaps the largest
field size ADO can pass back is similarly limited?
John Bonnett
-Original Message-
From: deep kapasi [mailto:[EMAIL PROTECTED]]
Sent: Tuesda