Not able to connect MySQL using OTL

------_=_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
=20
otl_connect db;=20
otl_connect::otl_initialize(); // initialize the
environment=20
try
{=20
db.rlogon("root/rootpwd@mysql");
}
but db.rlogon("root/rootpwd@mysql") function through the following
error
=20
[DataDirect][ODBC XML driver][XML][Closed Integrator Base]Insufficent
connection
information available to connect to any underlying providers.
HY000
=20
In command mode I could connect to MySQL server using root as user and
rootpwd as a password.=20
But through OTL I am not able to connect.
=20
Windows Registry shows MySQL ODBC 3.51 Driver is available.=20
=20
In VC++ I am linking the following libraries=20
kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib
advapi32.lib shell32.lib ole32.lib oleaut32.lib=20
uuid.lib odbc32.lib odbccp32.lib kernel32.lib user32.lib gdi32.lib
winspool.lib comdlg32.lib advapi32.lib=20
shell32.lib ole32.lib oleaut32.lib uuid.lib odbc32.lib odbccp32.lib
=20
I am not sure whether I am missing any lib files. MySQL server running
on Windows machine is 4.0.24-nt
=20
Actually I saw two dlls in windows\system32=20
1) myodbc3.dll=20
2) myodbc3S.dll
When I link the above lib files. I get the following error.
=20
LINK : fatal error LNK1104: cannot open file "myodbc3.lib"
Error executing link.exe.
=20
Please advice me. Also you can see SQL.log for more information.
=20
Thanks
Krishna
=20

------_=_NextPart_002_01C5B780.2082BAE4
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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">


charset=3Dus-ascii">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>





style=3D'tab-interval:.5in'>

Re: Not able to connect MySQL using OTL

------=_NextPart_000_000C_01C5B762.CEB16F20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Setup a user or system datasource in the ODBC control panel and try a =
connect string similar to:

"DSN=3Dyour_datasource;UID=3Droot;PWD=3Drootpwd"

If you want a DSN-less connection string, search the archives of the =
mailing list and you'll find information on specifying everything in the =
connect string.

Byron

----- Original Message -----=20
From: Krishna Akkulu=20
To: myodbc@lists.mysql.com=20
Sent: Monday, September 12, 2005 5:55 AM
Subject: Not able to connect MySQL using OTL=20


Dear sir/Madam

I am trying to connect MYSQL server using OTL 4.0

=20

otl_connect db;=20

otl_connect::otl_initialize(); // initialize the =
environment=20

try

{=20

db.rlogon("root/rootpwd@mysql");

}

but db.rlogon("root/rootpwd@mysql") function through the following =
error

=20

[DataDirect][ODBC XML driver][XML][Closed Integrator Base]Insufficent =
connection

information available to connect to any underlying providers.

HY000

=20

In command mode I could connect to MySQL server using root as user and =
rootpwd as a password.=20

But through OTL I am not able to connect.

=20

Windows Registry shows MySQL ODBC 3.51 Driver is available.=20

=20

In VC++ I am linking the following libraries=20

kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib =
advapi32.lib shell32.lib ole32.lib oleaut32.lib=20

uuid.lib odbc32.lib odbccp32.lib kernel32.lib user32.lib gdi32.lib =
winspool.lib comdlg32.lib advapi32.lib=20

shell32.lib ole32.lib oleaut32.lib uuid.lib odbc32.lib odbccp32.lib

=20

I am not sure whether I am missing any lib files. MySQL server =
running on Windows machine is 4.0.24-nt

=20

Actually I saw two dlls in windows\system32=20

1) myodbc3.dll=20

2) myodbc3S.dll

When I link the above lib files. I get the following error.

=20

LINK : fatal error LNK1104: cannot open file "myodbc3.lib"

Error executing link.exe.

=20

Please advice me. Also you can see SQL.log for more information.

=20

Thanks

Krishna

=20



------------------------------------------------------------ -------------=
-----



--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: =
http://lists.mysql.com/myodbc?unsub=3Dbyron@iglou.com
------=_NextPart_000_000C_01C5B762.CEB16F20--