List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:March 6 2000 11:02pm
Subject:Re: Using MS Access 97/2000 with MySQL and MyODBC driver
View as plain text  
THANK YOU THANK YOU!!! =)  That has been a pain in my side for weeks now =)

Graeme
----- Original Message -----
From: "miguel solórzano" <miguel@stripped>
To: <mysql@stripped>
Cc: <mysql_all@stripped>
Sent: Friday, March 03, 2000 9:00 PM
Subject: Using MS Access 97/2000 with MySQL and MyODBC driver


> 03/03/2000 22:17:37
>
> Some users of MS Access has found problems with the columns
> of the types date, time and timestamp. To resolves this problem
> the tip there is in the DSN file setup.
>
> The setup form of MyOBC driver will be fill as follows:
>
> Windows DSN name   <the name that you wants ie: mytest>
>
> MySQL host (name or IP)   <ie: 192.168.0.1>
>
> MySQL database name   <the name of your MySQL database ie: mydb>
>
> User  <the name of the user used on the GRANT TABLES>
>
> Password  <password of the user above>
>
> Port (if not 3306)  <left blank if you are using the default port>
>
> On the options that affects the behavior of MyODBC,  you must click the
two options below:
>
> Return matching rows
> Use manager cursors (exp)
>
> The last two option resolves the problem.
>
> Regards
> Miguel
>
> +----------------------------------------------------------------------+
> | TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Miguel A. Solórzano         |
> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:miguel@stripped     |
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     São Paulo - Brazil          |
> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
> |             /*/             \*\                Developers Team       |
> +----------------------------------------------------------------------+
>
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread30042@stripped
>
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-GraemeD=uu.net@stripped>
>
>

Thread
Using MS Access 97/2000 with MySQL and MyODBC drivermiguel4 Mar
  • Re: Using MS Access 97/2000 with MySQL and MyODBC driverGraeme B. Davis7 Mar
Re: Using MS Access 97/2000 with MySQL and MyODBC driverChristopher R. Jones4 Mar