On Jun 30, 2005, at 2:03 PM, the wiper wrote:
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
This wont work
the " is the string terminator in RB
try
db.sqlexecute (" insert into test (test_1,test2) values ('a','b') " )
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
try it with
insert into test (test_1,test2) values ('a','b')
in the edit field
the problem is that SQL and RB both use quotes and you HAVE to make
sure that you get the right ones in place before things will work
_______________________________________________
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>
|