List:MySQL ODBC« Previous MessageNext Message »
From:Krishna Akkulu Date:September 12 2005 9:55am
Subject:Not able to connect MySQL using OTL
View as plain text  
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@mysql");
                }
but db.rlogon("root/rootpwd@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
 

Attachment: [text/html]
Attachment: [text/html]
Thread
Not able to connect MySQL using OTLKrishna Akkulu12 Sep
  • Re: Not able to connect MySQL using OTLByron Guernsey12 Sep