Setup a user or system datasource in the ODBC control panel and try a connect string
similar to:
"DSN=your_datasource;UID=root;PWD=rootpwd"
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 -----
From: Krishna Akkulu
To: myodbc@stripped
Sent: Monday, September 12, 2005 5:55 AM
Subject: Not able to connect MySQL using OTL
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
------------------------------------------------------------------------------
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=1
