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:

form data submission gets truncated (1997) off topic - dna snipets (1997) all records returned. (1997) [WebDNA] Clarifying talklist emails (2020) [SQL Connect] (2007) [Announce] DNAAds v1.0 (2003) select menus & database design (1998) [random] only for 1-100??? (1997) Why don't my carts expire (1998) Javascript help (2003) Another pair of eyes?? (2006) price totals (2003) [LOOKUP] (1997) Limitations on fields? Server is crashing (1997) Summing fields (1997) Error Log.db --however (1997) Click-through/Referral tracking solution needed (2000) Secure server question (1997) Cyberstudio and WebDNA (1997) [SHOWIF AND/OR] (1997)