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:

    
  1. Re: WebDNA v6 & MySQL ( Stuart Tremain 2008)
  2. Re: WebDNA v6 & MySQL ( Paul Willis 2008)
  3. Re: WebDNA v6 & MySQL ( Stuart Tremain 2008)
  4. Re: WebDNA v6 & MySQL ( "Brian Boegershausen" 2008)
  5. Re: WebDNA v6 & MySQL ( Stuart Tremain 2008)
  6. WebDNA v6 & MySQL ( Stuart Tremain 2008)
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:

Configuring E-mail (1997) WebCatalog + WebMerchant 2.1 for Windows released (1998) formvariable funkyness (2000) Problems passing [SKU] with $Replace in 2.0 (1997) PSC recommends what date format yr 2000??? (1997) Setting up shop (1997) more remote admin questions (1998) WebCatalog can't find database (1997) testing if the field is empty (2000) Problems with shopping cart (1997) Comments in db? (1997) RE: Purchased cart being overwritten (1997) Buying sans cart (1997) ListFiles Bug (1998) Cart Question: The Epic Saga (1998) Feedback on new features (2000) Merchant and WebCat 3.0 (1998) Multiple FlushDatabases (2000) Country & Ship-to address & other fields ? (1997) What am I missing (1997)