------_=_NextPart_001_01C5B780.2082BAE4
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C5B780.2082BAE4"
------_=_NextPart_002_01C5B780.2082BAE4
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Dear sir/Madam
I am trying to connect MYSQL server using OTL 4.0
otl_connect db;
otl_connect::otl_initialize(); // initialize the
environment
try
{
db.rlogon("root/rootpwd [at] mysql");
}
but db.rlogon("root/rootpwd [at] mysql") function through the following
error
[DataDirect][ODBC XML driver][XML][Closed Integrator Base]Insufficent
connection
information available to connect to any underlying providers.
HY000
In command mode I could connect to MySQL server using root as user and
rootpwd as a password.
But through OTL I am not able to connect.
Windows Registry shows MySQL ODBC 3.51 Driver is available.
In VC++ I am linking the following libraries
kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib
advapi32.lib shell32.lib ole32.lib oleaut32.lib
uuid.lib odbc32.lib odbccp32.lib kernel32.lib user32.lib gdi32.lib
winspool.lib comdlg32.lib advapi32.lib
shell32.lib ole32.lib oleaut32.lib uuid.lib odbc32.lib odbccp32.lib
I am not sure whether I am missing any lib files. MySQL server running
on Windows machine is 4.0.24-nt
Actually I saw two dlls in windows\system32
1) myodbc3.dll
2) myodbc3S.dll
When I link the above lib files. I get the following error.
LINK : fatal error LNK1104: cannot open file "myodbc3.lib"
Error executing link.exe.
Please advice me. Also you can see SQL.log for more information.
Thanks
Krishna
------_=_NextPart_002_01C5B780.2082BAE4
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml [at] 01C5B7AE.3AA3C110">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>6 pt</w:DrawingGridHorizontalSpacing>
=
<w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEve=
ry>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Dear sir/Madam<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I am trying to connect MYSQL server using OTL =
4.0<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span>otl_connect db; <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span =
style=3D'mso-tab-count:1'> =
; </span><span
style=3D'mso-spacerun:yes'> =
</span>otl_connect::otl_initialize(); //
initialize the environment <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span =
style=3D'mso-tab-count:1'> =
; </span><span
style=3D'mso-spacerun:yes'> =
</span>try<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span>{ <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p; =
;
</span>db.rlogon("root/rootpwd [at] mysql");<o:p></o:p></span></font=
></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span>}<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>but <b style=3D'mso-bidi-font-weight:normal'><i
style=3D'mso-bidi-font-style:normal'><span =
style=3D'font-weight:bold;mso-bidi-font-weight:
normal;font-style:italic;mso-bidi-font-style:normal'>db.rlog on( "root=
/rootpwd [at] mysql")
<span style=3D'mso-spacerun:yes'> </span></span></i></b>function =
through the
following error<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><b =
style=3D'mso-bidi-font-weight:
normal'><i style=3D'mso-bidi-font-style:normal'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;mso-bidi-fon=
t-weight:
normal;font-style:italic;mso-bidi-font-style:normal'>[DataDi rect][ODBC =
XML
driver][XML][Closed Integrator Base]Insufficent =
connection<o:p></o:p></span></font></i></b></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><b =
style=3D'mso-bidi-font-weight:
normal'><i style=3D'mso-bidi-font-style:normal'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;mso-bidi-fon=
t-weight:
normal;font-style:italic;mso-bidi-font-style:normal'><span
style=3D'mso-spacerun:yes'> </span>information available to connect =
to any
underlying providers.<o:p></o:p></span></font></i></b></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><b =
style=3D'mso-bidi-font-weight:
normal'><i style=3D'mso-bidi-font-style:normal'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;mso-bidi-fon=
t-weight:
normal;font-style:italic;mso-bidi-font-style:normal'><span
style=3D'mso-spacerun:yes'> </span>HY000</span></font></i></b><b
style=3D'mso-bidi-font-weight:normal'><font size=3D2 face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;mso-bidi-fon=
t-weight:
normal'><o:p></o:p></span></font></b></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In command mode I could connect to MySQL server using =
<b
style=3D'mso-bidi-font-weight:normal'><i =
style=3D'mso-bidi-font-style:normal'><span
style=3D'font-weight:bold;mso-bidi-font-weight:normal;font-s tyle:italic;
mso-bidi-font-style:normal'>root</span></i></b> as user and <b
style=3D'mso-bidi-font-weight:normal'><i =
style=3D'mso-bidi-font-style:normal'><span
style=3D'font-weight:bold;mso-bidi-font-weight:normal;font-s tyle:italic;
mso-bidi-font-style:normal'>rootpwd</span></i></b> as a password. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>But through OTL I am not able to =
connect.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Windows Registry shows <span
style=3D'mso-spacerun:yes'> </span>MySQL ODBC 3.51 Driver is =
available. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In VC++ I am linking the following libraries =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'><i =
style=3D'mso-bidi-font-style:
normal'><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold;mso-bidi-font-weight:normal;font-style:ital ic;mso-bidi-f=
ont-style:
normal'><span style=3D'mso-spacerun:yes'> </span>kernel32.lib =
user32.lib
gdi32.lib winspool.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib
oleaut32.lib <o:p></o:p></span></font></i></b></p>
<p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'><i =
style=3D'mso-bidi-font-style:
normal'><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold;mso-bidi-font-weight:normal;font-style:ital ic;mso-bidi-f=
ont-style:
normal'><span style=3D'mso-spacerun:yes'> </span>uuid.lib =
odbc32.lib
odbccp32.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib
advapi32.lib <o:p></o:p></span></font></i></b></p>
<p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'><i =
style=3D'mso-bidi-font-style:
normal'><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold;mso-bidi-font-weight:normal;font-style:ital ic;mso-bidi-f=
ont-style:
normal'><span style=3D'mso-spacerun:yes'> </span>shell32.lib =
ole32.lib
oleaut32.lib uuid.lib odbc32.lib =
odbccp32.lib<o:p></o:p></span></font></i></b></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I am not sure whether I am missing any lib files. =
<span
style=3D'mso-spacerun:yes'> </span>MySQL server running on Windows =
machine
is 4.0.24-nt<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Actually I saw two dlls in </span></font><font =
face=3DArial><span
style=3D'font-family:Arial'>windows\system32 =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span><span style=3D'mso-spacerun:yes'> </span></span></font><font =
size=3D2
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>1)</span></font><font
size=3D2><span style=3D'font-size:10.0pt'> </span></font><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>myodbc3.dll =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span
style=3D'mso-spacerun:yes'> &nbs=
p;
</span>2) myodbc3S.dll</span></font><font face=3DArial><span =
style=3D'font-family:
Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>When I link the above lib files. I get the following =
error.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'><font =
size=3D2
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;
mso-bidi-font-weight:normal'><span =
style=3D'mso-spacerun:yes'>
</span><span =
style=3D'mso-spacerun:yes'> </span>LINK
: fatal error LNK1104: cannot open file =
"myodbc3.lib"<o:p></o:p></span></font></b></p>
<p class=3DMsoNormal><b style=3D'mso-bidi-font-weight:normal'><font =
size=3D2
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold ;
mso-bidi-font-weight:normal'><span
style=3D'mso-spacerun:yes'> =
</span>Error
executing link.exe.<o:p></o:p></span></font></b></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Please advice me. Also you can see SQL.log for more
information.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks<o:p></o:p></span></font></p>
<p class=3DMsoNormal><st1:place><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Krishna</span></font></st1:place><font =
size=3D2
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p=
>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
=00
------_=_NextPart_002_01C5B780.2082BAE4--
------_=_NextPart_001_01C5B780.2082BAE4
Content-Type: text/plain; charset=us-ascii
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
------_=_NextPart_001_01C5B780.2082BAE4--
