ADO RDD connection error 16389

[Willy]

I have this error testing MS SQL and MySQL.

Is there a way to get more information of the error.

I have used this code with MySQL

Code: Select all  Expand view

#Include "FiveWin.Ch"
#include "adordd.ch"

REQUEST ADORDD

function TstMySql()

   USE test1 VIA "ADORDD" TABLE "tabel1" MYSQL ;
      FROM "LOCALHOST" USER "ROOT" PASSWORD ""

   Browse()

   USE

return nil


Any idea

Thanks,

Willy Hermans

[Antonio Linares]

Willy,

Try to connect to your database and table using an application like Navicat (www.navicat.com) and check if it works fine

[Willy]

Thanks Antonio,

I'll try it asap.

The MySQL that I use is a version with PHP. It has already a management system.

Is it possible that not all versions (i.e. version 5) are supported

Thanks

Willy Hermans

[Willy]

I've just tested it with Navicat.

The connection works fine.

Greetings
Willy

[Antonio Linares]

Willy,

> TABLE "tabel1"

Isn't there a typo ? "table1" ?

[Willy]

No tabel is just the dutch word for table

Greetings

Willy

[Antonio Linares]

ok

Please try using "localhost" in lower case or 127.0.0.1

[Willy]

After reinstalling MySQL and ODBC drivers the connection works

Thanks.

Willy

[Willy]

Now I've tried to connect from another pc.

This does still not work.

I've tried with the ip adres of the pc that holds the mysql server software.

I've tried with the networkname of the pc...

I've tried with "\\pcname\localhost" and so on.

What are exacly the possibilities for adressing the connection.

Thanks,

Willy Hermans

MS-SQL works already from a network pc

[Antonio Linares]

Willy,

> What are exacly the possibilities for adressing the connection

We don't know it for sure. ADORDD is just a layer that uses ADO. If ADO works then the ADORDD should work too.

[Willy]

Thanks Fernando,

I've done some tests.

There seems to be something wrong with the MySQL server.

I have reinstalled the server several times.

When I use EasyPhp 1.7 or 1.8 (This includes MySQL 5) the program works local but the server is not detected at another PC in the network.

I have used navicat and MySQL Administrator.

Maybe the MySQL server is automatically installed as a local server.
I can not find a setting to change that.

When I do'nt use EasyPHP but the usual MySQL 5 the program does not work on any pc. In that case I have a connection error but the server is detected on other pc's.

I think I have to search a forum for MySQL beginners.

Someone any idea ?

Thanks.

Willy.

[Willy]

I have just finished some tests.

1) Format C
2) Reinstall XP service pack 2
3) disable firewall
4) Install MySQL 5

run this code

Code: Select all  Expand view

#Include "FiveWin.Ch"

#include "adordd.ch"

REQUEST ADORDD

function TstMySql()

   USE test VIA "ADORDD" TABLE "tabel1" MYSQL ;
      FROM "localhost" USER "root" password "ikke"

*  USE test00 VIA "ADORDD" TABLE "ACCOUNTS" MYSQL ;
*     FROM "www.freesql.org" USER "myuser" PASSWORD "mypass"

   Browse()

   USE

return nil

This works fine on the pc were MySQL is installed. It does not work on any other pc.

So I changed "localhost" into "192.168.0.101" and "testpc" and "TESTPC"

This did not work on any pc. But the error is different
Now it is not a ADODB/Connection error but it is a
ADODB Recordset error.

With Navicat it was easy to open as "testpc" , "TESTPC" , "192.168.0.101"

Is it possible that this is not yet supported in ADORDD

Thanks,

Willy Hermans[/code]

[Antonio Linares]

Willy,

Please show us your code using "testpc"

[Willy]

Hello Antonio,

Here it is.

Code: Select all  Expand view

#include "adordd.ch"

REQUEST ADORDD

function TstMySql()

   USE test VIA "ADORDD" TABLE "tabel1" MYSQL ;
      FROM "testpc" USER "root" password "pas"

*  USE test00 VIA "ADORDD" TABLE "ACCOUNTS" MYSQL ;
*      FROM "www.freesql.org" USER "myuser" PASSWORD "mypass"

   Browse()

   USE

return nil

Greetings

Willy Hermans