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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112254
interpreted = N
texte = This is a multipart message in MIME format. ------=_NextPart_000_029A_01D0703F.F13D2070 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=99t 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=E2=80=99s 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 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. From 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 =20 ------=_NextPart_000_029A_01D0703F.F13D2070 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Thanks for = trying Stewart.

=C2=A0=C2=A0=C2= =A0

=C2=A0=C2=A0=C2= =A0I am just trying to connect directly, not with iSQL. =C2=A0I = 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. =C2=A0=C2=A0Since, I = couldn=E2=80=99t 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.=C2=A0 =C2=A0I suspect it must be something to do with = WeDNA and CentOS then. =C2=A0

 

 

 

Thanks for = the assist.

 

Keith

 

From:= = Stuart Tremain [mailto:webdna@idfk.com.au]
Sent: Sunday, = April 05, 2015 7:15 PM
To: WebDNA Talk List
Subject: = Re: [WebDNA] Cannot get WebDNA and MySQL = working.

 

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.  From 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=99v= e 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

<= /blockquote>

 

------=_NextPart_000_029A_01D0703F.F13D2070-- 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)
This is a multipart message in MIME format. ------=_NextPart_000_029A_01D0703F.F13D2070 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=99t 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=E2=80=99s 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 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. From 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 =20 ------=_NextPart_000_029A_01D0703F.F13D2070 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Thanks for = trying Stewart.

=C2=A0=C2=A0=C2= =A0

=C2=A0=C2=A0=C2= =A0I am just trying to connect directly, not with iSQL. =C2=A0I = 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. =C2=A0=C2=A0Since, I = couldn=E2=80=99t 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.=C2=A0 =C2=A0I suspect it must be something to do with = WeDNA and CentOS then. =C2=A0

 

 

 

Thanks for = the assist.

 

Keith

 

From:= = Stuart Tremain [mailto:webdna@idfk.com.au]
Sent: Sunday, = April 05, 2015 7:15 PM
To: WebDNA Talk List
Subject: = Re: [WebDNA] Cannot get WebDNA and MySQL = working.

 

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.  From 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=99v= e 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

<= /blockquote>

 

------=_NextPart_000_029A_01D0703F.F13D2070-- "Keith Scarzafava"

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:

[WebDNA] Reserved variables (2009) Grep Help (2003) WebCatalog for guestbook ? (1997) User .db Questions (1999) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) MacAuthorize order data fields WAS:How To question... (1997) Separate SSL Server (1997) WebCatalog - Mac vs Linux (2000) This list needs a digest: rant, rave... (1997) WebCat2b15MacPlugin - showing [math] (1997) Help name our technology! (1997) Lookup Notfound (1998) Nested tags count question (1997) WebCat2 - storing unformatted date data? (1997) Date format question (1998) webDNA and ASP pages (1997) Quitting WebMerchant ? (1997) Multiple catalog databases and showcart (1997) A quickie question (1997) NT vs Mac (1997)