Question about access to MySQL through MyODBC on Linux.
Question about access to MySQL through MyODBC on Linux.
am 26.07.2006 07:10:59 von Minnyo Hong
------=_NextPart_000_000D_01C6B0BD.54DB8D20
Content-Type: text/plain;
charset="ks_c_5601-1987"
Content-Transfer-Encoding: quoted-printable
=20
Hello, My name is Minnyo Hong from South Korea.
I¡¯m a kind of system architect and a database programmer.
Actually this is the first time to use MySQL.
=20
Now I do feasibility test of MySQL and Linux for my application.
I need to access MySQL database on Linux using C++ program compiled by =
gcc.
I think that I can access My SQL using MyODBC but I don¡¯t know how.
Can you tell me any useful information for that?
(Any Examples or Web sites¡¦)
=20
Actually, in MySQL manual, you have examples about .NET, C# , VB and
Windows(In Connector Part, chapter 23).
But you don¡¯t have any example on Linux, Unix.
=20
OR, is there any other way to access MySQL on Linux not using ODBC?
=20
I¡¯m sorry to bother you.
=20
Thank you.
=20
=20
Minnyo Hong
=20
==================== =====3D=
===================3D
Take a second. Make a difference!!
=20
È«¹Î³à (Minnyo Hong)
=20
MiCS Team, ENG2
Satrec Initiative Co., Ltd.
=20
http://www.satreci.com
==================== =====3D=
===================3D
=20
------=_NextPart_000_000D_01C6B0BD.54DB8D20--
RE: Question about access to MySQL through MyODBC on Linux.
am 26.07.2006 16:40:59 von steve.orton
Hello,
To connect to a mysql server from anywhere, you can use the mysql API's =
connect call. It has arguments for user, password, database and host. =
So as long as your client can see the machine your mysql server is =
running on, you will be able to connect.
I could be wrong, but I think you'll find that connecting via the API =
will give you better performance that going through a ODBC connection.
Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
-----Original Message-----
From: Minnyo Hong [mailto:mnhong@satreci.com]
Sent: Wed 7/26/2006 1:10 AM
To: myodbc@lists.mysql.com
Subject: Question about access to MySQL through MyODBC on Linux.
=20
=20
Hello, My name is Minnyo Hong from South Korea.
I'm a kind of system architect and a database programmer.
Actually this is the first time to use MySQL.
=20
Now I do feasibility test of MySQL and Linux for my application.
I need to access MySQL database on Linux using C++ program compiled by =
gcc.
I think that I can access My SQL using MyODBC but I don't know how.
Can you tell me any useful information for that?
(Any Examples or Web sites.)
=20
Actually, in MySQL manual, you have examples about .NET, C# , VB and
Windows(In Connector Part, chapter 23).
But you don't have any example on Linux, Unix.
=20
OR, is there any other way to access MySQL on Linux not using ODBC?
=20
I'm sorry to bother you.
=20
Thank you.
=20
=20
Minnyo Hong
=20
==================== =====3D=
===================3D
Take a second. Make a difference!!
=20
??? (Minnyo Hong)
=20
MiCS Team, ENG2
Satrec Initiative Co., Ltd.
=20
http://www.satreci.com
==================== =====3D=
===================3D
=20
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg
RE: Question about access to MySQL through MyODBC on Linux.
am 02.08.2006 00:53:23 von jbonnett
The reason that there are no examples for accessing MySQL from C++ is
that MySQL is written in C and so access is native. No intermediate
technologies like ODBC, .NET connectors etc. are needed. You just need
libmysql.dll. Section 25.2.3 in the MySQL manual has what you need.
John Bonnett
-----Original Message-----
From: Orton, Steve [mailto:steve.orton@ngc.com]=20
Sent: Thursday, 27 July 2006 12:11 AM
To: Minnyo Hong; myodbc@lists.mysql.com
Subject: RE: Question about access to MySQL through MyODBC on Linux.
Hello,
To connect to a mysql server from anywhere, you can use the mysql API's
connect call. It has arguments for user, password, database and host.
So as long as your client can see the machine your mysql server is
running on, you will be able to connect.
I could be wrong, but I think you'll find that connecting via the API
will give you better performance that going through a ODBC connection.
Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
-----Original Message-----
From: Minnyo Hong [mailto:mnhong@satreci.com]
Sent: Wed 7/26/2006 1:10 AM
To: myodbc@lists.mysql.com
Subject: Question about access to MySQL through MyODBC on Linux.
=20
=20
Hello, My name is Minnyo Hong from South Korea.
I'm a kind of system architect and a database programmer.
Actually this is the first time to use MySQL.
=20
Now I do feasibility test of MySQL and Linux for my application.
I need to access MySQL database on Linux using C++ program compiled by
gcc.
I think that I can access My SQL using MyODBC but I don't know how.
Can you tell me any useful information for that?
(Any Examples or Web sites.)
=20
Actually, in MySQL manual, you have examples about .NET, C# , VB and
Windows(In Connector Part, chapter 23).
But you don't have any example on Linux, Unix.
=20
OR, is there any other way to access MySQL on Linux not using ODBC?
=20
I'm sorry to bother you.
=20
Thank you.
=20
=20
Minnyo Hong
=20
==================== =====3D=
===================3D
Take a second. Make a difference!!
=20
??? (Minnyo Hong)
=20
MiCS Team, ENG2
Satrec Initiative Co., Ltd.
=20
http://www.satreci.com
==================== =====3D=
===================3D
=20
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg
RE: Question about access to MySQL through MyODBC on Linux.
am 02.08.2006 02:28:26 von Minnyo Hong
Thank you for your reply.
I think it is the best way to use MySQL APIs to connect MySQL.
There are reasons I need to use ODBC.
1. I need to build an application to connect to several DBMSs with minimize
changing source codes.
2. MySQL APIs are stars with 'mysql_' so they are dependent to MySQL.
3. I need to reuse my source codes to connect several DBMSs.
According to your reply, I guess MyODBC does not have standard C++ or C ODBC
functions. It looks like MyODBC supports C#, VB, and Java not C or C++.
Am I right? I need to clear this.
Thank you.
Minnyo Hong
-----Original Message-----
From: jbonnett@sola.com.au [mailto:jbonnett@sola.com.au]
Sent: Wednesday, August 02, 2006 7:53 AM
To: steve.orton@ngc.com; mnhong@satreci.com; myodbc@lists.mysql.com
Subject: RE: Question about access to MySQL through MyODBC on Linux.
The reason that there are no examples for accessing MySQL from C++ is
that MySQL is written in C and so access is native. No intermediate
technologies like ODBC, .NET connectors etc. are needed. You just need
libmysql.dll. Section 25.2.3 in the MySQL manual has what you need.
John Bonnett
-----Original Message-----
From: Orton, Steve [mailto:steve.orton@ngc.com]
Sent: Thursday, 27 July 2006 12:11 AM
To: Minnyo Hong; myodbc@lists.mysql.com
Subject: RE: Question about access to MySQL through MyODBC on Linux.
Hello,
To connect to a mysql server from anywhere, you can use the mysql API's
connect call. It has arguments for user, password, database and host.
So as long as your client can see the machine your mysql server is
running on, you will be able to connect.
I could be wrong, but I think you'll find that connecting via the API
will give you better performance that going through a ODBC connection.
Steven J Orton
Software Engineer
Northrop Grumman Mission Systems
-----Original Message-----
From: Minnyo Hong [mailto:mnhong@satreci.com]
Sent: Wed 7/26/2006 1:10 AM
To: myodbc@lists.mysql.com
Subject: Question about access to MySQL through MyODBC on Linux.
Hello, My name is Minnyo Hong from South Korea.
I'm a kind of system architect and a database programmer.
Actually this is the first time to use MySQL.
Now I do feasibility test of MySQL and Linux for my application.
I need to access MySQL database on Linux using C++ program compiled by
gcc.
I think that I can access My SQL using MyODBC but I don't know how.
Can you tell me any useful information for that?
(Any Examples or Web sites.)
Actually, in MySQL manual, you have examples about .NET, C# , VB and
Windows(In Connector Part, chapter 23).
But you don't have any example on Linux, Unix.
OR, is there any other way to access MySQL on Linux not using ODBC?
I'm sorry to bother you.
Thank you.
Minnyo Hong
============================================
Take a second. Make a difference!!
??? (Minnyo Hong)
MiCS Team, ENG2
Satrec Initiative Co., Ltd.
http://www.satreci.com
============================================
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
Re: Question about access to MySQL through MyODBC on Linux.
am 02.08.2006 09:11:22 von Martin.Evans
Minnyo Hong wrote:
> Thank you for your reply.
>
> I think it is the best way to use MySQL APIs to connect MySQL.
> There are reasons I need to use ODBC.
>
> 1. I need to build an application to connect to several DBMSs with minimize
> changing source codes.
> 2. MySQL APIs are stars with 'mysql_' so they are dependent to MySQL.
> 3. I need to reuse my source codes to connect several DBMSs.
>
> According to your reply, I guess MyODBC does not have standard C++ or C ODBC
> functions. It looks like MyODBC supports C#, VB, and Java not C or C++.
>
> Am I right? I need to clear this.
Look for myodbc - it is an odbc driver for mysql.
ODBC is a C API so accessing from C++ is fine.
Martin
> Thank you.
>
> Minnyo Hong
>
>
> -----Original Message-----
> From: jbonnett@sola.com.au [mailto:jbonnett@sola.com.au]
> Sent: Wednesday, August 02, 2006 7:53 AM
> To: steve.orton@ngc.com; mnhong@satreci.com; myodbc@lists.mysql.com
> Subject: RE: Question about access to MySQL through MyODBC on Linux.
>
> The reason that there are no examples for accessing MySQL from C++ is
> that MySQL is written in C and so access is native. No intermediate
> technologies like ODBC, .NET connectors etc. are needed. You just need
> libmysql.dll. Section 25.2.3 in the MySQL manual has what you need.
>
> John Bonnett
>
> -----Original Message-----
> From: Orton, Steve [mailto:steve.orton@ngc.com]
> Sent: Thursday, 27 July 2006 12:11 AM
> To: Minnyo Hong; myodbc@lists.mysql.com
> Subject: RE: Question about access to MySQL through MyODBC on Linux.
>
>
> Hello,
> To connect to a mysql server from anywhere, you can use the mysql API's
> connect call. It has arguments for user, password, database and host.
> So as long as your client can see the machine your mysql server is
> running on, you will be able to connect.
> I could be wrong, but I think you'll find that connecting via the API
> will give you better performance that going through a ODBC connection.
>
>
> Steven J Orton
> Software Engineer
> Northrop Grumman Mission Systems
>
>
>
> -----Original Message-----
> From: Minnyo Hong [mailto:mnhong@satreci.com]
> Sent: Wed 7/26/2006 1:10 AM
> To: myodbc@lists.mysql.com
> Subject: Question about access to MySQL through MyODBC on Linux.
>
> Hello, My name is Minnyo Hong from South Korea.
> I'm a kind of system architect and a database programmer.
> Actually this is the first time to use MySQL.
> Now I do feasibility test of MySQL and Linux for my application.
> I need to access MySQL database on Linux using C++ program compiled by
> gcc.
> I think that I can access My SQL using MyODBC but I don't know how.
> Can you tell me any useful information for that?
> (Any Examples or Web sites.)
> Actually, in MySQL manual, you have examples about .NET, C# , VB and
> Windows(In Connector Part, chapter 23).
>
> But you don't have any example on Linux, Unix.
> OR, is there any other way to access MySQL on Linux not using ODBC?
>
> I'm sorry to bother you.
>
> Thank you.
> Minnyo Hong
> ============================================
> Take a second. Make a difference!!
> ??? (Minnyo Hong)
> MiCS Team, ENG2
>
> Satrec Initiative Co., Ltd.
> http://www.satreci.com
> ============================================
>
>
>
>
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org