Article View: borland.public.cppbuilder.database.dbexpress
Article #54help in making dbexpress working.
From: annoyed-nimous
Date: Wed, 11 Jul 2007 06:20
Date: Wed, 11 Jul 2007 06:20
42 lines
3071 bytes
3071 bytes
Hi, 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
Technical Details
Message-ID:
<4694769a$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,c1f367c8daf88636,start X-Google-Attributes: gidfb4e2,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Date: Wed, 11 Jul 2007 14:20:00 +0800 From: annoyed-nimous <annoyed@nospam.com> User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.dbexpress Subject: help in making dbexpress working. Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 60.50.134.15 Message-ID: <4694769a$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1184134810 60.50.134.15 (10 Jul 2007 23:20:10 -0700) Lines: 42 Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 2924