World: r4wp

Arnold, I just know enough to get myself connected so these instructions 
might not be too good. As Endo and I are suggesting, perhaps you 
can only accept connections from 127.0.0.1 (localhost). So, you have 
to Grant privileges to the user from your IP. 

Go to http://whatismyipaddress.comand then click on "IP details." 
You will find "Hostname." It is that hostname that you will grant 
privileges to along with the user such as  [user'-:-'hostname]. I imagine 
right now it only accepts [user'-:-'localhost]

I guess my hosting provider is not supporting the GRANT options in 
database user screens and their supplied phpmyadmin. I think I have 
a trick on my sleeve though with a self installed phpmyadmin. No. 
More luck maybe tomorrow....

try to get support for that, they can easily do that.

Arnold look for "Prvileges" tab in phpMyadmin. BTW, what type of 
control panel do you have?

Hi I found something in the config.inc.php  file and documentation 
that says "$cfg['Servers'][$i]['AllowDeny']['order'] string
If your rule order is empty, then IP authorization is disabled."

There is a Plesk control panel where I can create databases and add 
users/passwords (but no GRANT options) and a webadmin which is a 
PHPMyAdmin screen, that is almost identical to my self installed 
phpMyAdmin 2.6.0-pl2

Most of the time the support of my provider is really good, I'll 
ask them too.

Arnold, so you have the same set-up as I do. Plesk as the main control 
panel and phpadmin (via Plesk and self-installed). It's within phpadmin 
that I am able to grant rights to my host's IP as described above. 
Before this, I had some sites that had cPanel and I did the granting 
from there.

James, what phpmydmin version is your self installed phpmyadmin?

I need to upgrade i think.

Upgraded to 3.5, but no privileges for users tab.

Where does open-proto come from in the mysql-protocol.r in the mysql 
driver from softinnov? Word has no value in the version I am using. 
Strange. No complaints when using the script from a location on my 
webspace, trouble when used to connect from my local machine to the 
web MySQL.

I still think that it is because your mysql server does not accept 
connections except localhost.

Did you try to connect your database using mysql command-line tools? 
or MySQL Workbench from a remote PC?

What version of mySQL are you using?

MySQL 5.0.45, Protocol version 10.

Endo, possible, still I expect the open-proto to be defined somewhere.

Arnold, I am using 3.4.5

And when you are in the "Home" Page, do you not have a "priviledges" 
tab?

That is correct. Just Databases, SQL, Status, Export, Import, Settings, 
Synchronize, Variables, Charsets, Engines.

Perhaps you can check the config file and make sure you are logged 
in as the admin.

Possibly the true admin is hidden by the plesk. I hope tomorrow I 
get an answer from my provider. Today is a holiday here, tomorrow 
a working day, just opposite to most of Europe.

you can connect from local and configure your server using SQL commands.
did you try TELNET to your server's 3306 port?

No, never used TELNET. tried to open a connection to the host. Timed 
out.

Agree with Maxim in the SDK discussion. The app itself was no problem 
but realising the connection to the external database to be managed 
by it is sending me back to TELNET. :)

Got an answer from the provider. connection not from the website 
are blocked for safetyreasons. Only reachable by scripts on the website. 
The "admin" user for adjusting tables etc is not the admin user for 
granting access etc to users.

Arnold, thanks for the update. At least you know now what the issue 
is.

This is not possible due to safety reasons
 "That is not the answer I wanted to hear" --no reaction :)

I am now going to experiment with interacting with a script on the 
website that can do what I want remotely. Talking about safety risks 
:)

if you are looking for a fultext/searchengine don't miss elasticsearch. 
scales well, based on lucene, very fast, simple to use.

the interesting part is the compact rest api the storage model and 
the number of different analysers, tokenizer (snowball, ngram, etc). 

you can use elasticsearch also as a standalone nosql database with 
rebol. speaks completly json. 

working currently with 1.2 m documents + datastorage on a single 
machine.  runs very smooth. 

evaluated other components before (sphinx, xapian, tokyo etc.) elasticsearch 
has it all and is much cleaner to handle than solr.

Thanks for the analysis Tomas.

About RebDB:
Is there a way to update multiple fields at the same time ?
I read in the documentation:

db-update/where my-table id 0 [id < 6]

This sets only one filed.

In rebdb.r file, db-update function takes columns parameter as word! 
or block! and says "Columns to set".
So I think it supports updating multiple columns at once.

db-update/where my-table [id colA colB] [0 "a" "b"] [id < 6] ;works

I have also read the 2.0.4 version supports JOINs but there is no 
example how to use it with db-* style commands

Do you know the way ?

I whish to use ODBC to manipulate ACCESS 2007 databases.

Where I could find some documentation about REBOL and ODBC and ODBC 
itself ?

Well, I didn't use it much, but I this works:

;create table tbl [a b c]
>> db-insert tbl [1 2 3]
>> db-select/joins [a b c] tbl [select [a c] from tbl] b
== [1 2 3 1 3]

Thanks Endo

Your are very helpful to me

for ODBC:
http://www.rebol.com/docs/database.html
http://www.connectionstrings.com

Yes, reading about REBOL. I was to quicky.

Well, the whole community was very helpful to me, now I'm trying 
be.

I have read in the REBOL3 world about incompatibility with ODBC in 
the latest icarnations. Do you know anything about this ?

I still use R2, didn't use R3 yet. Just a few tests etc.

As I know, there is no direct ODBC support in R3, but there is an 
ODBC extension which is stable if I'm not mistaken.

I meant "in the latest icarnations of ODBC"

BrianH and Kaj can answer more correctly about R3 && ODBC.

R2 and ODBC

R2 & ODBC is quite stable & useful.

There are just a few small problems which can be solved some work 
arounds.

such as, R2 doesn't support new SQL Server datatypes. You should 
CAST & CONVERT your values in your SQL to be able to get those values 
into R2 app.