Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013

It keeps the original formatting. numero = 110473
interpreted = N
texte = --Apple-Mail=_4423618A-8E37-4E7C-BFDD-C664E5E655EAContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiSorry for the delay Stuart. I missed this message.Keep in mind I am on a winbox and it's as easy as setting up a DSN.Once that is done it basically straight SQL syntax.Here is one I was just working on:[SQL =dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&statement=3D=Update HRJOB_Jobs=20set=20onlinelocation =3D '[onlinelocation]',title =3D '[ConvertWords =db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]',=20Description =3D '[descSKU]',=20filled =3D '[skufilled]',=20datefilled =3D '[datefilledsku]',=20active =3D '[skuactive]' where JobSKU =3D '[sku]';][/SQL]Basically I can almost take any SQL and drop it in the [SQL] tag and =have it work. Some oddities every now and then will special characters. =But it works like a charm and is who we do almost everything with =WebDNA.HTHAlexOn Jun 7, 2013, at 9:02 PM, Stuart Tremain wrote:> Alex>=20> Would you please send me an example.=20>=20> I have a connection working using [SHELL] but would like to try with =the WebDNA method, i keep getting "Error: SQL not supported".>=20> I believe this to be true with the latest Linux build.>=20> Thanks.>=20>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20> On 25/05/2013, at 12:52 PM, Alex McCombie =wrote:>=20>> Yep.. I had it running at one point on a Mac version as well.>> The only trick is your OS needs to be able to setup an ODBC =connection to MSSQL.>> Webdna [sql] tag is just sending the SQL string to the ODBC and then =on to MS.>>=20>> Its pretty much the only way we do things now so the Data is also =simultaneously available to FMPRO, ACCESS, EXCEL, etc.>>=20>> Alex>>=20>>=20>> On May 23, 2013, at 7:13 PM, Stuart Tremain =wrote:>>=20>>> Thanks Alex, I knew that someone was connecting as I recalled some =mention of it on the list.>>>=20>>> I have a few issues with the Windows build and am moving everything =to Ubuntu and need to find a way to make the MSSQL connection. There are =a few tools around which I will check out over the next week but =wondered if someone was already doing it.>>>=20>>>=20>>> Regards>>>=20>>> Stuart Tremain>>> IDFK Web Developments>>> AUSTRALIA>>> webdna@idfk.com.au>>>=20>>>=20>>>=20>>>=20>>> On 24/05/2013, at 1:50 AM, Alex McCombie =wrote:>>>=20>>>> Don't know about the linux issue, but nearly all my code is Wedna =6.0 connecting to MSSQL Server 2000. 2005, 2008.>>>>=20>>>> We are running the windows version though and using the standard =System DSN for the ODBC connectivity.>>>>=20>>>> With only minor issues, we do this flawlessly.>>>>=20>>>> HTH>>>> Alex>>>>=20>>>>=20>>>> On May 22, 2013, at 12:21 PM, Jeffrey Jones =wrote:>>>>=20>>>>> [SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn=_var=3Dconn1]>>>>> Connected successfully>>>>>=20>>>>> [/SQLconnect]>>>>>=20>>>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1]>>>>> select firstName,lastName from employees;>>>>> [/SQLexecute]>>>>>=20>>>>> [SQLresult result_ref=3Drs1]>>>>> [numfound] records found
>>>>> >>>>> [founditems]>>>>> >>>>> [/founditems]>>>>>

First Name	Last Name
[firstName]	[lastName]

>>>>> [/SQLresult]>>>>>=20>>>>> On May 22, 2013, at 4:40 AM, Stuart Tremain =wrote:>>>>>=20>>>>>> Is it possible to connect to MS SQL with WebDNA 6.2 on Linux ?>>>>>>=20>>>>>> Regards>>>>>>=20>>>>>> Stuart Tremain>>>>>> IDFK Web Developments>>>>>> AUSTRALIA>>>>>> webdna@idfk.com.au>>>>>>=20>>>>>>=20>>>>>>=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>>>>>>=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>>>>=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>>=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--Apple-Mail=_4423618A-8E37-4E7C-BFDD-C664E5E655EAContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiSorry =for the delay Stuart. I missed this message.

Keep in =mind I am on a winbox and it's as easy as setting up a =DSN.

Once that is done it basically straight =SQL syntax.

Here is one I was =just working on:

[SQL =dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&=statement=3DUpdate =HRJOB_Jobs

set

onlinelocation =3D ='[onlinelocation]',

title =3D '[ConvertWords =db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]',

<=div>Description =3D '[descSKU]',

filled =3D ='[skufilled]',

datefilled =3D ='[datefilledsku]',

active =3D '[skuactive]' where JobSKU ==3D ='[sku]';]

[/SQL]

Basical=ly I can almost take any SQL and drop it in the [SQL] tag and have it =work. Some oddities every now and then will special characters. But it =works like a charm and is who we do almost everything with =WebDNA.

HTH

Alex

On Jun 7, 2013, at 9:02 PM, =Stuart Tremain <webdna@idfk.com.au> =wrote:

Alex

Would you please send me an =example.

I have a connection working =using [SHELL] but would like to try with the WebDNA method, i keep =getting "Error: SQL not supported".

I believe =this to be true with the latest Linux =build.

Thanks.
Regards

Stuart =Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au

On 25/05/2013, at 12:52 PM, Alex McCombie <info@adventureskies.com> =wrote:

Yep.. =I had it running at one point on a Mac version as well.
The only =trick is your OS needs to be able to setup an ODBC connection to =MSSQL.
Webdna [sql] tag is just sending the SQL string to the =ODBC and then on to MS.

Its pretty much the =only way we do things now so the Data is also simultaneously available =to FMPRO, ACCESS, EXCEL, =etc.

Alex

=On May 23, 2013, at 7:13 PM, Stuart Tremain <webdna@idfk.com.au> =wrote:

Thanks Alex, I knew that someone was connecting as I recalled some =mention of it on the list.

I have a few issues with =the Windows build and am moving everything to Ubuntu and need to find a =way to make the MSSQL connection. There are a few tools around which I =will check out over the next week but wondered if someone was already =doing it.

=
Regards

Stuart =Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au

On 24/05/2013, at 1:50 AM, Alex McCombie <info@adventureskies.com> =wrote:

Don't =know about the linux issue, but nearly all my code is Wedna 6.0 =connecting to MSSQL Server 2000. 2005, 2008.

We are =running the windows version though and using the standard System DSN for =the ODBC connectivity.

With only minor issues, =we do this =flawlessly.

HTH
Alex

On May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> =wrote:

[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&=;pwd=3Dpass&conn_var=3Dconn1]
Connected =successfully

[/SQLconnect]

[SQLexecute =conn_ref=3Dconn1&result_var=3Drs1]
select firstName,lastName from =employees;
[/SQLexecute]

[SQLresult =result_ref=3Drs1]
[numfound] records found<br>
<table =border=3D1><tr><th>First Name</th><th>Last =Name</th></tr>
[founditems]
<tr><td>[firstName]</td><td>=[lastName]</td></tr>
[/founditems]
</table>
[/S=QLresult]

On May 22, 2013, at 4:40 AM, =Stuart Tremain <webdna@idfk.com.au> =wrote:

Is it possible to connect to MS SQL with WebDNA 6.2 on =Linux ?

Regards

Stuart Tremain
IDFK Web =Developments
AUSTRALIA
webdna@idfk.com.au

<=br>---------------------------------------------------------
This =message is sent to you because you are subscribed to
the mailing list =<talk@webdna.us>.
To =unsubscribe, E-mail to: <talk-leave@webdna.us>
archi=ves: http://mail.webdna.us/l=ist/talk@webdna.us
Bug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

=--Apple-Mail=_4423618A-8E37-4E7C-BFDD-C664E5E655EA-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Donovan Brooke 2013)
Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
[WebDNA] Connect to MS SQL (Stuart Tremain 2013)

--Apple-Mail=_4423618A-8E37-4E7C-BFDD-C664E5E655EAContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiSorry for the delay Stuart. I missed this message.Keep in mind I am on a winbox and it's as easy as setting up a DSN.Once that is done it basically straight SQL syntax.Here is one I was just working on:[SQL =dsn=3DDSNNAME&username=3DYOURUSERNAME&password=3DYOURPASSWORD&statement=3D=Update HRJOB_Jobs=20set=20onlinelocation =3D '[onlinelocation]',title =3D '[ConvertWords =db=3D/databases/Sqlconversions.db][titleSKU][/ConvertWords]',=20Description =3D '[descSKU]',=20filled =3D '[skufilled]',=20datefilled =3D '[datefilledsku]',=20active =3D '[skuactive]' where JobSKU =3D '[sku]';][/SQL]Basically I can almost take any SQL and drop it in the [SQL] tag and =have it work. Some oddities every now and then will special characters. =But it works like a charm and is who we do almost everything with =WebDNA.HTHAlexOn Jun 7, 2013, at 9:02 PM, Stuart Tremain wrote:> Alex>=20> Would you please send me an example.=20>=20> I have a connection working using [shell] but would like to try with =the WebDNA method, i keep getting "Error: SQL not supported".>=20> I believe this to be true with the latest Linux build.>=20> Thanks.>=20>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20> On 25/05/2013, at 12:52 PM, Alex McCombie =wrote:>=20>> Yep.. I had it running at one point on a Mac version as well.>> The only trick is your OS needs to be able to setup an ODBC =connection to MSSQL.>> Webdna [SQL] tag is just sending the SQL string to the ODBC and then =on to MS.>>=20>> Its pretty much the only way we do things now so the Data is also =simultaneously available to FMPRO, ACCESS, EXCEL, etc.>>=20>> Alex>>=20>>=20>> On May 23, 2013, at 7:13 PM, Stuart Tremain =wrote:>>=20>>> Thanks Alex, I knew that someone was connecting as I recalled some =mention of it on the list.>>>=20>>> I have a few issues with the Windows build and am moving everything =to Ubuntu and need to find a way to make the MSSQL connection. There are =a few tools around which I will check out over the next week but =wondered if someone was already doing it.>>>=20>>>=20>>> Regards>>>=20>>> Stuart Tremain>>> IDFK Web Developments>>> AUSTRALIA>>> webdna@idfk.com.au>>>=20>>>=20>>>=20>>>=20>>> On 24/05/2013, at 1:50 AM, Alex McCombie =wrote:>>>=20>>>> Don't know about the linux issue, but nearly all my code is Wedna =6.0 connecting to MSSQL Server 2000. 2005, 2008.>>>>=20>>>> We are running the windows version though and using the standard =System DSN for the ODBC connectivity.>>>>=20>>>> With only minor issues, we do this flawlessly.>>>>=20>>>> HTH>>>> Alex>>>>=20>>>>=20>>>> On May 22, 2013, at 12:21 PM, Jeffrey Jones =wrote:>>>>=20>>>>> [SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn=_var=3Dconn1]>>>>> Connected successfully>>>>>=20>>>>> [/SQLconnect]>>>>>=20>>>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1]>>>>> select firstName,lastName from employees;>>>>> [/SQLexecute]>>>>>=20>>>>> [SQLresult result_ref=3Drs1]>>>>> [numfound] records found
>>>>> >>>>> [founditems]>>>>> >>>>> [/founditems]>>>>>

First Name	Last Name
[firstName]	[lastName]