Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
ODBC - ODBC with the MySQL Connector/ODBC driver
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
ODBC driver 3.51.12 from within MS-Excel 2003

ODBC driver 3.51.12 from within MS-Excel 2003

2006-03-20       - By Paul van Bavel

 Back
I'm trying to use the latest ODBC driver 3.51.12 from within MS-Excel 2003.

Downloading, installing and configuring the ODBC driver works OK.

Using the Test en Diagnostics button indicate: "Success; connection was
made!



BUT . from within Excel I'm not able to correctly activate the ODBC driver.

I specify in the connection-tab "DSN=MySQL" (the name of my data source
name).

The next button leads me to connector/odbc dialog windows (here everything
is filled in: servername, username, password, databasename).

During ODBC configuration these parameters proved to be OK.

Now, after pressing the <OK> button, I get the following message.

By the way, the user value is different from the value specified in the
configuration (without the '@%' !!!!)

What am I doing wrong?









Paul van Bavel

Schoonhout 102,

4872 ME  Etten-Leur.

The Netherlands

T             +31 76 50 22 418,

M            +31 6 23 90 16 67

E-fax      +31 84 756 1904

E             paul.vanbavel@(protected)




<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:"Comic Sans MS";
  panose-1 (See http://ose-1.ora-code.com):3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0cm;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
span.E-mailStijl17
  {mso-style-type:personal-compose;
  font-family:Arial;
  color:windowtext;}
@(protected) Section1
  {size:595.3pt 841.9pt;
  margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=NL link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I&#8217;m trying to use the latest ODBC driver
3.51.12 from within MS-Excel 2003.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Downloading, installing and configuring the ODBC
driver works OK.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Using the Test en Diagnostics button indicate:
&#8220;Success; connection was made!<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>BUT &#8230; from within Excel I&#8217;m not able to
correctly activate the ODBC driver.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I specify in the connection-tab
&#8220;DSN=MySQL&#8221; (the name of my data source name).<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>The next button leads me to connector/odbc dialog
windows (here everything is filled in: servername, username, password,
databasename).<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>During ODBC configuration these parameters proved to
be OK.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Now, after pressing the &lt;OK&gt; button, I get the
following message.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>By the way, the user value is different from the
value specified in the configuration (without the &#8216;@%&#8217; !!!!)<o:p><
/o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>What am I doing wrong?<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><img width=509 height=126 id="_x0000_i1026"
src="cid:image002.jpg@(protected)"><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><st1:PersonName ProductID="Paul van Bavel" w:st="on"><font
size=1 face="Comic Sans MS"><span style='font-size:8.0pt;font-family:"Comic
Sans MS"'>Paul
van Bavel</span></font></st1:PersonName><font size=1 face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS"'><o:p></o:p></span></font><
/p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span style='font-size:
8.0pt;font-family:"Comic Sans MS"'>Schoonhout 102,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span style='font-size:
8.0pt;font-family:"Comic Sans MS"'>4872 ME&nbsp; Etten-Leur.<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span lang=DE
style='font-size:8.0pt;font-family:"Comic Sans MS"'>The Netherlands<o:p></o:p><
/span></font></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span lang=DE
style='font-size:8.0pt;font-family:"Comic Sans MS"'>T&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+31 76 50 22 418,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span lang=DE
style='font-size:8.0pt;font-family:"Comic Sans MS"'>M&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+31 6 23 90 16 67</span></font><span lang=DE><o:p></o:p></span></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span lang=FR
style='font-size:8.0pt;font-family:"Comic Sans MS"'>E-fax&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;
+31 84 756 1904&nbsp;<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=1 face="Comic Sans MS"><span lang=FR
style='font-size:8.0pt;font-family:"Comic Sans MS"'>E&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
paul.vanbavel@(protected)<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>