Not able to connect MySQL using OTL

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()

Not able to connect MySQL using OTL

Not able to connect MySQL using OTL

2005-09-12 - By Krishna Akkulu

Back

Reply: 1 2

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@(protected)");
}
but db.rlogon("root/rootpwd@(protected)") 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

<html 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=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@(protected)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>

<div class=Section1>

Dear sir/Madam<o:p></o:p>

I am trying to connect MYSQL server using OTL 4.0<o:p></o:p>


<o:p> </o:p>

         
     
otl_connect db; <o:p></o:p>

     
          otl_connect::otl_initialize(); //
initialize the environment <o:p></o:p>

     
          try<o:p></o:p>

         
      
{ <o:p></o:p>

         
             
db.rlogon("root/rootpwd@(protected)");<o:p></o:p>

         
      
}<o:p></o:p>

but db.rlogon("root
/rootpwd@(protected)")
 function through the
following error<o:p></o:p>

<o:p> </o:p>

[DataDirect][ODBC XML
driver][XML][Closed Integrator Base]Insufficent connection<o:p></o:p>

 information available to connect to any
underlying providers.<o:p></o:p>

 HY000<o:p></o:p>

<o:p> </o:p>

In command mode I could connect to MySQL server using root as user and rootpwd as a password. <o:p></o:p>

But through OTL I am not able to connect.<o:p></o:p>

<o:p> </o:p>

Windows Registry shows  MySQL ODBC 3.51 Driver is available. <o:p
></o:p>

<o:p> </o:p>

In VC++ I am linking the following libraries <o:p></o:p>

 kernel32.lib user32.lib
gdi32.lib winspool.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib
oleaut32.lib <o:p></o:p>

 uuid.lib odbc32.lib
odbccp32.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib
advapi32.lib <o:p></o:p>

 shell32.lib ole32.lib
oleaut32.lib uuid.lib odbc32.lib odbccp32.lib<o:p></o:p>

<o:p> </o:p>

I am not sure whether I am missing any lib files.  MySQL server running on Windows machine
is 4.0.24-nt<o:p></o:p>

<o:p> </o:p>

Actually I saw two dlls in 
windows\system32 <o:p></o:p>

         
     
 1)
 
myodbc3.dll <o:p></o:p>

         
      
2) myodbc3S.dll<o:p></o:p>

When I link the above lib files. I get the following error.
<o:p></o:p>

<o:p> </o:p>

  
     LINK
: fatal error LNK1104: cannot open file "myodbc3.lib"<o:p></o:p>

        Error
executing link.exe.<o:p></o:p>

<o:p> </o:p>

Please advice me. Also you can see SQL.log for more
information.<o:p></o:p>

<o:p> </o:p>

Thanks<o:p></o:p>

<st1:place>Krishna</st1:place><o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)

Earn $52 per hosting referral at Lunarpages.