Hi,
Thank you for your reply.
After establishing a connection to the Database using ODBC API, can we
use the mysql API's like "mysql_query()" instead of using MyODBC API's.
Thanks in Advance.
Regards,
Narasimha
-----Original Message-----
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 11:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Connection using DSN
Hi.
See:
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
When you call mysql_real_connect you use mysqlclient library,
which connects to server directly (you don't need to configure ODBC).
To connect using DSN, you should use ODBC API. ODBC and MySQL
are completly different things. MySQL - database system, and
ODBC is an interface to interact with different databases.
[EMAIL PROTECTED] wrote:
>
>
>
> Hi,
> I would like to know how to connect to the mysql database using a
> DSN in mysql API's. I am using myodbc 3.51 driver.
>
> Used the following API code for the connection
>
> MYSQL *link =3D mysql_init(NULL);
> MYSQL *connectHandle =3D
> mysql_real_connect(link,"localhost","root","","test",0,NULL,0);
>
> But this is not having the option for specifying the DSN or Driver.=0D
> Please provide me the solution.
>
>
> Thanks,
> Narasimha
>
>
> Confidentiality Notice=0D
>
> The information contained in this electronic message and any
attachments to=
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential
or=
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro
or=
> [EMAIL PROTECTED] immediately
> and destroy all copies of this message and any attachments.
>
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
