FiveTech Support Forums

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



Any idea

Thanks,

Willy Hermans

Willy,

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

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

I've just tested it with Navicat.

The connection works fine.

Greetings
Willy

Willy,

> TABLE "tabel1"

Isn't there a typo ? "table1" ?

No tabel is just the dutch word for table

Greetings

Willy

ok

Please try using "localhost" in lower case or 127.0.0.1

After reinstalling MySQL and ODBC drivers the connection works

Thanks.

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

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.

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.

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



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]

Willy,

Please show us your code using "testpc"

Hello Antonio,

Here it is.




Greetings

Willy Hermans