At 14:37 06/06/2001 +0200, ran wrote:
Hi,
When you have an issue involving:
client_application <> MyODBC <> MySQL
The best thing to do is to test the MyODBC and MySQL isolating
the client application. For example in your case of describe
table_name, I create a small table with the following structure:
mysql> describe mytest;
+-------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | char(50) | YES | | NULL | |
+-------+----------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
Then I built a DSN file, to test the same command using MyODBC
with the tool ODBCTE32.EXE shipped together with the MyODBC setup.
Below the result:
Get Data All:
"Field", "Type", "Null", "Key", "Default", "Extra"
"id", "int(11)", "", "PRI", <Null>, "auto_increment"
"name", "char(50)", "YES", "", <Null>, ""
2 rows fetched from 6 columns.
So I guess that the problem is your application or the machine
environment. Notice for example that VB doesn't support BIGINT
as column type on auto_increment.
Regards,
Miguel
>To MySql Team.
>
>I am trying mysql version 3.23.38 for win 2000 and linux.
>I use VB and VC++ to develop.
>There are 2 major problem i have encounter.
>
>1) If i ask for "describe [tablename]" into a Datagrid, I do not get the
>info back when the tables has an auto_increment field.
>
>2) I use ODBC to access the database.
> It talks about 2-3 seconds to open / update a recordset using the
> mysql for windows AND msql for linux.
> I do not know what is the problem, and why it takes me about 5
> seconds to open a recordset and update.
>
>I will appreciate it, if you will reply with an answer.
>
>
>P.S I used earlier version of mysql ( 1.6 i think ) for linux and These
>problems NEVER occur.
> there for i am sure that my code is correct ( i tried the same
> code on this DB)
>
>
>Best Regards
>
>Ran Salomon
>E-mail: [EMAIL PROTECTED]
>---------------------------------------------------
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ Developer
---------------------------------------------------------------------
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-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
