--Boundary_(ID_g26wdpnQRa40ly4/b2K7AA)
Content-type: multipart/alternative;
boundary="Boundary_(ID_jBnSEHx3DgqlAASHnFIAyw)"
--Boundary_(ID_jBnSEHx3DgqlAASHnFIAyw)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
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 ' [at] %' !!!!)
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 [at] planet.nl
--Boundary_(ID_jBnSEHx3DgqlAASHnFIAyw)
Content-type: text/html; charset=US-ASCII
Content-transfer-encoding: 7BIT
<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 */
[at] font-face
{font-family:"Comic Sans MS";
panose-1: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;}
[at] page 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’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:
“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> </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 … from within Excel I’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
“DSN=MySQL” (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 <OK> 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 ‘ [at] %’ !!!!)<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> </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 [at] 01C64C05.F0C83D40"><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> </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> </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 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
+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
+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
+31 84 756 1904 <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
paul.vanbavel [at] planet.nl<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> </o:p></span></font></p>
</div>
</body>
</html>
--Boundary_(ID_jBnSEHx3DgqlAASHnFIAyw)--
--Boundary_(ID_g26wdpnQRa40ly4/b2K7AA)--
