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]