If you're using MySQL 4.1 or higher, make sure the password is created
with the OLD_PASSWORDS functions, or start your server with the
--old-passwords command.
Sorry, i have explained my problem in a bad way. MySql server seems well
configured and if i try to connect via RB it works. For example
Private sub TestConnection
dim db as new mysqldatabase
// Configuration lines such db.port=3306, db.username = "test" ...
if db.connect = true then
db.sqlexecute (" insert into test (test_1,test2) values ("a","b) // THIS
WORK, via phpMyAdmin i see these values
db.commit
end if
if db.connect = true then
db.sqlexecute = EditField1.text // THIS WON'T. I tried to load several SQL
files, generated via PhpMyAdmin
msgbox (db.errormessage) // returns nothing :-(
end if
End sub
Thank you again.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|