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:

2.0.1 new commands and contexts (1997) Re:2nd WebCatalog2 Feature Request (1996) New Plug-in and Type 11 errors (1997) Odd [math] behavior (2003) encrypt/decrypt password with authenticate (2002) # fields limited? (1997) [WebDNA] UTF-8 encoding issues (2010) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) PCS Frames (1997) Single Link browsing (1997) textarea question (1998) Multiple prices (1997) can WC render sites out? (1997) WebTen and WebCat (1997) [OT] (waaaay OT) further off topic than before (2004) Read and weep (2003) Problems with [Search] param - Mac Plugin b15 (1997) [createfolder] & [deletefolder] (1997) [WebDNA] maybe silly suggestion? [founditems] (2015) iis 4.0 (1997)