help in making dbexpress working.
annoyed-nimous
First off, I applogize if this is not the right place to post questions
about Turbo C++ Explorer, I can't seem to find a dedicated group for
TC++ here.
I am working on a non-profit project for a school, so I have totally 0
budget for the project, thus I have chosen to use TC++ EXP since it is free.
Now my problem is I can't seem to make dbExpress to connect to the MySQL
server I'm using for the project. I searched the net for information,
and found out that dbExpress doesn't work with MySQL 4.1.7 or higher,
fine, I downgrade my MySQL server to 4.0.20, which rumour has it that it
is working with dbExpress. However, I found out that although I can
connect to the MySQL database, I couldn't acess any of the tables or
whatever. When I dropped a TSQLDataSet on the form and try to build an
SQL query, there is no tables shown on the query builder. If I tried to
type in the query manually like "SELECT * FROM user_table", it gives me
an error "dbExpress Error: [0x0003] Invalid Field Type" upon activating
the DataSet. Same thing happend when I tried with a TSQLQuery.
I have searched the net and found out many people are unable to use
dbExpress regardless of what version of MySQL they use. Likewise, none
of them get any answer or solution from Borland. So, is this dbExpress
included in TC++ EXP just a joke from Borland (a bad one, the joke, I
must say), or is there really any way to make it work?
Please don't suggest to me to use any third party component that
requires payment, as I said, I'm working on this project as a charity
for a school and I, as an individual, can't affort to pay for the
components.
Any feedback (especially an official one - I'm really interested to know
what Borland is going to say regarding this non working dbExpress and
how are they going to solve the problem, something that I really wish to
hear, based on the void-ness I've found through my serch on the net -
this may help me in deciding if I want to upgrade to Pro for TC++ or
switch to other IDE from a more responsible and reliable company, when I
have a profitable job) would be welcomed, and thanks in advance.
regards,
Annoyed-nimous
Bob Swart
> type in the query manually like "SELECT * FROM user_table", it gives me
> an error "dbExpress Error: [0x0003] Invalid Field Type" upon activating
> the DataSet. Same thing happend when I tried with a TSQLQuery.
Perhaps one of the fields is unrecognised? Have you tried a query like
SELECT FIELD FROM user_table
where FIELD is one actual field that exists? See if that works, and that
keep on adding fields until you find the one which is of a type which
may be invalid (or not supported).
> So, is this dbExpress included in TC++ EXP just a joke from Borland
No more than your complaint is.
For some more entirely free information on database development with
Turbo C++, see http://www.drbob42.com/examines/examin83.htm
> this may help me in deciding if I want to upgrade to Pro for TC++ or
> switch to other IDE from a more responsible and reliable company, when I
> have a profitable job) would be welcomed, and thanks in advance.
Good luck!
> regards,
> Annoyed-nimous
Groetjes,
Bob Swart
--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
Delphi 2006 Courseware PDF manuals at http://www.eBob42.com/courseware
annoyed-nimous
Thanks for the reply, Bob.
> Perhaps one of the fields is unrecognised? Have you tried a query like
>
> SELECT FIELD FROM user_table
>
> where FIELD is one actual field that exists? See if that works, and that
> keep on adding fields until you find the one which is of a type which
> may be invalid (or not supported).
Okay, I tried your suggestion, but it seems this would not work at all,
even on a table with only one field, of type varchar(10) which I named
the field 'user_id'.
oh and by the way, I contacted one of my friends who is using C++Builder
6 Pro, and the dbExpress in that version is working fine with my
database (via remote connection).
>> So, is this dbExpress included in TC++ EXP just a joke from Borland
>
> No more than your complaint is.
Okay, I admit that comment only come from the frustration of unable to
find any official solution which is a responsibility of Borland, to me
it seems Borland had been acting mum on this problem, no explaination,
no solution, nothing.
annoyed-nimous
very educational, it is not talking about how to solve the problem of
the dbExpress. You are assuming I have no experience in how to use
dbExpress, but as a metter of fact, I'm not a total noob about
dbExpress. I have been working in a software studio with C++Builder 6.0
Enterprise for 2 years. Now I have left that company but I still have
access to dbExpress in C++Builder 6.0 Pro, from my friend that I
mentioned earlier. That version of dbExpress (which uses dbexpmysql.dll
as it's library) is working fine with the MySQL version 4.0.20 which I
am using now.
I tried replace the SQL Library in TC++ Explorer, which is dbxmys30.dll
by copying the library files from my friend's PC, and replacing the
LibraryName property of the component. I could connect to the server and
display the table, do a query on the database tables with TSQLQuery, no
problem at all. Amazing isn't it? Now since the databasr opened with
TSQLQuery is unidirection, I have to use TSQLDataSet. This TSQLDataSet
will not work with the older dbexpmysql.dll. I give all sorts of error
such as Operation Not Supported and Invalid Data Translation.
If you are not aware of the problem, please do a search on Google with
the keywords "dbExpress, Invalid Data Translation", and you'll see how
serious this is. Or perhaps you could try downloading TC++ Explorer
(It's free and 650MB at most) and experience the buggy, non working
dbExpress first hand. You will understand why I think it is a bad joke
the first place.
I have done extensive research on this problem, I googled for answer, I
visited many discussion groups and I have been to Code Gears, and
Borland's support site, looked at their knowledgebase, checked their
pending problems at the customer support site. Nothing. Absolutely
nothing. The only viable solutions now are using 3rd party components
such as products from CoreLab or free solutions, or more precisely, a
huge detour, by using MySQL ODBC connector, which, I have to ask, what's
the point of using MySQL if I have to in the end resort back to BDE, an
already discontinued and almost obsolete component?
Borland is acting like this problem never exists. This is a major bug in
their release and so far, TC++ Explorer has been out almost one year and
they have been either still oblivious about such serious bug (MySQL
support is totally not working), or they are trying to act like they are
oblivious. That's why I have been reluctant to come to this Borland
Newsgroup for an answer, since I doubt the officials will give me an
answer. My posting here is a sign of I'm desperate and try to find
myself a last reason to stay with Borland's product, before I finally
jump to other IDE.
So, is there any way to solve this problem NOW, or any version of MySQL
that is confirmed working with this dbxmys30.dll(the one they actually
tested their dbExpress with and confirmed it is working before they
release TC++ Explorer....oh wait, could it be they have never tested
their new dbExpress library? They just changed the code and compile it
and release, WITHOUT ACTUALLY TESTING THE DLL???)? Or I have to wait for
Borland to finally wake up? I guess making the jump and learn to use a
new IDE and a whole new set of language and programming API is less
painful than to wait for Borland. C# looks nice and there is a free C#
IDE from a much more reliable and helpful company out there.
regards,
Anooyed-nimous.