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:
Math (1997)
off-topic: SMS interface? (2001)
[OT] (waaaay OT) further off topic than before (2004)
Displaying text and populating form fields ... (2005)
Separate SSL Server (1997)
WebCatalog Hosting (1996)
[search] resources (2000)
is sku a REQUIRED field on NT (1997)
ShowNext (1997)
writefile to create static pages (2003)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Extended [ConvertChars] (1997)
How does WebCatalog search the database? (1997)
Sorting Numbers (1997)
Search in 2 or more catalogs (1997)
Bug Report, maybe (1997)
Re2: frames & carts (1997)
[OT] Quick Java Question (2007)
Dang... Sorry, WebDNA server not running (again)? (2003)
Smith Micro - no competition (2000)