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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112253
interpreted = N
texte = --Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Keith What I sent was all that I do. Maybe Chris can confirm a few things about WedBNA=E2=80=99s connection = to MySQL. Other things to look at: Does WebDNA return anything about MYCONNECTION not being found ? Are you using a standard port (3306)? 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. Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >=20 > Thanks Stewart!=C2=A0 <> > =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=E2=80=99s 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=E2=80=99ve 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=E2=80=99t = 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=E2=80=99ve been sifting through any postings I can find and = I can=E2=80=99t 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 --Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Keith

What = I sent was all that I do.

Maybe Chris can confirm a few things about WedBNA=E2=80=99s = connection to MySQL.

Other things to look at:

Does WebDNA return anything about = MYCONNECTION not being found ?

Are you using a standard port = (3306)?

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.


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 6 Apr 2015, at 00:03, Keith Scarzafava <keith@scarzafava.com> wrote:

Thanks Stewart! 
 
 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?
 
I am using the developer edition versions  to see = if this is the route I wish to go.  =46rom what I read, it=E2=80=99s = supposed to support MySQL.  Is this accurate?
 
Thanks for your time!
Keith
 
 
From: Keith = Scarzafava [mailto:keith@scarzafava.com] 
Sent: Saturday, April 04, 2015 = 8:21 PM
To: talk@webdna.us
Subject: [WebDNA] Cannot get WebDNA = and MySQL working.
 
I=E2=80=99ve 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.
 
After a couple of postings in the forums, I was told I = don=E2=80=99t 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=E2=80=99ve been sifting through any = postings I can find and I can=E2=80=99t find any form of resolution.
 
Any help = is greatly appreciated.
 
KS
 
 
--------------------------------------------------------- = 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

= --Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8-- 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)
--Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Keith What I sent was all that I do. Maybe Chris can confirm a few things about WedBNA=E2=80=99s connection = to MySQL. Other things to look at: Does WebDNA return anything about MYCONNECTION not being found ? Are you using a standard port (3306)? 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. Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >=20 > Thanks Stewart!=C2=A0 <> > =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=E2=80=99s 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=E2=80=99ve 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=E2=80=99t = 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=E2=80=99ve been sifting through any postings I can find and = I can=E2=80=99t 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 --Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Keith

What = I sent was all that I do.

Maybe Chris can confirm a few things about WedBNA=E2=80=99s = connection to MySQL.

Other things to look at:

Does WebDNA return anything about = MYCONNECTION not being found ?

Are you using a standard port = (3306)?

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.


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 6 Apr 2015, at 00:03, Keith Scarzafava <keith@scarzafava.com> wrote:

Thanks Stewart! 
 
 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?
 
I am using the developer edition versions  to see = if this is the route I wish to go.  =46rom what I read, it=E2=80=99s = supposed to support MySQL.  Is this accurate?
 
Thanks for your time!
Keith
 
 
From: Keith = Scarzafava [mailto:keith@scarzafava.com] 
Sent: Saturday, April 04, 2015 = 8:21 PM
To: talk@webdna.us
Subject: [WebDNA] Cannot get WebDNA = and MySQL working.
 
I=E2=80=99ve 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.
 
After a couple of postings in the forums, I was told I = don=E2=80=99t 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=E2=80=99ve been sifting through any = postings I can find and I can=E2=80=99t find any form of resolution.
 
Any help = is greatly appreciated.
 
KS
 
 
--------------------------------------------------------- = 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

= --Apple-Mail=_4745D5BC-D00F-4C5C-9F08-73F7546232E8-- 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:

OT - royalty free images (2002) Pithy questions on webcommerce & siteedit (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Nested tags count question (1997) WebCatalog2 Feature Feedback (1996) random in arizona (2003) [LOOKUP] (1997) Calendar (1997) F3 crashing server (1997) [isfile] ? (1997) Setting up shop (1997) Instructions for Digest (1997) bug in wn searching NT version? (1997) Shared conversion under WebTen (1998) A multi-processor savvy WebCatalog? (1997) Ongoing group search problems ... (1997) [WebDNA] WebDNA future (2010) flushdatabases (2000) Security (1999) Menu Madness (2001)