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 pointersI finally found the way to make it work.On windows:Using mysql command-line utilitymysql> show variables like 'old%';Returns this, notice old_passwords is off.+-----------------+-------+| Variable_name | Value |+-----------------+-------+| old | OFF || old_alter_table | OFF || old_passwords | OFF |+-----------------+-------+Nowmysql> set old_passwords = 1;Then test againmysql> 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.auServer Version: 5.1.23-rc-communityClient Version: 3.23.32Nitai, 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 pointersI finally found the way to make it work.On windows:Using mysql command-line utilitymysql> show variables like 'old%';Returns this, notice old_passwords is off.+-----------------+-------+| Variable_name | Value |+-----------------+-------+| old | OFF || old_alter_table | OFF || old_passwords | OFF |+-----------------+-------+Nowmysql> set old_passwords = 1;Then test againmysql> 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.auServer Version: 5.1.23-rc-communityClient Version: 3.23.32Nitai, 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:
customizing the color of user's pages (1997)
Summary search -- speed (1997)
apparent variable variable display? (2000)
Strange intermittent WebDNA problems Workaround (2008)
Autoreturn Submit? (1997)
Enhancement Request for WebCatalog-NT (1996)
Search a date field by month only... (1999)
Part 2 - [showif] if variable exists (1998)
Prevent multiple appends with Reload Button (1997)
[format 40s]text[/format] doesn't work (1997)
Bookmarked URL with cart (1998)
Thanks and Big News!!! (1997)
Image upload (2000)
is your webDNA site 'froogle' ready ??? (2003)
Hard Questions ? (1997)
WebCommerce: Folder organization ? (1997)
Cookie Crumble (1998)
$Replace with [founditems] (1997)
oops private message leaked into talk list (1997)
[isfolder] and [filename] (1997)