First - always CC: the list for every response (I just click - REPLY TO
ALL - so I don't accidentally forget). In case I had become unavailable,
anyone else could have answered. This is mostly volunteer help here.
Hardly anyone that contributes to this list actually works for MySQL.
Second - the address 127.0.0.1 is a special address that always points to
just the machine you are on. It's known as the "local loopback address"
and every TCP/IP machine has it.
If your MySQL server is actually on the network it must have some address
other than 127.0.0.1. Unfortunately, only you can find out what that
address really is (it probably starts with 10.0.0. ). Once you figure out
what the server's ip addres really is, put that in your connection routine
and try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Umit tas" <[EMAIL PROTECTED]> wrote on 12/02/2005 10:19:06 AM:
> Error is:
>
> Runtime error '40003'
> server error detected.
> number:2003
> description: Can't connect to MySQL server on '127.0.0.1'(10061)
>
> my computer ip 10.0.0.3
>
> i'm trying host's ip adress('127.0.0.1' or computer ip:'10.0.0.2') and
>
> i'm created new user on MySQL('asd',pswrd:'123456',host:'10.0.0.2'(not
> localhost)
>
> but i can't do it
>
>
>
>
> >From: [EMAIL PROTECTED]
> >To: "Umit tas" <[EMAIL PROTECTED]>
> >CC: mysql@lists.mysql.com
> >Subject: Re: important! help plsss
> >Date: Fri, 2 Dec 2005 10:11:41 -0500
> >
> >"Umit tas" <[EMAIL PROTECTED]> wrote on 12/02/2005 04:59:15 AM:
> >
> > > hello i'm umit Tas;
> > >
> > > i have a problem.
> > >
> > > i'm writing programme in visual basic 6.0 but i must use MySQL
server.
> > >
> > > i'm installed MySQL server and executing my program (no problem) but
my
> > > problem is :
> > >
> > > MySQL must be installed "A" computer and my programme must be
installed
> >"B"
> > > computer
> > >
> > > in LOCAL area network :( pls help
> > >
> >
> >Having a MySQL server and its client programs on different machines is
> >probably the most common configuration. There is nothing wrong with the
> >setup you propose.
> >
> >What exactly is the problem you are having? What have you read? What
have
> >you tried? Which connection library are you using to connect your
program
> >to the server? What error messages are you getting?
> >
> >We need more information in order to help.
> >
> >Shawn Green
> >Database Administrator
> >Unimin Corporation - Spruce Pine
> >
>
> _________________________________________________________________
> Don’t just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
