Re: [WebDNA] Cannot get WebDNA and MySQL working.

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112256
interpreted = N
texte = Results should look something like this: Info: Platform: unix-Macintosh OS X Product: WebDNA - Enterprise Edition Version: 6.2 Connected successfully SQLinfo reports: Host: localhost Server Version: 5.1.44 Client Version: 5.1.30 (Yes, I am still using WebDNA 6.2 on my Mavericks machine locally!) :-) On Apr 6, 2015, at 2:27 PM, Donovan Brooke wrote: > Keith,=20 > It=92s always good to be verbose when posting to a technical forum=85 = posting code, mysql version, etc... >=20 > Couple of things.. > ODBC only works with the older (and confusing) [SQL] contexts... = (those tags should be changed to [ODBC], and also checked over to make = sure they are still robust.. anyway=85) >=20 > If you are testing locally.. plant this template on your server and = copy / past the results back to the list. >=20 > *** CHANGE below to your actual password. ********* >=20 > =97=97=97=97=97=97START TEMPLATE=97=97=97=97=97=97=97=97=97=97 > > > >  > MySQL test > > > Info:
> Platform: [platform]
> Product: [product]
> Version: [version]

>=20 >=20 > [SQLconnect = dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dro= ot&pwd=3D&conn_var=3Dconn1] > Connected successfully

> [/SQLConnect] >=20 > SQLinfo reports: > [SQLinfo conn_ref=3Dconn1] > Host: [SQL_HOST]
> Server Version: [SQL_SERVERVER]
> Client Version: [SQL_CLIENTVER]
> [/SQLinfo] >=20 > > > =97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97 >=20 >=20 >=20 >=20 >=20 > On Apr 6, 2015, at 7:01 AM, Keith Scarzafava = wrote: >=20 >> Thanks for trying Stewart. >>=20 >> I am just trying to connect directly, not with iSQL. I installed = the unixODBC setup with MySQL initially because I was following what I = had found documentation wise at WebDNA and used ISQL just to verify I = had a working DSN. Since, I couldn=92t get it to work, I posted on the = WebDNA forums and Chris said to try here and pointed me back to the same = documentation I was already reading. I suspect it must be something to = do with WeDNA and CentOS then. =20 >>=20 >>=20 >>=20 >> Thanks for the assist. >>=20 >> Keith >>=20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au]=20 >> Sent: Sunday, April 05, 2015 7:15 PM >> To: WebDNA Talk List >> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> Keith >>=20 >> What I sent was all that I do. >>=20 >> Maybe Chris can confirm a few things about WedBNA=92s connection to = MySQL. >>=20 >> Other things to look at: >>=20 >> Does WebDNA return anything about MYCONNECTION not being found ? >>=20 >> Are you using a standard port (3306)? >>=20 >> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from = WebDNA, your setup may have a problem with going via ISQL. I also use = TSQL successfully to connect with MS SQL databases, unfortunately = working with MS SQL is not the same as working with MySQL via WebDNA. >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >> On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >>=20 >> Thanks Stewart!=20 >>=20 >> I gave your example a try. I was doing pretty much the same thing = with a basic query. I think my is I am not able to make the = connection to MySQL which is on the same server. I can connect with PHP = locally and remote just fine. Is there anything I need to do tell WebDNA = I am using MySQL other than the SQLCONNECT statement? >>=20 >> I am using the developer edition versions to see if this is the = route I wish to go. =46rom what I read, it=92s supposed to support = MySQL. Is this accurate? >>=20 >> Thanks for your time! >> Keith >>=20 >>=20 >> From: Keith Scarzafava [mailto:keith@scarzafava.com]=20 >> Sent: Saturday, April 04, 2015 8:21 PM >> To: talk@webdna.us >> Subject: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> I=92ve been trying to get my WebDNA to connect to MySQL and have not = been able to do so with version (6.2 with Centos5) or version (8.0 with = Centos6). I posted in the regular forums and was advised to try here. = Basically, I started out on my 6.2 WebDNA server and followed the setup = directions for the DSN setup which, I can connect to my MySQL via a DSN = with isql and perform queries and such. If I try to use WebDNA, I get = the error: MySQL not supported. If I tried to use the SQLCONNECT method = I get the error: INVALID VALUE (MySQL) FOR PARAMETER: type. >>=20 >> After a couple of postings in the forums, I was told I don=92t need = to use the DSN method because WebDNA supports MySQL natively (though I = tried both method). I then figured, I would give it a try on my version = 8 WebDNA server and, I still am getting the same exact messages. I=92ve = been sifting through any postings I can find and I can=92t find any form = of resolution. >>=20 >> Any help is greatly appreciated. >>=20 >> KS >>=20 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  2. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  3. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  4. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  5. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  6. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  7. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  8. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  9. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  10. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  11. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  12. [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
Results should look something like this: Info: Platform: unix-Macintosh OS X Product: WebDNA - Enterprise Edition Version: 6.2 Connected successfully SQLinfo reports: Host: localhost Server Version: 5.1.44 Client Version: 5.1.30 (Yes, I am still using WebDNA 6.2 on my Mavericks machine locally!) :-) On Apr 6, 2015, at 2:27 PM, Donovan Brooke wrote: > Keith,=20 > It=92s always good to be verbose when posting to a technical forum=85 = posting code, mysql version, etc... >=20 > Couple of things.. > ODBC only works with the older (and confusing) [SQL] contexts... = (those tags should be changed to [ODBC], and also checked over to make = sure they are still robust.. anyway=85) >=20 > If you are testing locally.. plant this template on your server and = copy / past the results back to the list. >=20 > *** CHANGE below to your actual password. ********* >=20 > =97=97=97=97=97=97START TEMPLATE=97=97=97=97=97=97=97=97=97=97 > > > >  > MySQL test > > > Info:
> Platform: [platform]
> Product: [product]
> Version: [version]

>=20 >=20 > [SQLconnect = dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dro= ot&pwd=3D&conn_var=3Dconn1] > Connected successfully

> [/SQLConnect] >=20 > SQLinfo reports: > [SQLinfo conn_ref=3Dconn1] > Host: [SQL_HOST]
> Server Version: [SQL_SERVERVER]
> Client Version: [SQL_CLIENTVER]
> [/SQLinfo] >=20 > > > =97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97 >=20 >=20 >=20 >=20 >=20 > On Apr 6, 2015, at 7:01 AM, Keith Scarzafava = wrote: >=20 >> Thanks for trying Stewart. >>=20 >> I am just trying to connect directly, not with iSQL. I installed = the unixODBC setup with MySQL initially because I was following what I = had found documentation wise at WebDNA and used ISQL just to verify I = had a working DSN. Since, I couldn=92t get it to work, I posted on the = WebDNA forums and Chris said to try here and pointed me back to the same = documentation I was already reading. I suspect it must be something to = do with WeDNA and CentOS then. =20 >>=20 >>=20 >>=20 >> Thanks for the assist. >>=20 >> Keith >>=20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au]=20 >> Sent: Sunday, April 05, 2015 7:15 PM >> To: WebDNA Talk List >> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> Keith >>=20 >> What I sent was all that I do. >>=20 >> Maybe Chris can confirm a few things about WedBNA=92s connection to = MySQL. >>=20 >> Other things to look at: >>=20 >> Does WebDNA return anything about MYCONNECTION not being found ? >>=20 >> Are you using a standard port (3306)? >>=20 >> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from = WebDNA, your setup may have a problem with going via ISQL. I also use = TSQL successfully to connect with MS SQL databases, unfortunately = working with MS SQL is not the same as working with MySQL via WebDNA. >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >> On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >>=20 >> Thanks Stewart!=20 >>=20 >> I gave your example a try. I was doing pretty much the same thing = with a basic query. I think my is I am not able to make the = connection to MySQL which is on the same server. I can connect with PHP = locally and remote just fine. Is there anything I need to do tell WebDNA = I am using MySQL other than the SQLCONNECT statement? >>=20 >> I am using the developer edition versions to see if this is the = route I wish to go. =46rom what I read, it=92s supposed to support = MySQL. Is this accurate? >>=20 >> Thanks for your time! >> Keith >>=20 >>=20 >> From: Keith Scarzafava [mailto:keith@scarzafava.com]=20 >> Sent: Saturday, April 04, 2015 8:21 PM >> To: talk@webdna.us >> Subject: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> I=92ve been trying to get my WebDNA to connect to MySQL and have not = been able to do so with version (6.2 with Centos5) or version (8.0 with = Centos6). I posted in the regular forums and was advised to try here. = Basically, I started out on my 6.2 WebDNA server and followed the setup = directions for the DSN setup which, I can connect to my MySQL via a DSN = with isql and perform queries and such. If I try to use WebDNA, I get = the error: MySQL not supported. If I tried to use the SQLCONNECT method = I get the error: INVALID VALUE (MySQL) FOR PARAMETER: type. >>=20 >> After a couple of postings in the forums, I was told I don=92t need = to use the DSN method because WebDNA supports MySQL natively (though I = tried both method). I then figured, I would give it a try on my version = 8 WebDNA server and, I still am getting the same exact messages. I=92ve = been sifting through any postings I can find and I can=92t find any form = of resolution. >>=20 >> Any help is greatly appreciated. >>=20 >> KS >>=20 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Donovan Brooke

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:

expired beta (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) WC2.0 Memory Requirements (1997) popups, netscape vs explorer (1997) Email within tmpl ? (1997) shipping costs (2000) OT: Outsourcing & copyrights (2005) Search and sort (2001) RE: [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) Where is f2? (1997) emailer settings and control questions (1997) What is WebDNA (1997) Windows nt service pack 3 upgrade (1997) Stop the madness. (1997) [WebDNA] Build Name for 6.1 (2008) NT [delete] - duh nevermind. (1998) [WebDNA] WebDNA slow processing (2011) [ShowNext] (2007) file upload type restrictions? (2001) W* 3.x & WebCat + WebMerchant (1998)