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@stripped [mailto:jbonnett@stripped]
> Sent: Wednesday, August 02, 2006 7:53 AM
> To: steve.orton@stripped; mnhong@stripped; myodbc@stripped
> 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@stripped]
> Sent: Thursday, 27 July 2006 12:11 AM
> To: Minnyo Hong; myodbc@stripped
> 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@stripped]
> Sent: Wed 7/26/2006 1:10 AM
> To: myodbc@stripped
> 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
> ============================================
>
>
>
>
