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

This WebDNA talk-list message is from

2015

It keeps the original formatting. numero = 112255
interpreted = N
texte = Keith,=20It=92s always good to be verbose when posting to a technical forum=85 =posting code, mysql version, etc...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)If you are testing locally.. plant this template on your server and copy =/ past the results back to the list.*** CHANGE below to your actual password. *********=97=97=97=97=97=97START TEMPLATE=97=97=97=97=97=97=97=97=97=97Info:
Platform: [platform]
Product: [product]
Version: [version]

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

[/SQLConnect]SQLinfo reports:[SQLinfo conn_ref=3Dconn1]Host: [SQL_HOST]
Server Version: [SQL_SERVERVER]
Client Version: [SQL_CLIENTVER]
[/SQLinfo]=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97On Apr 6, 2015, at 7:01 AM, Keith Scarzafava =wrote:> 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 Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015) RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015) RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015) RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015) RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015) Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015) [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)

Keith,=20It=92s always good to be verbose when posting to a technical forum=85 =posting code, mysql version, etc...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)If you are testing locally.. plant this template on your server and copy =/ past the results back to the list.*** CHANGE below to your actual password. *********=97=97=97=97=97=97START TEMPLATE=97=97=97=97=97=97=97=97=97=97Info:
Platform: [platform]
Product: [product]
Version: [version]

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

[/SQLConnect]SQLinfo reports:[SQLinfo conn_ref=3Dconn1]Host: [SQL_HOST]
Server Version: [SQL_SERVERVER]
Client Version: [SQL_CLIENTVER]
[/SQLinfo]=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97On Apr 6, 2015, at 7:01 AM, Keith Scarzafava =wrote:> 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 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:

[WebDNA] Nginx (2010) Adding a month and the 31st (bug?) (2002) Emailer (WebCat2) (1997) [WebDNA] FastCGI permissions on Ubuntu 16 (2016) docs for WebCatalog2 (1997) user flush db (2002) I am dumb. No see [variable] (2003) Webcat causing crashes left and right! (1997) F*** you (1998) orderfile stuff (1998) date format (another question) (2000) Help formatting search results w/ table (1997) Multi-Row Tables from a search. (1997) WebDNA Solutions ... sorry! (1997) Date search - yes or no (1997) Secure Server (1999) Problem with listfields with WC 4.0.2rc2/Webstar 4.4 (2001) Listfiles not listing mounted volume (2002) Who is doing sign-ups-got it (1998) creator code (1997)