[GRASSLIST:3938] Re: mysql: Cannot open select cursor

[ivan marchesini]

Hi Radim

this is the answer....:

echo "select * from sentieri where cat = 1" | db.select
dbmi: Protocol error

it doesn't work...

but I tried to use postgreSQL and in this case I had not problems...
with postgreSQL, in fact, I can make a table without problems... and I
can insert attributes too....
with postgreSQL all is fine... but I would want to use mysql.... :-(

thanks....
ivan





Il ven, 2004-07-16 alle 11:37, ivan marchesini ha scritto:
> Dear users...
> I'm working on a debian testing....and grass57 
> 
> I have got a problem: 
> I connected grass57 with mysql:
> 
> db.connect driver=mysql database=tezio -p
> 
> and after I connected vector attribute to the same db:
> 
> v.database driver=mysql database=tezio -p
> 
> after this, I started v.digit and I created a new table using "settings
> -> table"
> 
> the table was succesfully created!!!
> 
> later, I started to digitize. When I stopped a window appeared saying:
> 
> New record was created.
> Cannot open select cursor:
> 'select * from sentieri where cat = 1'
> on database 'tezio' by driver 'mysql'
> 
> and on the v.digit panel I obtained this:
> 
> dbmi: Protocol error
> WARNING: Cannot open select cursor
> 
> I'm doing something wrong????
> 
> thank you very much for your attention!!!!
> 
> Ivan
> 
> 
> 
> 
>