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:
[defined]ish (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Browser Problem?!? POST forms and NN 4.0+ browsers (1997)
Bug Fix for wbrk??? (1999)
Loss in Form (1998)
a search based on ^(contains) (1998)
Multiple Newcarts (1996)
Formatting a .txt file (1998)
Bug or syntax error on my part? (1997)
Exclamation point (1997)
Gathering the values of matching fields in a database. (1998)
[ShowNext] (1997)
WebCatalog for guestbook ? (1997)
Claris HomePage messes up the code (1997)
switching users (1998)
[sendmail] and [formvariables] (1997)
Re1000001: Setting up shop (1997)
includes and cart numbers (1997)
emailer w/F2 (1997)
Logical and or in [hideif] (1997)