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