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:
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)