<HTML><BODY DEFANGED_STYLE="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hello,</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I am currently using Mac OS X 10.4.3 and GRASS 6.1.cvs. After having major problems using the MySQL driver in GRASS I have decided to try using unixODBC to connect GRASS to MySQL. However, I can not figure out how to call the DSN using db.connect and db.login. In short this is what I have been able to do:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><B>1. Downloaded the MySQL Connector/ODBC 3.51.12 for OS X</B></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> <FONT class="Apple-style-span" color="#00207C"> </FONT><A href="http://dev.mysql.com/downloads/connector/odbc/3.51.html"><FONT class="Apple-style-span" color="#0040F5">http://dev.mysql.com/downloads/connector/odbc/3.51.html</FONT></A></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><B>2. Used this web link to figure out how to configure a myodbc dsn on Unix</B></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> <A href="http://dev.mysql.com/doc/refman/5.0/en/dsn-on-unix.html"><FONT class="Apple-style-span" color="#003CE6">http://dev.mysql.com/doc/refman/5.0/en/dsn-on-unix.html</FONT></A></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">[I am not sure if I configured the myodbc DSN correctly. I am still not sure how to correctly manipulate the odbc.ini.]</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><B>3. I then went to the X11 terminal to change the database settings in GRASS and set them to use odbc driver. </B></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><B><I>db.login</I></B><I> driver=odbc database="host=localhost,dbname=GRASS2" user=root password="</I></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I> </I><B><I>db.connect </I></B><I>driver=odbc database=GRASS2 username=root</I></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I> Sorry, <username> is not a valid parameter</I></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I>GRASS 6.1.cvs (san_joaquin2):~ > </I><B><I>db.tables -p</I></B></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I>DBMI-ODBC driver error: SQLConnect():</I></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I>[unixODBC][Driver Manager]Data source name not found, and no default driver specified (0)</I></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I> </I></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">or I get this error</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I>GRASS 6.1.cvs (san_joaquin2):~ > </I><B><I>db.tables -p</I></B></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><I>DBMI-MYSQL driver error: mysql_real_connect() error (1044): Access denied for user ''@'localhost' to database 'grass2'</I></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I am not calling the DSN correctly. Any suggestions!!!</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Thank you,</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Nila Kreidich</DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Graduate Student Researcher</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">UC Davis Department of Hydrology</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; min-height: 14px; "><BR class="khtml-block-placeholder"></DIV></BODY></HTML>