Mr Dygi <dygimailNo@SPAMpoczta.fm> wrote in message news:<Xns94869FDF1F5C2dygimailpocztafm@127.0.0.1>. ..[color=blue]
> Five Cats <cats_spam@[127.0.0.1]> wrote in
> news:SI0o8iBwPjIAFwpU@[127.0.0.1]:
>[color=green]
> > Have you tested it by connecting & so on from a DOS box?[/color]
>
> I've installed it in DOS box and just learned some basics. Also tested it
> with:
>
> telnet localhost 3306
>
> It's great thing. I can now study basics operations on MySQL database
> without getting online.
>[color=green]
> > It is connecting to the service through a TCP port, as specified in the
> > my.ini file. Of course it might depend on what PHP commands you are
> > using - I'm assuming you are using the specific MySQL ones (see
> >
http://www.php.net/manual/en/ref.mysql.php). The entry for
> > mysql_connect makes it quite explicit it's connection via a TCP port
> > (the default is localhost:3306 but best see the manual page,
> >
http://www.php.net/manual/en/functio...l-connect.php), but if you are
> > using the ODBC functions then you would need an appropriate ODBC driver
> > installed. There is a big assumption on my part here, which is that you
> > *can* use ODBC to access a MySQL database - it's not mentioned in the
> > manual (
http://www.php.net/manual/en/ref.odbc.php) but I know there is a
> > driver and I've managed to use it to get data into Excel before now.
> > This could well be an assumption too far.[/color]
>
> I don't understand. I connect to MySQL like you said with mysql_connect and
> using localhost:3306. I have also installed ODBC driver, because of the
> instructions. I don't understand the part of the text about getting data
> into Excel.
>[color=green]
> > The manuals (MySQL & PHP) might be a useful download as well if you
> > don't already have them![/color]
>
> Yes, there are. I've both on my HDD. Helps very much. Especially tutorial
> for newbies ;--D
>
> ps
> For what is the ODBC Driver if I can connect to the MySQL database over
> TCP/IP? For what is it genetally? For connecting to the MySQL database
> without installed TCP/IP?[/color]
Hello Dygi,
You asked...
For what is the ODBC Driver if I can connect to the MySQL database
over
TCP/IP? For what is it genetally? For connecting to the MySQL database
without installed TCP/IP?
Some applications can connect to databases via their native
interfaces. However, other application are not so database specific.
Such applications--and I presume Excel is one of them--need a more
standardized way to connect. This is were ODBC comes into play. It is
an industry wide, standardized set of API calls that allow most,
mainstream applications to connect to most databases. Moreover, if you
develop applications against the ODBC spec, they are free to connect
to MySQL, PostgreSQL, Oracle, Ingres, and just about any other
relational database. Hence, ODBC introduces a degree of freedom.
Finally, I am not immediately familiar with the MySQL ODBC drivers.
Therefore, I'm not the one to tell you whether or not they make socket
(tcp/ip) or shared memory connections. I just know that the drivers my
company produces uses tcp/ip based connections.
Netrista Khatam
Technical Services Manager
OpenLink Software
http://www.openlinksw.com
Product Weblogs:
Virtuoso:
http://www.openlinksw.com/weblogs/virtuoso
UDA:
http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology