[Gambas-user] Error : MySQL

[Leo Barnhoorn]

Hello Nigel,

Thanks a lot. it works very well now.

Regards,
Leo.

On Wednesday 21 July 2004 21:27, Nigel Gerrard wrote:
> Leo,
>
> Okay I missed something when adding the multitable ability within the
> driver...not realising that . is a valid character in field names.
> Attached is a diff file that should be applied:
>
> cd ./src/lib/db/mysql
> copy the attachment main.c.diff to this area.
> patch main.c main.c.diff
>
> Now recompile:
> make
>
> change to root:
> make install
>
> I'll get Benoit to update the distribution.
>
> Nigel
>
> On Wed, 2004-07-21 at 14:01, Leo Barnhoorn wrote:
> > On Wednesday 21 July 2004 14:28, Nigel Gerrard wrote:
> > > Leo,
> > >
> > > Is 192.168.1.11 the same as the localhost or are you trying to connect
> > > to a different server?
> >
> > This IP 192.168.1.11 is from the computer i'am working on, this is a user
> > on IP 192.168.1.1 with MySQL Server, so i can connect to it.
> >
> > But GRANTS for leobarn at ...40... on MySQL on IP 192.168.1.1 is no problem
> > i get the information.
> >
> > > Does the user exist?
> >
> > The user exist, with Gambas version 0.94a no problem to get the GRANTS
> > for user leobarn at ...539...
> >
> > > Either use the Gambas Database Manager to check that
> > > leobarn at ...539... is there or
> > > from mysql: select host, user from mysql.user.
> >
> > The user is there also with Gambas Database Manager, when i do the query
> > with the Gambas Database Manager also een error.
> >
> > > If it is, then let me know. I am currently not in a position to link to
> > > a service running on another
> > > server at the moment.
> >
> > No problem for that, if you have time.
> >
> > > Nigel
> >
> > Regards,
> > Leo.
> >
> > > ----- Original Message -----
> > > From: "Leo Barnhoorn" <leo.barnhoorn at ...246...>
> > > To: <gambas-user at lists.sourceforge.net>
> > > Sent: Wednesday, July 21, 2004 11:59 AM
> > > Subject: [Gambas-user] Error : MySQL
> > >
> > > > Hello Nigel,
> > > >
> > > > I have a error on a query i do:
> > > >
> > > > Unknown field: Grants for leobarn at ...539...
> > > >
> > > > If i run the query SHOW GRANTS FOR leobarn at ...40... this works fine.
> > > > If i run the query SHOW GRANTS FOR leobarn at ...539... then gives
> > > > the
> > >
> > > error.
> > >
> > > > user at ...40... works fine.
> > > > user at ...540... numbers gives a error.
> > > >
> > > > Do you have a solution for me.
> > > >
> > > > Regards,
> > > > Leo.