Re: WebDNA v6 & MySQL
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70001
interpreted = N
texte = Thanks to Nitai for the pointers I finally found the way to make it work. On windows: Using mysql command-line utility mysql> show variables like 'old%'; Returns this, notice old_passwords is off. +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | old | OFF | | old_alter_table | OFF | | old_passwords | OFF | +-----------------+-------+ Now mysql> set old_passwords = 1; Then test again mysql> show variables like 'old%'; The return should now indicate on +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | old | OFF | | old_alter_table | OFF | | old_passwords | ON | +-----------------+-------+ Now when I test my code I get a positive response from my WebDNA. Host: www.idfk.com.au Server Version: 5.1.23-rc-community Client Version: 3.23.32 Nitai, once agin thanks for pointing me in the right direction :) On 02/04/2008, at 11:07 PM, Stuart Tremain wrote: > MySQL v5.1.23 if that makes any difference. > > > On 02/04/2008, at 11:02 PM, Stuart Tremain wrote: >> Windoze2003 server >> >> I have installed MySQL and can connect to it remotely using >> MySQL Administrator & MySQL Query Browser >> >> Queries are returned OK >> >> When I try using WebDNA I get >> >> "ERROR: MySQL DATABASE CONNECTION FAILED!" >> >> Here is my code: >> >> [SQLConnect >> dbType >> = >> MySQL >> &host >> = >> www >> .idfk >> .com.au&database=test&uid=myuserid&pwd=mypassword&conn_var=conn1] >>
>> | Host: | [SQL_HOST] |
>> | Server Version: | [SQL_SERVERVER] |
>> | Client Version: | [SQL_CLIENTVER] |
>>
>> [/SQLConnect] >> >> These are the same userid & password that I am using with the admin >> & query browser. >> >> What am I doing wrong? >> >> Thanks ! >> >> Stuart Tremain >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list
. >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > > >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks to Nitai for the pointers I finally found the way to make it work. On windows: Using mysql command-line utility mysql> show variables like 'old%'; Returns this, notice old_passwords is off. +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | old | OFF | | old_alter_table | OFF | | old_passwords | OFF | +-----------------+-------+ Now mysql> set old_passwords = 1; Then test again mysql> show variables like 'old%'; The return should now indicate on +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | old | OFF | | old_alter_table | OFF | | old_passwords | ON | +-----------------+-------+ Now when I test my code I get a positive response from my WebDNA. Host: www.idfk.com.au Server Version: 5.1.23-rc-community Client Version: 3.23.32 Nitai, once agin thanks for pointing me in the right direction :) On 02/04/2008, at 11:07 PM, Stuart Tremain wrote: > MySQL v5.1.23 if that makes any difference. > > > On 02/04/2008, at 11:02 PM, Stuart Tremain wrote: >> Windoze2003 server >> >> I have installed MySQL and can connect to it remotely using >> MySQL Administrator & MySQL Query Browser >> >> Queries are returned OK >> >> When I try using WebDNA I get >> >> "ERROR: MySQL DATABASE CONNECTION FAILED!" >> >> Here is my code: >> >> [SQLConnect >> dbType >> = >> MySQL >> &host >> = >> www >> .idfk >> .com.au&database=test&uid=myuserid&pwd=mypassword&conn_var=conn1] >> >> | Host: | [SQL_HOST] |
>> | Server Version: | [SQL_SERVERVER] |
>> | Client Version: | [SQL_CLIENTVER] |
>>
>> [/SQLConnect] >> >> These are the same userid & password that I am using with the admin >> & query browser. >> >> What am I doing wrong? >> >> Thanks ! >> >> Stuart Tremain >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > > >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Verifying both name and password (was: New Problem) (1997)
External RAID (2005)
[WebDNA] TCPConnect example doesn't work (2017)
Cancel Subscription (1996)
Re:Copyright ? (1997)
Logical and or in [hideif] (1997)
[WebDNA] DE/local problem? Database file could not be found or opened (2011)
Can't test the beta (2000)
RE: Can't get appendfile to work (1997)
[shownext max (1997)
Text Variabels Not Passed To Include (2002)
[shownext] and descending order (1997)
problems with 2 tags (1997)
Tcp Connect and the disappearing page (2000)
taxTotal, grandTotal (1997)
Removing [showif] makes a big difference in speed (1997)
interesting Unix bug (2000)
WebDNA Writer Needed (1997)
Date fun with MySQL (2004)
problem: mail changed (1997)